TIME OUT ERROR

[Former Member]

Hi Gurus ,

I got the time out error message , when i try to run customized report . Here below i mentioned the error report from st22 tcode .

After a certain length of time, the program is terminated. In the case

of a work area, this means that

- endless loops (DO, WHILE, ...),

- database accesses producing an excessively large result set,

- database accesses without a suitable index (full table scan)

do not block the processing for too long.

The system profile "rdisp/max_wprun_time" contains the maximum runtime of a

program. The

current setting is 5000 seconds. Once this time limit has been exceeded,

the system tries to terminate any SQL statements that are currently

being executed and tells the ABAP processor to terminate the current

program. Then it waits for a maximum of 60 seconds. If the program is

still active, the work process is restarted.

successfully processed, the system gives it another 5000 seconds.

Hence the maximum runtime of a program is at least twice the value of

the system profile parameter "rdisp/max_wprun_time".

KIndly advice me

Regards

Palani Selvan .S

[Former Member · Accepted solution]

Hi gurus ,

I increase the time also , but i facing the same problem , Iam not able to ran in back round also . Kindly tell me any other way to resolve the problem .

Regards

Selvan

[former_member603052 · Accepted solution]

Hi Selvan,

You need to schedule background jobs in SM36 TCode

Give jobname and click Step Button at the top

Now Click ABAP Program button and below give the program name(Z.......) you need to run

Then Click Save icon at bottom

Now click Start Condition and select the time you want to run this job

and finally Save it and see that the job is scheduled or released in sm37

Regards,

Kalyan

[Former Member · Accepted solution]

Hello,

you should analyze this with an developer and for instance run an SQL trace.

Christian

[Former Member]

please try to find out the expensive SQL and ask ur abaper to tue the SQl

regards

George

[Former Member]

ok

Thanks

selvan

[former_member204746]

someone ran a program in a dialog work process that took over 5000 seconds (roughly 75 minutes). After 75 minutes it was still running.

so, ask the user to send this program in the background instead.

[Former Member]

Hello,

if the report has a selection screen you can enter the selections and then choose from the menu PROGRAM - EXECUTE IN BACKGROUND.

If this is not possible use transaction SM36 to create an job, enter Jobname and choose the button STEP where you can enter the report. Save this and choose START CONDITIONS - IMMEDIATE and disselect PERIODIC JOB. Save the start conditions and the job. Now you can monitor it per SM37.

I would also suggest to make an SQL trace per ST05 to get expensive SQL statements.

Greetings

Christian

[Former Member]

Hi Brink

Thanks for your reply , Kindly tell me how to run this in backroud , Kindly tell me the steps .

Regards

Palani Selvan

[former_member603052]

Hi,

We can schedule background jobs in SM36 TCode

Give jobname and click Step Button at the top

Now Click ABAP Program button and below give the program name you need to run

Then Click Save icon at bottom

Now click Start Condition and select the time you want to run this job

and finally Save it and see that the job is scheduled or released in sm37

Regards,

Kalyan

[Former Member]

> KIndly advice me

that's difficult if you don't ask questions

But i try to...

- if it's a Z-report, tune the report

- run the report in background

- set the parameter to a higher value (only advisable, if you can make sure to have enough free dialogue-processes all the time)