DSXchange

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...

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

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

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.