Hi,

after my colleague played around with some stored procedures and changed
their output-parameters while these SP's are already in use by some
triggers, he realized that he corrupted the database a bit, as he could
not drop the SP'S and the triggers anymore due to the old known problems
with the BLR's.
So he changed the output parameters back to what they were and backed up
the database. Another reason why this guy will be soon fired is, that he
restored the database without making a hardcopy of the database file
itself, which of course resulted into an gbak error.

I am now in the problems that the restore-run won't work due to an
arithmetic exception and I have no clue how to get it right.
I tried Ann Harrisons wise tips with the -v switch and other things I
found in the archives on tamaracka, but It simply won't work.
I tried a metadata-extract only, and this worked without problems, but
the restore with data fails.
I think to remember to have read of an option in gbak, where it won't
stop on errors and would recreate the rest of the db, but couldn't find
anything in the search-engine.

Thanx for any help,

Nick


Here are the last few lines of the gbak-output, perhaps it helps:
Note, that all tables are restored, but several of them miss all data

gbak: restoring table ARBEITSBERICHT
gbak: restoring column UEBERSTUNDEN
gbak: restoring column STUNDEN_SOLL
gbak: restoring column STUNDEN_UEBERTRAG
gbak: restoring column JAHR
gbak: restoring column MONAT
gbak: restoring column MITARBEITER
gbak: restoring column ID
gbak: restoring column ABGERECHNET
gbak: restoring generator GEN_PARENTS value: 59
gbak: restoring generator GEN_PERSONS value: 1253
gbak: restoring stored procedure GET_M_SUM_STUNDEN
gbak: restoring parameter MITARBEITER for stored procedure
gbak: restoring parameter SUM_STUNDEN for stored procedure
gbak: restoring stored procedure SET_ARBEITSBERICHT
gbak: restoring parameter ARBEITSBERICHT for stored procedure
gbak: restoring parameter FROMDATE for stored procedure
gbak: restoring parameter TODATE for stored procedure
gbak: restoring stored procedure GET_ARBEITSBERICHT_STUNDEN
gbak: restoring parameter ARBEITSBERICHT for stored procedure
gbak: restoring parameter STUNDEN for stored procedure
gbak: restoring stored procedure GET_LATEST_UEBERTRAG
gbak: restoring parameter ARBEITSBERICHT for stored procedure
ERROR: arithmetic exception, numeric overflow, or string truncation