08-31-2015 11:19 AM
Hi Experts,
I am facing time_out dump in one of the master data cif queue.
the error details are as below.
the dump is occuring while fetching data from /SAPAPO/MATLOTSZ table, the no of entries are 196940.
could someone guide me on this issue please.
Thanks in Advance
Regards,
Kushala
09-01-2015 1:40 PM
Hi,
What are the basic setting you have for time. Just discuss with basis guy.
Madhu.
09-02-2015 11:02 AM
Hi Madhu,
The time is 1500 seconds set, we are still facing the dump.
Do you have any other suggestions on this Please?
Regards,
Kushala
09-02-2015 12:49 PM
09-03-2015 5:41 AM
Hi Madhu,
We have done optimization to the code, still we have time_out dump.
is it becaus of the for all entries used in the second select query, as the no of records is 196000?
Thanks in advance
regards,
Kushala
09-02-2015 11:11 AM
Start optimizing your program (SAPLZxxx customer development) - Use tools as SAT (SQL statement or some wrong itab management in code) and ST05 (no index, multiple select single) to analyze cause of bottlenecks or performance issues.
Also consider convert program to background job, so no time-out.
The time is 1500 seconds
Already very long (far away from recommendations, but alas not unusual)
Regards,
Raymond
09-02-2015 11:26 AM
Hi Raymond,
Thanks for your suggestion.
Even after optmizing the program, i am still facing the dump.
we had similar issue in test system, after the code optimization we are seeing the dump in test system, where as the issue still exist in production.
i am attaching the prece of the code where the issue is occuring,kindly check and let m eknow your suggestions please.
09-02-2015 1:45 PM
Could you try to replace the two select statements with a single SELECT with JOIN or subquery, so removing the FOR ALL ENTRIES. Also execute some ST05 for missing required index (look for some table full scan or with only client key)
Regards,
Raymond
09-25-2015 7:41 AM
Hi Kushala,
if this timeout occurs in dialogue, then try it in batch mode, where the timeout value is much higher.
If the above code is in a loop (LOOP. WHILE, DO) then you can set a commit work after the SELECT FOR ALL ENTRIES to reset the timeout counter.
Or you can try to improve your code.
Regards,
Klaus
09-24-2015 12:47 PM
Hi Kushala,
Some suggestions sorted based on relevance.
1. Performance optimization. that means using index( may be create an index, if there is none), or using many fields in where clause if possible.
If you have done all these, but still face issue then parallel processing is your answer.
2. check the value for this parameter
rdisp/max_wprun_time = ? Is it really set as 1500 seconds
3. If nothing works and seems that actually you are selecting a lot of data without any optimization possible, then thing about background processing. It can go and go on for a very long time, without giving a time out error.
09-25-2015 9:09 AM
Hi Kushala,
It seems time out error is coming due to your select query since it is fetching lots of records.
you can analyse the root cause by using T-code 'ST05'.
there by using proper index you can reduce your CPU cost time.
Regards,
Bhupendra