DSXchange

Folders that you mean is Repository where jobs are located. I am aware of the location where jobs are saved and job needs to be re-created.

Ray, I am getting error msg as "general repository interface 'other error'" in sequence and job level at times. I have searched inthis forum and found jobs need to be copied and renamed. Since I have more jobs, i need easiest way to acheive this.

let me know if you have any questions.

Hi, A master sequence which consists of 50 Sub-sequence is failing on daily basis due to controller problem. I need to copy and create the master sequence as a new master sequence ie, all the jobs (around 500 jobs) and Job sequence needs to be copied and re-created. Please advice the easiest process...

Thanks for the info provided. Issue has been resolved now by filtering policies which has wrong data.

Chulett, you are correct with first point. Can you explain more on this. I am having delimiter as | (pipe). I have checked both input and Ouput has same demlimiter.

Where to check the quoted string

Improper & junk data - having wrong metadata. Policy number filed is having name of the policy holder.

I viewed the data in Datastage and able to see difference in Input (data wrote to file) and output. Input data (data wrote to file) is looking correct and Ouput data seem to improper and junk data.

I am able to see the solution provided by you on Tue Nov 17, 2009 10:49 am in other post for the same issue. Since I am not a premium member, I am not able to read completely. if possible could you please update the same in this post also. Thanks in advance!!!

Ok chulett. I have checked the path, metadata etc. Everythink looks fine. I have changed the Incomplete column action to Error. Please advice now.

My job design is Seq -> link Partitioner ->Link Collector -> Seq -> Transformer - hash/Seq I am getting error in 2nd Seq file (CSV file) stage while moving data to transformer. I am getting error message " read delimited: ron 1 "Column name" required column missing. I have the delimit...

Job design will be ODBC -> Seq file -> transformer -> oracle stage

I am alos getting the same error. Is there anyone to advise?

I am getting an error as below in the recent past. Call to SQL failed. [DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver]The DataDirect ODBC driver you are attempting to access has been provided to you by IBM Information Integration Solutions for exclusive use with IBM WebSphere Data ...

I am getting Timeout error while running 2 jobs parellely, since jobs are scheduled I am not able to control. So could you please advice any permanent solution for this. So that I can aviod manual intervention to rerun the job. I check with my DBA and there is no lock or issues in database.

Will logs be stored anywhere in the server or machine. Is there any possibility to do so.... please advice.