Subject | Re: [firebird-support] Backup Error |
---|---|
Author | Carlos H. Cantu |
Post date | 2004-06-29T11:34:54Z |
It seems that you have bad data in char/varchar fields somewhere in
your records.
Try to do a select fetching all rows from the problematic table. If
the error happens during the select, check what was the lastest
recorded retrieved. Probably the record with error is the next one.
Or try blocking the fetch (using first/skip) until you find what is
the problematic record(s).
Carlos
http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br
TGdO> Hi all !
TGdO> First, excuse my poor english.
TGdO> I tried to do a Backup in one FireBird DB and they return "arithmetic
TGdO> exception, numeric overflow, or string truncation" during the backup. Then
TGdO> it not end, and I can't make the backup....
TGdO> By the first time, the error message are displayed in one place, by the
TGdO> second in another place of backup..
TGdO> What can I do to locate where is the bug, and to make the full backup
TGdO> finally !??
TGdO> Thanks !
TGdO> Tiago GouvĂȘa
your records.
Try to do a select fetching all rows from the problematic table. If
the error happens during the select, check what was the lastest
recorded retrieved. Probably the record with error is the next one.
Or try blocking the fetch (using first/skip) until you find what is
the problematic record(s).
Carlos
http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br
TGdO> Hi all !
TGdO> First, excuse my poor english.
TGdO> I tried to do a Backup in one FireBird DB and they return "arithmetic
TGdO> exception, numeric overflow, or string truncation" during the backup. Then
TGdO> it not end, and I can't make the backup....
TGdO> By the first time, the error message are displayed in one place, by the
TGdO> second in another place of backup..
TGdO> What can I do to locate where is the bug, and to make the full backup
TGdO> finally !??
TGdO> Thanks !
TGdO> Tiago GouvĂȘa