ALV Report taking more than 3 hours in background....

[Former Member]

Hi Experts,

I have created report Open Order as per our requirement, but when i am executing in background it takes more than 3 hours and if i runs in frontend it dumps.

Any body to help me, i will send my program.

Yusuf

[former_member588853]

HI,

How much time is it taking in foregroud..

If its working fine in foreground, the same time works in background too..

Please check the code and run in foreground first and then sasign as background job?Run immediately in back ground.

regards,

nazeer

[Former Member]

Hi Nazeer,

If I execute in foreground, then it dumps.

Yusuf

[Former Member]

probably because of a timeout, you get the dump in foreground.

Verify the different steps in the program, especially the select statements, and see if you can make them more performant. In case you need help, post these selects here...

[Former Member]

Have you run either a run-time analysis or performance trace to pinpoint the problem?

Rob

[Former Member]

Hi Rob,

No, I havent run analysis.

Through which transaction I can run and how ?

Pl. explain.

Yusuf

[Former Member]

The runtime analysis is under SE38 and the performance trace is ST05.

Rob

[Former Member]

Solved, it is becaz of lesting loop.