DSXchange

Thanks for your reply::

We never set the files to read in parallel/Multiple node.
Yes the files are fixed width.
When in Designer , this property can check/uncheck ?

Thanks,
Sri

Issue resolved. Well. The final step which I took is to replace the link with new one. It worked. Does this indicates the stage/link got corrupted ? Well another intresting thing which I noticed is that, in general when we keep a sequentail file stage and either if we are reading from or writing int...

Well !!! In digging more to find root cause for this, interstingly, it was found that, we are unable to view the data through designer of any of the sequential files. While we try to do.. after a while [Not Responding] message is appearing and the desinger is closing. I tried to view data of differe...

The log shows that pid's are created and then the log doesn't get updated so you can take the player pid's and go to the node where they are running and run ps command to see if all those pid's keep running or did the player pid's finish after execution and then check if the section leader finish t...

ray.wurlod wrote:There are a number of ways in which it can work. Typically changes to the database are captured by reading the transaction log (though triggers can also be used); these changes are placed onto an MQ ...

Is there difference between,,, Change Data Delivery & Change Data Capture ? If so what ?

Thanks Zulfi... If you say that there might be problem with target db, i tested the job even without before/after routines, the job successfully loaded the records into the target table. So do you think it more concerns over target table ? More over, I used the SHOW_PIDS.. and all processes were run...

I added it and tested.. but no luck... :( it got again stucked ... it is waiting for some thing.. which I am not able to figure out..... If I removed the BeforeJob/AfterJob Sub-Routines, then it is working. If you say, that there is problem with BeforeJob Routine,then, it was clear from logs.. that ...

Read the 3rd (date column) as Varchar(10). In transformer use the below expression. For null values we are giving a default value of '12/31/9999'; If you want null then specify SetNull(); If Trim(date_column) = '' Then StringToDate("12/31/9999",'%mm/%dd/%yyyy') Else StringToDate(date_colum...

Yes, we did check on database side as well. There are no locks on target table.

Added the APT variables; main_program: This step has 6 datasets: ds0: {op0[1p] (sequential fsqSrcAMBSsel) eAny<>eCollectAny op1[2p] (parallel APT_CombinedOperatorController:{natural=mdf, synthetic="modify(0)"})} ds1: {op1[2p] (parallel APT_CombinedOperatorController:APT_TransformOperatorIm...

Yes. I tried many options and none of them worked... All are skipping the milliseconds part What is your Target , is it Database or file ? As specified by Chandra , you can use StringToTimestamp('Columnname',"hh%nn%ss.3") will work. Enable Extended propery to "milliseconds" if y...

Thanks ArndW,

I added APT_DUMP_SCORE, but I could not able to locate the 'report player calls' or 'report process ids' which you mentioned. How to check for the processes on ds server on "osh.exe" ?

Thanks...

Thanks ArndW & SURA... ArndW: I am using the DSLogInfo() -- "Record inserted successfully into Job Audit Table"; In fact this statemtent should pop out to DS log if record inserted successfully. If no return code from then go to ErrorExit section in routine. To check more log, I used $...

DS Job Design is SEQfile -> MdfyStg -> TrnasfrStg -> FunlStg -> SQLEnterpriseStg. Functionality:- The job reads 1 file at a time and loads into target table. I am maintaining a different table called AuditTable , which is handled by BeforeJob & AfterJob SubRoutines ( Collects, file count, file n...

How to change ulimit?