Job not failing despite of Fatal error

[anugrah86]

Hi,

In a parallel job, I am extracting data from a JD Edward system (running on AS400) using ODBC stage.

The job is completing without any warning, but on looking in the job details I have found Fatal error as below:

[DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]FAILED EXECUTION DUE TO DEADLOCK/TIMEOUT. REASON JDEDTA.F4211 TYPE TABLE

Can anybody tell, why this job is not getting aborted despite of Fatal error. There is no message handler corresponding to this.


Thanks in advance.
~ Anugrah

[DSguru2B]

The connection to the database needs to be killed. Get in touch with your dba and ask him to kill the session. THat should abort your job.

[mk_ds09]

Hi..

this seems to be issue with DS version..
I was knowing one of the fatal error which is related to database stage and job was not aborting due to that error..

I guess it will need a patch from DS..

btw check out the both db and ds versions and corrosponding patches ..

hope that will help..

------------

MK