RE:Invalid trigger after upgrade from 7.4 to 7.6 (AK Catalog information not found)

[Thomas Anhaus]

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