on 02-26-2009 8:30 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
please try to find out the expensive SQL and ask ur abaper to tue the SQl
regards
George
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
ok
Thanks
selvan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Brink
Thanks for your reply , Kindly tell me how to run this in backroud , Kindly tell me the steps .
Regards
Palani Selvan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
> 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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.