GR55 Report Takes long time.

[Former Member]

Hi experts,

System Details: ECC 6.0; Windows 2008 R2; MS SQL 2005 Database.

Archiving is done and now when our functional team is running the GR55 to access data, it is taking a hell lot of time to bring-out the data. They have approached the Basis team (me included) for help.

Probable Solutions I think, but not confirmed,

1. The report may be doing some sequential read.

2. The table which it is trying to access has some indexing issues.

3. May be, the PBS server issue.

Any comments, suggestions or rectifications are welcome. Please help.

[Former Member]

Hi,

A recent update on my issue, when we run the report by GR55, we have found that the report is reading each and every data from the system, instead of reading the Info-structure. Thus, it is taking a lot of time.

Please guys provide a solution.

[Former Member]

Another update, as per the rdisp/max_wprun_time is set to 3600 secs in our PRD, so when the GR55 will take more than 1 hour it will throw an error, as it is accessing all the archived data and surely it will take a lot of time. Furthermore, it's not advisable to increase the runtime.

Anyways, it is also not possible to run it in background, as the team tried. So guys please please please help me out!