Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

regarding maximum time exceeded error(background processing)

Former Member
0 Likes
447

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...

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
407

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

2 REPLIES 2
Read only

Former Member
0 Likes
408

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

Read only

Former Member
0 Likes
407

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