‎2007 Jul 30 10:08 AM
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...
‎2007 Jul 30 10:21 AM
Hi
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
‎2007 Jul 30 10:21 AM
Hi
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
‎2007 Jul 30 10:33 AM
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