Showing posts with label RSRREPDIR generation queries D010TAB. Show all posts
Showing posts with label RSRREPDIR generation queries D010TAB. Show all posts

Friday, December 9, 2011

Generating Queries issue BW

Due to an issue in one of the latest support packs (in our case SP08), many queries were being generated on each call of an enduser.

This causes major performance issues in reporting in our system. Mainly in generating the variable screen and the (non) usage of cache for these queries.

Wonder if this is happening in your system? Check on table RSRREPDIR and check if the timestamp in field GENTIME is not too recent for your active queries.

Also in the system you will see if you trace the call of the report that tables D010TAB and D010INC are accessed many times.

Implementing note 1528921 helped out on this (Queries regenerated each time during
execution). Please be aware!