Subject Error when restoring
Author Gerhardus Geldenhuis
Hi
I get the following error when restoring a database

gbak: restoring index RDB$PRIMARY11
ERROR: arithmetic exception, numeric overflow, or string truncation

When backing up the database it works fine here is the messages around
RDB$PRIMARY11

gbak: writing index RDB$PRIMARY31
gbak: writing data for table USERS
gbak: 19 records written
gbak: writing index RDB$PRIMARY11
gbak: writing data for table TIMEPERDEPARTMENT
gbak: 163 records written
gbak: writing index RDB$30
gbak: writing index RDB$PRIMARY10
gbak: writing data for table CONVERTTORONUMBER

My database version is
WI-V6.2.794 Firebird 1.0
and OS Version is W2K 5.00.2195

My backup string is :
gbak -b -t -v -user sysdba -pas masterkey F:\LocalDB\BodyTrak4.gdb
F:\LocalDB\Backup\BodyTrak4.gbk

My restore string is:
gbak -c -p 4096 -k -v -o -user sysdba -pas masterkey
F:\LocalDB\Backup\BodyTrak4.gbk F:\LocalDB\BodyTrak4TEST.gdb

From the client side the database works fine and previous backups and
restores has not failed.

The database is still under development so there no activity except for
the database tool on the database when I did the backup. I have tried
numurous backups but none wants to restore.

I deleted all the data from the table which seemed to do the trick. What
will cause such an error, and would it be possible to get a more
descriptive error message as to what went wrong.

Groete
Gerhardus