DSXchange

In my job i am writing from the lookup rejects link to a col generator and then to transformer and finally to a sequential stage. I have a constraint on the transformer stage to abort the job after 1 row is rejected from lookup stage and this 1 row should be written into the sequential file before t...

Can you post here the message that appears in your job log of the director?

Probably that can help us to diagnose the error you are getting.

And you didn't reply back the Ray's questions?

Thanks,
Srikanth

I believe this error is very misleading. I am going through the error message you have posted. DSRunJob(GFSTCPMCWJ2150AcctDeptCdc. 1) Is the option "Allow Multiple Instances" enabled in your sequence? It should have been enabled. That's why the job name is followed by a .1 But why you are ...

I too go by what eric said. Some tools / softwares have a timeout set for the license to be released. So, once the software is used the license will get released only when the tool idle time exceeds the specified timeout. ClearCase, ClearQuest are examples of such tools. But I am not sure of this C+...

To add more and make it clear, Actual problem is not the error "Job aborting due to row limit being reached on output link:" Actually I want the job to abort with this error if any row gets rejected from lookup stage. The problem is - when the row gets rejected from lookup the job aborts b...

Actually me too had a similar problem. A bit funny. In my job i am writing from the lookup rejects link to a col generator and then to transformer and finally to a sequential stage. As eric and ray mentioned, I have a constraint on the transformer stage to abort the job after 1 row is rejected from ...

Hi Leo,

Thank you for the fix. No warnings are coming after changing the preceeding stage "Preserve Partitioning" flag to "Clear".

Me too don't like to see warnings as long as they can be avoided.

Thanks anyway.

Srikanth

Here is the fix for this issue. Proper rights should be given to the folder C:\Program Files\Ascential\DataStage so that the xml file used for compilation can be written. It means all the users who need to work on DataStage should have write permissions to this folder. This situation arises when usi...

We are using Citrix to work on DataStage from a remote location. Probably the problem is in using Citrix. As, of now the problem got resolved. I will post the solution once i come to know what resolved the issue. For time being, when the same issue is posted in Ascential forum, we got some useful in...

From CDC output the records to a transformer. When the change code is "3" the record should be both updated (probably logical delete or whatever update needs to be done for the existing records) and freshly insert again with new values. So, in the transformer send the insert records and up...

Hi Everyone, I have created 3 parallel jobs and all 3 are running fine. Now, when i try to sequence these jobs, I get a compilation error. The error message is pasted below. <JobSeqGenError> <Code>2017</Code> <Desc>XML parser error on input line 0: source='', reason='The system cannot locate the res...

Thank you

Hi, I am getting a warning message while validating my job. I am writing the trailer records into a sequential file using tail stage and i am getting this datastage warning: Sequential_File_12: When checking operator: Sequential operator cannot preserve partitioning of parallel dataset on input port...