Hi Benny,
Look here
http://ib-aid.com/en/articles/cannot-commit-index-or-how-to-pump-data-from-partially-restored-inconsistent-database/
I suggest to insert fake record with "ORDERID" = 4127, and then try to
activate index.
Regards,
Alexey Kovyazin
IBSurgeon
Hi,
I have been an interbase guy about fifteen years ago and loved to see
it go open source. I used to work with Paul Beach (Hello, if you're
here,Paul)
Now I ran across a problem with firebird and tried to solve it.
unfortunately half of the stuff is in the dark because the original
software running here is an accounting product (BUHL/Deltra office
Software/Germany if you have heard about it).
The weird thing is that the software does not connect to the server
from a client if there is a specific .fdb file loaded (local access
works). I now asked them to run a backup and that had a couple of
messages:
(gbak:cannot commit index MOV_CALITEMS_ORDERID
gbak: ERROR:violation of FOREIGN KEY constraint "MOV_CALITEMS_ORDERID"
on table "MOV_CALENDARITEMS"
gbak: ERROR: Foreign key reference target does not exist
gbak: ERROR: Problematic key value is ("ORDERID" = 4127)
gbak:Database is not online due to failure to activate one or more
indices.
gbak:Run gfix -online to bring database online without active indices.)
