We have a number of process chains that run during the day loading data from our SAP R/3 system into SAP BW. They usually take about thirty minutes to run. This week they've been taking over an hour.
We compared this weeks runs against last weeks runs using /SSA/BWT but the runtimes of the individual load and activation steps are roughly the same.
The one thing that we've noticed is that the chain appears to pause ("On Hold") while SAPLRSSM deletes data from TESTDATRNRPART0.
Haven't managed to find much information about this online, but it seems to be a temporary table that is used when data is moved from the PSA tables to an InfoObject.
Can anyone tell us more about this table, and give us any pointers why it could be taking longer than normal?