SAP BW Roll up Copa Aggregates

Problem
The issue previously was that roll up jobs were getting cancelled due to lock by attribute change run.

Investigation/Resolution

• Checking for Running or Terminated Change Run

1. Check running WP's in SM51/SM66

Thus when a change run starts a BTC WP starts several dialog WP's. When an attribute job is cancelled only the BTC job is cancelled the dialog WP's continue until complete or time out (7200 secs)

Within SM66 we identified a WP that was locking XYZ, we attempted to cancel this however it had almost reached time limit so cancelled automatically.


2. Function Module: RSDDS_AGGR_MOD_STATE_GET was run to ensure there were no activate attribute change runs.

a. The function module RSDDS_AGGR_MOD_STATE_GET displays the status of change run.
E_MOD_IN_PROGRESS should have no value,
E_CNSID should be 0.
If not you have to delete the flag to start another change run)

b. The function module RSDDS_AGGR_MOD_CLOSE deletes the flag for an "active" change run etc

To ensure that this was successive the change run monitor should be checked for the below message (as per update by Slava in IM2615265 ):

Please make sure that you have "No Change Run active" message when run RSDDS_CHANGERUN_MONITOR report.

• Roll Up Aggregates

After the above steps, the requests for XYZ& XYZ100 were successfully rolled up without any issue.