on 07-25-2005 4:24 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.