Unlock Infocube from terminated attribute changerun

There will be a scenario that Infocube get lock due to terminated changerun.

This terminated changerun will cause the following issues to the affected infocubes:

a)    Rollup cannot be done

b)    Index cannot be generated

c)    Data load cannot be done in the infocube.

In this scenario, we can follow two procedures:

1)    Restart the terminated changerun from the t-code Chnagerunmoni

Note: Unless and until the terminated changerun not gets corrected, new changerun over the affected infocube cannot be performed.

2)    In some scenario, terminated changerun could not be restarted due to some database issue or some other reason, then we can proceed with below procedure:

Goto Table RSDDAGGRMODSTATE.

In this table, CNSID is the changerun ID.

CLOSEDFL gives the status of the changerun. If this field contains value ‘X’, then the particular changerun is in completed status. If this filed contains BLANK value, then the particular changerun is in “active” status or “Terminated” status.

In the above screenshot it looks like CLOSEDFL with BLANK value. The terminated changerun details looks like as the above screenshot.

In order to unlock the infocube which is affected by this terminated changerun, we need to manually enter the value for CLOSEDFL as “X”.

By doing this, affected infocubes will be unlocked. So that we can proceed with data load, rollup, Index generation.

In order to get the list of infocubes which got locked by this terminated changerun can be obtained from the table RSDDCHNGPROT.

If required, we need to deactivate the aggregates and then need to activate and fill the aggregates again after attribute changerun.