DSXchange

I have a query on the DB2/UDB stage while loading into it with "Write" method. 1: Is the job going to failed if the same record already exist in the table? 2: If yes, Is there any option to ignore this inserting failure with 'Write' method? 3: Is it the same case with DS8 version as well o...

I haeve not used the 'MDT_REAL_FX_GL_REC_PAY_AM' column in input link to the funnel still getting following error When checking operator: Defaulting "MDT_REAL_FX_GL_REC_PAY_AM" in transfer from "inRec" to "outRec" Could any one tell me how to remove this warning. Thank...

ArndW wrote:Does your config file reference multiple nodes?

Yeah, Config file reference to multiple node.

ray.wurlod wrote:Is this repeatable? Or could it have been a transient glitch in the network?

Yeah. Facing this issue now multiple time only with same matchine. Glitch in netwoks! but wondering how it could affect one matchine (not sure). Local admin perhaps right guy to answer. Anyway thanks

Jobs are not running and throwing below error: main_program: The section leader on <DB2 Server> died main_program: **** Parallel startup failed **** This is usually due to a configuration error, such as not having the Orchestrate install directory properly mounted on all nodes, rsh permissions not c...

The original jobs is fine and compiling OK. Wondering whats the issue. As i have already taken so many copy of that job and getting same error in all copied job.

Yeah, i do have proper access to it.

I have so many jobs in same project which i dont have any issue during compilation. But whenever i am taking a copy of one job and compiling again, in copy job its throwing the error.

Thanks

Hi

Could anyone help me to understand the below error which i am getting on compile time

"Error Writing To RT_CONFIG4700" (UKDWXXXTransxxxjob). How to overcome it.

Thanks

Thanks Craig for this quicky.. Hope this will retrieve all logs details within the project.

Hi all

is there anyway to see DS job logs through any other method other then director?

Thanks

You are keeping all the job names in souce file? If yes try to put one comma (,) after each job name and then run your job.

Let me know if any luck.

Did you try using the macro instead? Did you try looking up the error codes? They are documented. ... Could you try with the below macro and check if its working fine.... $include DSINCLUDE JOBCONTROL.H JobName=Arg1 JobHandle = DSAttachJob (JobName, DSJ.ERRFATAL) controllerList=DSGetJobInfo(JobHand...

ray.wurlod wrote:Have you set a Null Field Value property for each of these fields? For example if you have set ten spaces as the Null Field Value of a Char(10) field, then the import operator will convert this to NU ...

Thanks Ray, Could you please let me know ehre to set these values in the stage.

Hello I hve a fixed with file. lets take below example with data types and size:- ACC_NO=Bigint(10) COL1=Char(4) COL2=Char(5) Seq file -> Trnasformer -> Target file I am doing a small validation on ACC_NO in transformer stage. i am checking if the ACC_NO is null or spaces then it will reject these r...

ArndW wrote:If the first line is DD2009 and you wish to ignore it, then skip the first line. The CFF stage doesn't directly let you skip n-lines, but just use the "Filter" option with "tail -n +2" ...

N means number of records? No idea of number of records.