Subject IB_4_7 Blob issues. Reply required urgently. Customer opens again on monday.
Author Dayna
Hi there. On a version 2.5.x firebird database.

My customers started getting a message 'BLOB NOT FOUND'.

So I gfixed the table and then did a backup/overwrite restore on it.

Now I'm getting a dozen messages about unable to activate index because :

gbak:cannot commit index FK_DIAGNOSISITEM_1

gbak: ERROR:violation of FOREIGN KEY constraint "FK_DIAGNOSISITEM_1" on

gbak: ERROR: Foreign key reference target does not exist

yet I can open both the table where the FK is defined and in the target
table I can open and view the data.

How can I fix this without losing data if possible.


[Non-text portions of this message have been removed]