SAP BW Change run failed with error - No change run is possible

Change run failed with error:


Report RSDDS_AGGREGATES_MAINTAIN completed with errors or As master data is loaded for 0MAT_ST_LOC, no change run is possible


All Master Data should be release by the time that chain run starts, in this case the Master Data was locked and that’s why the chain run failed.


1. Make a search of Master Data 0MAT_ST_LOC and delete the lock.


2. Go to Hierarchy /Attribute Changes for reporting window and click on the  “Stop” button.  


3. Click on “SubseqProcessing” button and copy the parameters in notepad before to deleting them.   
4. Don’t click on trash button, just delete them manually and click the green arrow button to continue.


We are removing these events because we don’t want to start again “Transaction Data” which is the subsequent event.


5. Click on “Selection” button and copy the parameter in the Event field  to note pad then click in the “Immeditate” button and unchecked the option “Periodic job” and save it. 

6. Click on “Execute” button.
7. Monitor the job in SM37.


Once Hierarchy /Attribute Changes for reporting ran successfully you have to put the parameters back. 


Click “Selection” button  and chose “After Event” button and type in Event field the following: YCHGRUN_GT_CHG_RUN_CHAIN.
Make sure the “Periodic job” check box is checked  and Save it.


Click “Execute” button to schedule the “Periodic Job” and you will see a new scheduled job.