DSXchange

I thnk there must be some new line char which cant be read and load correctly. I used substring function to only leave 75 varchar and job runs ok. now I know how the log does not always give meaningful information.

Hi DS Guru I have job which read data source and insrt or update dimension using SCD stage. One wired thing is it runs ok until I add new column in target table (add same column in refrence table too). becuase of this type 1 column, I got below warining. One or more values in the INSERT statement, U...

Hi the errors are APT_CombinedOperatorController(1),1: Failure during execution of operator logic. --repeat 3 times APT_CombinedOperatorController(1),0: Internal Error: (!exportLog_->hasError()): checksum/checksum.C: 379 Traceback: Could not obtain stack trace; check that 'dbx' and 'sed' are install...

Thanks for your reply.
I did do as you said and job aborted before I asked this question in this forum. Can anyone tell me any tricky thing I have to pay attention to make it work?

I try to build a common job to read any data set file and append checksum column and write the output into another dataset. In the source dataset file stage there is no column specified and I trun on the Runtime column propagation option. when I run the job, the job aborted with error message : PT_C...

the error shown in log is
Property ????????????????/ImageCopyFunction/Imag?? not valid in source context
This is really odd. anyone has similar experience?

If a change is detected, then kick off datastage job.

ray.wurlod wrote:In version 7 DataStage the MQ server needs to be co-resident with (on the same machine as) the DataStage server. Does your configuration satisfy this requirement? ...

thanks for your prompt reply.

ray.wurlod wrote:In version 7 DataStage the MQ server needs to be co-resident with (on the same machine as) the DataStage server. Does your configuration satisfy this requirement? ...

I know it must be on the same server and I was told like such as well.

hi all I need to connect message queue to retrieve data. After I set up queue manager name and queue name. then run the job. I had below error in the log Fatal Error: Fatal: Failed to connect to queue manager. Reason code 2058. I think I need to do more configuration on the message queue but I have ...

changming - if you specify link ordering you will get the order that you specify. ... Hi, ArndW, that is also what I thought it should be. But I do see the records are all mixed from different source. BTW, the link order are set automatically by datastage in a default order. But if I set the excuti...

I have five seqential files with some common filelds.All the sequential files have different metadata.The objective of my job is to append these seuentilal files one below the other to create a file layout of specific format. I have to use a funnel stage to combine these seuential files.How can I p...

I did a simple test, it did not work. records from source A and source B are writen to fileC though Funnal stage, which I set funnel type to Sequence. I checked the fileC, the order of the data are not as defined. records are random fixed SourceA and SourceB. I don't know where I am wrong. I think b...

ray.wurlod wrote:Can you please capture the report of link row counts for the Copy stage and post it? ...

Sorry, Ray. I don't know how to capture the report.

vrishabhsagar wrote:Do you get any warnings in the director? Something related to records getting dropped?

No warning. Job run successfully