topic Re: Work process re-started , session terminated in Application Development and Automation Discussions

Work process re-started , session terminated

Former Member — Mon, 18 Aug 2008 09:40:55 GMT

Hello,

Very Good Afternoon!

I have an issue with a report program. When I am executing this program in Other testing server it is executing without any issues.

But when I tried to execute this program in QA server, it is throwing this error message.

"Work process re-started , session terminated" ...Also when I tried to check with runtime analysis 'SE30' it shows that Datbase is handling lot of load.

I am sure that this could be an issue with any select query in the program. How can I check which select query is taking how much time in the program?

Any suggestion would be appreciated!

Regards,

Kittu

Re: Work process re-started , session terminated

Former Member — Mon, 18 Aug 2008 09:43:12 GMT

Hi,

you can trace your program. e.g. ST05

Regards

Nicole

Re: Work process re-started , session terminated

GauthamV — Mon, 18 Aug 2008 09:44:04 GMT

hi,

u can check the time taken by a select statement in ur propgram by se30 or st05 transaction.

after u click analyze button in se30.on top there is one icon in app tool bar,click that,it will show time taken by each statement.

Re: Work process re-started , session terminated

Former Member — Mon, 18 Aug 2008 09:47:54 GMT

Hi Kittu,

How to run Trace :

1) Go to ST05

2) Activate trace with filter

3) Run the program in background

4) as you get the output.

5) go to ST05 nad deactivate the trace

6) click on analyse button.

SDN Library - Standard Reference - How to analyze performance problems - Trace

SDN Library - Standard Reference for Performance Analysis in a Nutshell

SDN Library - Standard Reference - Best Practices for Performance Tuning

Source: https://forums.sdn.sap.com/click.jspa?searchID=15266783&messageID=5889261

Have A Good Day

Chaitanya.

Re: Work process re-started , session terminated

Former Member — Mon, 18 Aug 2008 09:49:55 GMT

I too faced the similar problem some time back. I just restarted my system and Tried it once again , I am able to run the programs/Transactions with out having any issues.

May be this works in your case too...

Re: Work process re-started , session terminated

Former Member — Thu, 13 Nov 2008 17:10:38 GMT

Hello,

I am sorry for the late response!

The suggestions and information was helpful and I really appreciate it.

Regards,

Kittu