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????
A job getting aborted when target table is truncated.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 2
- Joined: Sat Feb 21, 2009 11:44 pm
-
- Premium Member
- Posts: 36
- Joined: Wed Dec 27, 2006 3:50 am
- Location: Phoenix
-
- Participant
- Posts: 2
- Joined: Sat Feb 21, 2009 11:44 pm
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]
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]