Parallel job reports failure (code 138)

umlaut · Post by **umlaut** » Thu Jul 13, 2006 3:47 am

I couldn't find any info on this fatal error, so when I resolved it I thought it would be useful to post the solution. Hope it helps.

The problem stemmed from trying to extract data from Oracle 10g using the Oracle Enterprise stage. The failure was caused by the view I was using in Oracle. One of the fields only contained null values. Altering the view to include nvl on the offending field resolved the problem.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 13, 2006 5:27 am

Welcome aboard, and thank you for a useful first post. :D

kumar_s · Post by **kumar_s** » Fri Jul 14, 2006 12:31 am

Thanks umlaut ,
It seems the Code 138 is all due to the external system, which coudnt be recongized by DS.
I once faced DB2 called by UNIX.