Invalid trigger after upgrade from 7.4 to 7.6 (AK Catalog information not fou 2007-01-16 - By Anhaus, Thomas
Back
Kolja Kleist wrote :
>Hello List,
>After upgrading my database from sapdb 7.4.3.32 to maxdb 7.6.0.34
>I got an error when deleting a row from a specific table:
>AK Catalog information not found
>I found a posting from this list which says that the delete trigger may
have
>a problem.
>But when I try to select the triggers from the db (SELECT DISTINCT
>schemaname FROM domain.triggers WHERE TRIGGERNAME LIKE '%')
>or if I try to drop the trigger I got the same error:
>System error: AK Catalog information not found:0000000000000000007200
>So what should I do now?
>Any help would be nice,
>Regards, Kolja
Unfortunately there's not much you can do. It seems that the migration
process from 7.4.03 to 7.6.0 produced a catalog inconsistency, which
cannot be repaired with the current facilities.
I recomment to suspend the affected table T, i.e.
RENAME T TO SUSPENDED
CREATE TABLE T LIKE SUSPENDED
INSERT INTO T SELECT * FROM SUSPENDED
DELETE SUSPENDED (if possible)
recreate all views, synonyms, triggers etc. based on T
Best Regards,
Thomas
|
|
