Failed job showing job status OK

[tsamui]

Hi all,
In my parallel job my target table is one Oracle table which has indexes and one primary key.
I am using oracle enterprise stage and put the index mode option Rebuilt.
When any duplicate record come from input, it load the duplicate data in target and showing job status is OK, finish with warnings. But when I open the job log it showing fatal error with message --------

Oracle call failed; sqlcode = -12,801; message: ORA-12801: error signaled in parallel query server P003
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found,

If this kind of error happens, I want the job status should be in aborted state. How I will achieve this?

[ray.wurlod]

In an after-job subroutine check the log for this particular warning and set the ErrorCode argument to a non-zero value.

Code: Select all

FindStr "ORA-12801" In DSGetLogSummary(DSJ.ME,...)
Then ErrorCode = 1