When I iterate a through the PERSONS table (with IBExpert) I get at
the certain moment the following error:

Arithmic overflow of division by zero has occured
arithmic exception, numeric overflow or string truncation

Cannot transliterate character between character sets.

Does this means that there is a strange character in a certain
record? How can I find this record and fix or delete it?

Thanks,
Tom.

--- In firebird-support@yahoogroups.com, "zifnabbe" <zifnabbe@u...>
wrote:

> Mmm,
>
> When I restore with -inactive. then I can activate all indexes

except

> on foreign:
>
> Cannot commit transaction:
> violation of FOREIGN KEY constraint "".
> violation of FOREIGN KEY constraint "PK_PERSONS" on table "PERSONS".
>
> How do I've to interprete this?
>
> Where can the problem be? at the persons table or the other one?
>
> Tom.
>
> --- In firebird-support@yahoogroups.com, "zifnabbe" <zifnabbe@u...>
> wrote:
> > Thanks all,
> >
> > When I follow the guidelines and try to restore the database,

gbak

> > ends with the following error:
> >
> > gbak: cannot commit index RDB$FOREIGN20
> > gbak: ERROR: violation of FOREIGN KEY constraint "PK_PERSONS" on
> > table "PERSONS"
> >
> > gbak: ERROR: action cancelled by trigger (3) to preserve data
> > integrity
> > gbak: ERROR: Cannot deactivate primary index
> > gbak: Exiting before completion due to errors
> >
> > What can this be causing?
> >
> > Thanks,
> > Tom.
> > --- In firebird-support@yahoogroups.com, Helen Borrie
> <helebor@t...>
> > wrote:
> > > At 12:56 PM 30/04/2004 +0000, you wrote:
> > > > >
> > > > > You should be able to fix these with gfix. There may be

some

> > lost
> > > >data, however.
> > > >
> > > >how can I fix this with gfix? ie which command do I use for

this?

> > >
> > > http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_db_corr
> > >
> > > /heLen