Package Run: Time to load WHAT

[Former Member]

Hi all,

we are facing a Performance Problem with one of our applications. Since last week the run time of a package was fine and took about 12min.

Today it didn't came to an end after 5 hours.

Nothing changed at the application structure or the script.

I was able to start just the first part of the script and compare the read/load/calcualtion times. There was a hugh difference at time to load 1.15 vs 212.48 for just 1509 records. So that seems to be the problem. Does anybody know what can cause such a Problem from one Moment to another?

--Read WHAT region [S_H_KD] =BM_S_H_All,H,NA,S [PART_PC_KD] =10011,10013,10051,10072,10073,10074 --Time to load WHAT :1.15071 second(s). WHAT data:1509  records.

--Read WHAT region [S_H_KD] =BM_S_H_All,H,NA,S [PART_PC_KD] =10011,10013,10051,10072,10073,10074 --Time to load WHAT :212.477534 second(s). WHAT data:1509  records.

Regards
Derk

[Alex_S_sap1 · Accepted solution]

Hi Derk,

Some other things to review would be to ensure that a Lite Optimize was performed on the environment where this behavior occurs and then verify what results are seen with the script logic.

Also verify if the behavior occurs within UJKT when running the script logic there.

Regards,
Alex

[Former Member]

Hi Derk,

Is it on HANA or regular DB? If it's regular DB try rebuilding indices on that cube.

If this doesn't help enable statistics in SPRO and check in UJSTAT where it's taking so much time.

Regards,

Gersh

[damovand]

Hi,

The best way to find out where the time is spent is trace ST12.  Please enable it and that will shows all the ABAP method calls, the number and duration as well as SQL calls.

Best Regards,

Leila