Subject GBAK Restore Crash
Author Marius Labuschagne
Hi,

I am trying to restore a backup database of one of my Clients.

The restore runs up until a point in both EasyIP Firebird Database Manager
and also when making using of GBAK command line directly.

EasyIp breaks with the following message:
SQL Code: -901
IB Error Code: 336330798
Error Message:
frmFirebirdDBMaintenance.srvRestore:
Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements.
String truncated

Using gbak directly from command line, I get the following when it breaks:
gbak:restoring data for table SYS_MONITOR
gbak: 10000 records restored
gbak: 20000 records restored
gbak: 30000 records restored
gbak: 40000 records restored
gbak: 50000 records restored
gbak: 60000 records restored
gbak: 70000 records restored
gbak: 80000 records restored
gbak: 90000 records restored
gbak: 100000 records restored
gbak: 110000 records restored
gbak: 120000 records restored
gbak: 130000 records restored
gbak: 132205 records restored
gbak:do not recognize table attribute 0 -- continuing
gbak:do not recognize index attribute 32 -- continuing
gbak:do not recognize index attribute 223 -- continuing
gbak: ERROR:string truncated
gbak:Exiting before completion due to errors

Database Workbench Reports:
gbak:restoring data for table SYS_MONITOR
gbak: 10000 records restored
gbak: 20000 records restored
gbak: 30000 records restored
gbak: 40000 records restored
gbak: 50000 records restored
gbak: 60000 records restored
gbak: 70000 records restored
gbak: 80000 records restored
gbak: 90000 records restored
gbak: 100000 records restored
gbak: 110000 records restored
gbak: 120000 records restored
gbak: 130000 records restored
gbak:committing data for table SYS_MONITOR
ERROR:
string truncated

Nothing is reported in the firebird log.

The machine where I am trying to restore is running Firebird 2.5 32-bit
Super Server. I have 4GB RAM installed and am running Windows XP Pro 32bit.

Can anyone advise what I should be trying, or why this is happening?

Is there any way that I could instruct GBAK to ignore the table it is having
issues with?



Regards
Marius J. Labuschagne