topic Re: Error: Work process restarted; session terminated. in Application Development and Automation Discussions

Error: Work process restarted; session terminated.

Former Member — Wed, 12 Aug 2009 05:05:14 GMT

Hi,

In one of my program, I am getting the error- "Work process restarted; session terminated" and job is getting cancelled.

When I executed in debugging mode, for one of the select queries this error is shown. I do not get any runtime error for Time Out issue.

How can I resolve the issue.

thanks,

Arun

Re: Error: Work process restarted; session terminated.

former_member156446 — Wed, 12 Aug 2009 05:06:58 GMT

I am guessing it could be some Enque or Deque issue..

Re: Error: Work process restarted; session terminated.

HermannGahm — Wed, 12 Aug 2009 07:03:23 GMT

Hi Arun,

on DB2 for LUW (DB6) i have seen this behaviour with large FOR ALL ENTRIES SELECTS.

If you are on DB6 and your SELECT is a FAE you have to reduce the result set (packages or whatever).

If it is not an FAE on DB6, could you please post your SELECT statement and DB (version) here?

Kind regards,

Hermann

Re: Error: Work process restarted; session terminated.

Former Member — Wed, 14 Oct 2009 06:08:07 GMT

Hi All,

I am too getting a similar error while trying to Read the data.

I tried debugging...and it gives the error while calling the GUI_UPLOAD Function module.

Please let me in case of any inputs

Re: Error: Work process restarted; session terminated.

Former Member — Wed, 14 Oct 2009 12:53:14 GMT

Hi,

Work process restarted; session terminated

This is not an error in your application code, but a problem deeper down in the kernel, causing the work process that was handling your context to abort and restart. You should run txn ST11 and look at the most recently changed work process traces (dev_w*) to find out what happened.

Regards,

Mark