Subject Re: [firebird-support] Firebird 1.5 Database will not restore - What do I do?
Author Milan Babuskov
SoftTech wrote:
> gbak: cannot commit index REFACCT_TRAN_TASK812
> gbak: ERROR: violation of FOREIGN KEY constraint "PK_ACCT_TRAN_DETAIL_TASK"
> gbak: ERROR: action cancelled by trigger (3) to preserve data integrity
> gbak: ERROR: Cannot deactivate primary index
> gbak: Exiting before completion due to errors

In your database you have some records that violate constraints. Most
likely it's a case of broken index, so that's why the problem is not
visible in the running database.

> Can this issue be fixed? Are they compounding the problems if they continue
> to enter and edit data in this database?

Use gfix (in Firebird's bin directory) to validate the database. If it
finds error, you can use this procedure to try to fix it:

Milan Babuskov