DSXchange

Hi All , Just got the couple of following warnings . main_program: When deleting data set /input/acct_type_desc.ds, previous delete attempt not complete; removing /input/acct_type_desc.ds.being_deleted in order to proceed. When ran the job again in the next minute it ran fine. Why was the warning co...

ray.wurlod wrote:Did anyone change APT_CONDUCTOR_HOSTNAME environment variable?

Thanks for your response Ray , How/where do I check If the the enivornment value got changed?

Thanks in advance.

Hi All ,

I am now getting following error when I run the job , which was running fine few minutes ago too.

BAI_FAS_History_File: Error when checking operator: No conductor nodes found in export node pool.

what does that error mean?? I am getting all these weird errors today .

Thank you all.

chulett wrote:Config file issue. Search here for "The configuration does not contain the invoking node".

After few minutes the same job ran fine without changing any settings or parameters...

I donot get why I got this error.

Any thoughts greatly appreciated.

What does the following error mean?

main_program: Fatal Error: The configuration does not contain the invoking node dstaged1.hew.us.ml.com.

That is the error I am getting when I am running a copy (just the design not parameters and stuff) of orignal job.


any thoughts greatly appreciated.

Permissions or (lack of) space issues, usually. Can you check? Thanks Craig for your response. What kind of space issue? I mean where is the space issue coming from is it no space in the repository. How can this be fixed? This the job I have created , so doesn't look like permission issue to me.. T...

Hi All, Error while creating job BAI_FAS_Files_1105_bkup Error on CREATE.FILE command (Creating file "RT_LOG734" as Type 30. mkdbfile: error initializing file. Unable to create operating system file "RT_LOG734". *** Processing cannot continue. *** ) I am trying to save existing j...

ray.wurlod wrote:Stage variables? Other expressions in the Transformer?

After taking out the above derivation it was not giving any such warning..

No such functions used in the stage variables.

Any thoughts greatly appreciated.

Don't allow null to reach any Transformer stage function or stage variable; they are all intolerant of null. (This is optionally relaxed in the next version of DataStage early next year.) Thanks for your response Ray , I tried doing following way still it didnot work. If IsNull(out_rec.TradeNotiona...

Hi All ,

I am getting a null warning

Transformer_47,1: Null string argument.

What does that mean exactly?
Any thoughts how to fix it.

Thanks in advance.

chulett wrote:Depends on if this is a data field or part of the file's name. For the former, I'd check out 'DateFromDaysSince' with today's date and a "-1".

Somehow this didnot work Craig.

DateFromDaysSince(DaysSinceFromDate
(CurrentDate()) - 1)

Thanks for your response Craig...



I tried the following it worked.

DateFromJulianDay(JulianDayFromDate(CurrentDate()) - 1)

Hi All,

How to write yesterday's date in an output file csv file?

I know we can write today's date as CurrentDate() .

Any thoughts greatly appreciated.

Thank you all.

Hi All ,

Can I have an empty designer page and Job control page and just use the job to call before and after routine .

Any thoughts greatly appreciated.

Thank you all.

I have checked the post here http://www.dsxchange.com/viewtopic.php?t=127535&postdays=0&postorder=asc&start=15 so from my understanding is it an ignorable warning , what does that mean actually. Any inputs greatly appreciated. Pivot_SSNs,0: Invalid character(s) ([xA9]) found converting s...