Parallel job reports failure (code 139)

gssr · Post by **gssr** » Mon Dec 27, 2010 2:47 am

I am having a job design as follows,

Oracle Enterprise Stage ---> Transformer ----> Netezza Stage

Here, i am just truncating and loading the Neteza table from the table from oracle.

We are not using any Query to fetch the records from ORACLE. We are using Read Method as "Table"

In Target Netezza Stage,
Load Method as "nzload"
Write Mode as "Truncate"

But i am getting the error as,
Parallel job reports failure (code 139)

I searched the forum and tried some options,

Calling the envitonment variable $APT_NO_JOBMON to the job and set it to 'True'

Still we are facing the same issue.
Please suggest some solution for this...

gssr · Post by **gssr** » Mon Dec 27, 2010 4:22 am

Forget to mention ,
The above mentioned job ran fine last week. Let me know if you need any othre information.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 27, 2010 3:16 pm

You have marked this thread as Resolved. Please post HOW it was resolved, to aid future searchers.

gssr · Post by **gssr** » Mon Dec 27, 2010 10:53 pm

The metedata in the table and the stages are not matched. The issues are resolved by changing the metedata in the stages with respect to the table structure.

But i am puzzled, why i couldnot get any error like "Column mismatch " or "Column not found"

Suggestions are welcome.