Work process re-started , session terminated

[Former Member]

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

[Former Member]

Hi,

you can trace your program. e.g. ST05

Regards

Nicole

[GauthamV]

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.

[Former Member]

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.

[Former Member]

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...

[Former Member]

Hello,

I am sorry for the late response!

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

Regards,

Kittu