Can any one let me know why the Request from an Infocube taking long time to be deleted ( Request has only 13 records in it ) and the request has been posted by DTP which has errors.
any other way the request can be delted apart from direct deletion from the Cube and Process Chain ?
Please let me know if there are any transaction code from where i can delete this error request. its already took 25 min and still active
Check the request entry in RSICCONT, RSREQICODS, RSTSODS, RSSELDONE, RSBKREQUEST, RSMONFACT, RSMONICDP tables . If found, delete the entries from the tables, then automatically it will be deleted from the cube.
I would not recommend deleting the entries directly from the tables - if you miss some entries or delete the wrong entries - the entire data load history for the affected infoprovider could be jeopardized...
When you say takes a lot of time - how long ..?
Each request is a partition in the fact table and a delete request should be dropping a partition which ideally takes the same time as deleting a request from PSA.
Possible reasons for it to be running slow :
1. Partition/request index might have got corrupted - check the F Fact table and its indices in RSRV ( Test - Infocube and its indices )
2. Do you have aggregates on the cube which were rolled up ..? deletion of data from Cube also deleted the data from aggregates which takes time.
3. Ask BASIS to monitor database activity when you are running the job - this might clear some questions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.