From: Date: January 16 2007 8:12am
Subject: RE:Invalid trigger after upgrade from 7.4 to 7.6 (AK Catalog information not found)
List-Archive: http://lists.mysql.com/maxdb/28223
Message-Id: <79E4599AFFFEF441BAA8C74BF2F9CB6104AA6465@dewdfe26.wdf.sap.corp>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C7393D.9DE5C58C"

------_=_NextPart_001_01C7393D.9DE5C58C
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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. =20
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=20
DELETE SUSPENDED (if possible)
recreate all views, synonyms, triggers etc. based on T

Best Regards,
Thomas



------_=_NextPart_001_01C7393D.9DE5C58C--