Archive

Posts Tagged ‘Attribute Change Run’

Lock Error After Cancelled Attribute Change Run

June 25th, 2009 RS No comments

For some reason, sometimes an attribute change run for a master data in process chain may get cancelled. Then, the next time of loading the master data a locked error would appear.

Fig.1 - Lock Error When Loading Master Data

Fig.1 - Lock Error When Loading Master Data

This error appears even though there is no any job running and no table locked when checking in tcode SM12.

The reason for this is because you have to close any cancelled change run before starting data load again for that master data. To do this, you can useĀ  transaction RSATTR. Just press the button “Monitor and Start Terminated Change Runs” at the bottom.

You may also display table RSDDAGGRMODSTATE to check for any change run job that are still open.

In case the change run always gets cancelled and your system have a BI Accelerator installed, it could be due to a corrupted BIA index. To fix this, recreate the BIA indexes of datamarts using the infoObject then try to use RSATTR again.

Categories: ETL Tags: ,