Subject DB Restore error - arithmetic exception
Author tickerboo2002
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.