Subject | Error when restoring |
---|---|
Author | Gerhardus Geldenhuis |
Post date | 2002-10-14T07:59:52Z |
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
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