topic Re: regarding maximum time exceeded error(background processing) in Application Development and Automation Discussions

regarding maximum time exceeded error(background processing)

Former Member — Mon, 30 Jul 2007 09:08:51 GMT

hi experts,

i m executing one simple ALV report in the background,,,but after some time it is giving a message that "maximum time exceeded" plz help me to shortout this problem...

Re: regarding maximum time exceeded error(background processing)

Former Member — Mon, 30 Jul 2007 09:21:48 GMT

First debug and see by keeping break points at different select statements in the code and see which select is taking maximum time

and we have to optimize that select. statement

Do SQL trace and Run time analysis (ST05 and SE30) and find out which statement is taking lot of time and see.

accordingly we have to correct the code

<b>Reward points for useful Answers</b>

Regards

Anji

Re: regarding maximum time exceeded error(background processing)

Former Member — Mon, 30 Jul 2007 09:33:13 GMT

Hi Dear,

Your Program is dying somewhere in select query. Keep break-points on select and

check where it is going dead. And one more thing before select always check weather

itab is initial or not. Try to find by debugging and solve it by giving maximum primary keys. If still it takes time, try to filter unwanted data.

If you have used joins try to avoid it..Many more i can unless i see your code..

Reward points if it supports you.

Regards,

Bohra