Subject | DB Restore error - arithmetic exception |
---|---|
Author | tickerboo2002 |
Post date | 2008-09-26T13:12:01Z |
Hello
After 5 years of using Firebird without a glitch, A customer has set a
back-up of their database and I'm having trouble restoring it on my
system. We're both using FBv1.5.4
During the restore process it gives:
gbak: restoring index PK_TELEPHONE_NUMBERS_ALLOCA
ERROR: arithmetic exception, numeric overflow or string truncation
The PK_TELEPHONE_NUMBERS_ALLOCA is for a table called
TELEPHONE_NUMBERS_ALLOCATION.
If I try the restore process again, then it gets a little further:
gbak: restoring index PK_TELEPHONE_NUMBERS_ALLOCA
gbak: restoring index U_TELEPHONE_NUMBERS_ALLOCATION
gbak: restoring data for table TELEPHONE_SYSTEM_ALLOCATION
gbak: 49 records restored
ERROR: validation error for column FORM_ID, value "*** null ***"
attempted retrieval of more segments than exist.
Any idea what can cause these errors? Is it just a duff back-up and
not worth continuing with the fbk? Is this error in the live database
and needs fixing there?
Any ponters greatly appreciated.
After 5 years of using Firebird without a glitch, A customer has set a
back-up of their database and I'm having trouble restoring it on my
system. We're both using FBv1.5.4
During the restore process it gives:
gbak: restoring index PK_TELEPHONE_NUMBERS_ALLOCA
ERROR: arithmetic exception, numeric overflow or string truncation
The PK_TELEPHONE_NUMBERS_ALLOCA is for a table called
TELEPHONE_NUMBERS_ALLOCATION.
If I try the restore process again, then it gets a little further:
gbak: restoring index PK_TELEPHONE_NUMBERS_ALLOCA
gbak: restoring index U_TELEPHONE_NUMBERS_ALLOCATION
gbak: restoring data for table TELEPHONE_SYSTEM_ALLOCATION
gbak: 49 records restored
ERROR: validation error for column FORM_ID, value "*** null ***"
attempted retrieval of more segments than exist.
Any idea what can cause these errors? Is it just a duff back-up and
not worth continuing with the fbk? Is this error in the live database
and needs fixing there?
Any ponters greatly appreciated.