Error: Work process restarted; session terminated.

[Former Member]

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

[former_member156446]

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

[HermannGahm]

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

[Former Member]

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

[Former Member]

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