Subject Exception restoring data
Author Ed Dressel
I am getting an exception when I restore data (using IBExpert's
interface to do this):

IBE: Starting restore. Current time: 11:35:46 AM
IBE: Unsuccessful execution caused by system error that does not
preclude successful execution of subsequent statements.
action cancelled by trigger (3) to preserve data integrity.
Cannot deactivate primary index.
IBE: Restore completed. Current time: 11:35:52 AM. Elapsed time: 00:00:06


I turned on verbose logging and the log file just stops after logging
a number of indexes--no exception messages before that:

gbak: creating indexes
gbak: restoring index PK_NEWSINFO
gbak: restoring index NEWSINFO_IDX1
gbak: restoring index BACKUPLOG_PK
gbak: restoring index CUSTOMERQUOTEINFO_IDX1
gbak: restoring index CUSTOMERQUOTEINFO_IDX2
gbak: restoring index PK_TRAININGINFO
gbak: restoring index TRAININGINFO_IDX1
gbak: restoring index WEBACTINLOG_PK
gbak: restoring index UTLITYINFO_PK
gbak: restoring index RDB$PRIMARY11
gbak: restoring index COMPANYINFOIDX1
gbak: restoring index ACTIONINFO_PK
gbak: restoring index RDB$25
gbak: restoring index RDB$PRIMARY26
gbak: restoring index RDB$PRIMARY7
gbak: restoring index IDXCLIENTLOGDATASETANDID
gbak: restoring index RDB$PRIMARY9
gbak: restoring index IDXCOMPANYIDREFNO
gbak: restoring index RDB$FOREIGN22
gbak: restoring index RDB$FOREIGN14

Something that seems to be related to it...I have a problem deleting
old data in the database--it won't let me, gives me an exception:

internal gds software consistency check (partner index description not
found (175)).

The RDB$FOREIGN14 index is on the table that will not let me delete data.

What should i be looking at?

Thanks
Ed Dressel