Subject | Re: [ib-support] Arithmetic overflow or division by zero has occurred |
---|---|
Author | Johan Leroy |
Post date | 2003-04-15T04:49:58Z |
I also had this problem ones, after searching why i couldn't restore my db I
looked in the original database and there the problem was.
When you add a field to a table thas is a not null field,but you don't set a
value for every record in the table then you get these error.
I don't now if there are any other possibilitys but I hoop it helps.
regards
johan
"Pablo S�nchez" <pablos@...> schreef in bericht
news:b7fofp+3tr6@......
looked in the original database and there the problem was.
When you add a field to a table thas is a not null field,but you don't set a
value for every record in the table then you get these error.
I don't now if there are any other possibilitys but I hoop it helps.
regards
johan
"Pablo S�nchez" <pablos@...> schreef in bericht
news:b7fofp+3tr6@......
> Here is the tail of the output of gbaking my database.http://docs.yahoo.com/info/terms/=20
> I=B4ve been working on it for the last days, updating it=B4s
> structure. At some point the thing gets unstable, so i
> backed up, but when trying to restore i get the following :
>
> ... many lines here...
> gbak: restoring data for table SECCION=20
> gbak: 1 records restored=20
> gbak: restoring index RDB$PRIMARY90=20
> gbak: restoring index RDB$FOREIGN245=20
> gbak: restoring index RDB$FOREIGN246=20
> gbak: restoring index RDB$PRIMARY89=20
> gbak: restoring index RDB$PRIMARY88=20
> gbak: restoring data for table REGION=20
> gbak: 1 records restored=20
> gbak: restoring index RDB$PRIMARY87=20
> IBE: Arithmetic overflow or division by zero has occurred.
> arithmetic exception, numeric overflow, or string truncation.
>
> Is it a data problem ? sturcture problem ?
> The gbk is restored to a new gdb, data is recovered up to the
> last table (REGION). DDL of tables, procedures, exceptions seems=20
> to be ok. No triggers are restored.
> The original gdb contains 143 tables, 38 procedures, 34 generators,
> 1 exception, 8 triggers and of course, lots of constraints (PK,FK,etc)
>
> Any idea appreciated.
>
> Using Ibexpert with FB 1.02 (WI-V6.2.908) ODS 10.0=20=20
> server : localhost with local connection.
> O/S : WINXP SP1 (512MB RAM)
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
> =20
>
> Your use of Yahoo! Groups is subject to
>
>