Skip to Content
author's profile photo Former Member
Former Member

Aborted changerun blocks objects

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2005 at 03:32 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2005 at 03:28 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.