DSXchange

I am facing the same Error through i have compiled with out warning.

Error:

After-job routine returned error: Error variable unassigned on return from AFTER routine DSU.SetFileDelete

SetFileDelete -> Rounie Name

calling this in after job routine to delete a file. Please advice me..

Thanks. Used HashFile insted of Sequence File and kept primary keys. so it capture the value in the right column.

Hi

Yes... First 6 run parallel and consequent manner.. If any one job get failed should condinue the next one with out Abort. Same time when i restart the sequence expected to run which are aborted.

If i enable Add checkpoints it will abort if any one jobs get fails in that sequence.

Raja

Thanks for your detail code. Much appriciated. It helps me to solve my issue.

Hi I am running a master sequence which contain 20 sub Sequence. Each sub sequence has 6 jobs to run parallel. 20 Sub sequence propeties in Trigger tab 'Expression Type' defined as Uncontidional. so all jobs run if one job gets failed also. I would like run a sequence to restart the failed jobs (Abo...

Thanks for your inputs.. Now i can able to run DS jobs as server has been restarted.

can i have your person id. SO i can share that error file and it make you understand well. As i hvae checked the jobs... as its a template.. So column shouldn't be misplaced.

I have checked it out... But all the jobs are running parallel so i am owndering it make mess up something..

boz i am useing the same Template for all the jobs..

I capture that error in the Transformation

Linkname.DBMSCODE

Thanks for your kind response. It returns Error code is ORA-00001 Unique Constraint Error. As i have mention its a 1-1 mapping. Reading from the Oracle source and Writing to Sequential FlatFile and Next Stream Reading Data from SFF to Oracle 9i database. In the second stream when try to load the dat...

I am waiting for some one hand.,,

Hi... Issue is when i run any job Test_Job.Event: ORA-28000: the account is locked. Tried with the wrong passport more than 3 times. but the database is not locked as i can able to access via the same schema with some other project. It mean problem with DS. Could you advice earliest how to over come...

Hi Oracle 91 - > Sequential File - > Target Data Extract from Oracle and load to Sequential file (1-1 Map). The rejected records are captured using a shared container for all jobs. When writes the rejected records to sequential file values are some of the jobs not writing properlay. Ex. Error_Code e...

As narasimha explained to try to use the first one bulk loader and that will not create a control file with the extension of .ctl as well for data file. Try to create a shell script and move the file with extension and use the sqlldr command in that file. Execturte that shell after the job routine. ...

Thanks. Its works fine. COL1 doesn't exist in the metadata as some user has been alter the table.