Subject Backup of database fails - Invalid BLOB ID
Author Bhavbhuti Nathwani
Hi all

I am backing up a 2.0 database for restore so as to update the system tables to 2.1 (I haven't updated to the cutting edge version but use 2.1.0.17798_0)

I use FlameRobin 0.9.2.1845's backup facility and the below is the last part of the log. This is a client's database that has this problem. My dev. database did not have this problem and converted well.

I dropped the table BEA3 (as the error came just when writing to it) just to see if that is the one having the actual problem, the next backup run failed at table TEA3 (BEA3's parent and heavily used table by the client, see log still below)

Please advise.

LOG EXCERPT 1
...
...
gbak: writing data for table BEA3
Database backup canceled 11:51:38 due to IBPP exception:

*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed

SQL Message : -901
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements

Engine Code : 335544329
Engine Message :
invalid BLOB ID
gds_$receive failed


LOG EXCERPT 2
...
...
gbak: writing data for table TEA3
Database backup canceled 11:56:41 due to IBPP exception:

*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed

SQL Message : -901
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements

Engine Code : 335544329
Engine Message :
invalid BLOB ID
gds_$receive failed