I received an error during a restore process today, where multiple FKs could not be restored. The restore log messages look like this:
gbak:cannot commit index FK_ZIP_CODE_ACCT_TO_ACCOUNT gbak: ERROR:violation of FOREIGN KEY constraint "FK_ZIP_CODE_ACCT_TO_ACCOUNT" on table "ZIP_CODE_ACCOUNT" gbak: ERROR: Foreign key reference target does not exist gbak:cannot commit index FK_TRANSFER_TO_ACCOUNT gbak: ERROR:violation of FOREIGN KEY constraint "FK_TRANSFER_TO_ACCOUNT" on table "TRANSFER" gbak: ERROR: Foreign key reference target does not exist All told there were about 23 foreign keys which couldn’t be restored – almost the exact number of foreign keys pointing to the ACCOUNT table. It looks to me like somehow an ACCOUNT row was deleted, breaking the FK. I ran a number of queries that look like this: select t.account_id, a.account_id from zip_code_account t left join account a on (a.account_id = t.account_id) So that I could look for any record in ZIP_CODE_ACCOUNT that did not have a matching record in ACCOUNT. There were no records that matched this condition. I tried it on a number of other tables as well, and could not find one instance where a value in table T.ACCOUNT_ID did not have a matching value in A.ACCOUNT_ID. What would have caused this restore to fail? Thank you, Bob M..
