cancel
Showing results for 
Search instead for 
Did you mean: 

Aborted changerun blocks objects

Former Member
0 Kudos

Hi all,

The changerun job on our Development system was started last evening and aborted. Now when I try to delete the contents of a InfoCube with aggregates, I receive this error:

"Aborted changerun blocks InfoCube ZSD_C03".

I have tried to deactivate the aggregates, hoping the changerun would then "release" it, but this does not work.

I also don't see any tables/objects blocked in SM12 and no process is active in SM50.

Does anyone know how to resolve this??

Kind regards,

Hans de Klein

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

If you go to table RSDDAGGRMODSTATE, there should be an entry with CLOSEDFL as blank. Change this to X and it should unlock the aggregates and cube.

Corresponding to the CNSID that does not have the CLOSEDFL as X, the objects blocked by it will be in table RSDDCHNGPROT

Cheers

Aneesh

Former Member
0 Kudos

Thanks Aneesh,

On DB-level there were no processes active. Indeed the X in table RSDDAGGRMODSTATE was missing. After changing the record, it was unlocked.

10 points heading your way

Kind regards,

Hans

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Check with BASIS or DBA's if any job is still active on the ORACLE level. There are instances when on SM66 or SM37 we don't see any but there are jobs still active on the DB level.

if there are any ask them to kill the jobs.

Regards,

GPK.