A job getting aborted when target table is truncated.

dstage1234 · Post by **dstage1234** » Fri Mar 27, 2009 12:00 am

There is a job in Product Quality which is getting aborted when the target table is truncated before the run but the same no. of rows are getting populated as before although the job is getting aborted.

Now,suppose the target table is having the records.When the job is rerun,it is getting finished successfully.

This parallel job was running fine in DataStage 7.5.2 whereas we are facing the problem in Datastage 8.1.
The job has Dataset as the source,the target is Oracle and transformer to transform according to the business logic.The rejected records from the Oracle stage are written into a Dataset.

Why it is happening????

anand_dafaria · Post by **anand_dafaria** » Fri Mar 27, 2009 3:27 am

Post the Fatal error which you are getting in the log when the job aborts. This will make it clear what is happening.

dstage1234 · Post by **dstage1234** » Fri Mar 27, 2009 4:37 am

The 3 fatal error in the job are:

1."Ora_Return,0: Unable to insert a record into the table. [oraUpsert.C:1851] ".

2.Ora_Return,2: The runLocally() of the operator failed. [api/operator_rep.C:4029] .

3.Ora_Return,0: Operator terminated abnormally: runLocally() did not return APT_StatusOk [processmgr/rtpexecutil.C:199]