Hello,

I forgot to mention I am using the IBPump utility from Clever
components. This morning I am writing my own import utility using
Delphi to make sure it is not IBPump.

I am also going to create the database from scratch on FB 1.53 and try
the data load process using IBPump and see where it goes. I have used
IBPump with other DB's crated with 1.53 to load several million
records without inciden. This problem seems to be centered only around
migrated 1.0 db's

Read on

> > RECID = Gen_Id(Gen,1);
> I assume you mean:
> NEW.RECID = Gen_ID(Gen, 1);

Yes, triggers are using NEW.RECID = Gen_ID(Gen, 1); to assign the value.

> Is it possible that the trigger as been de-activated by someone. Even

No. I have exclusive access to database. Table I am updating has no
PK Index as it is just a holding place to temporarily hold the data
before it is processed and added to much larger table. I did add a PK
as well as try a unique index and inserts fail.

I even removed the triggers, disconnected from DB and re-created them
and still get the sporadic behaviour.

Essientially the problem look like this when I have no PK or unique index

GRP EMPLOYER TYPE RECID
.....
1 123 10 1678900
1 123 12 1678901
1 123 14 1678902
1 123 10 1678903
1 123 12 1678903
1 123 14 1678903
1 123 12 1678904
1 123 14 1678904

etc....

The value for RECID is not mapped durring data import and it has not
default value in definition of collumn. It is almost a if the GEN_ID
function was not working properly all the time.

> so, the NULL should be rejected by the PK index.
>
> >
> > Background:
> >
> > PRocess ran fine on FB Win32 SS 1.0.3.972
> >
> > Upgr to Win32 SS 1.5.3.4870
> > a) BAckup 1.0.3 database, using 1.0.3 GBAK as well as a copy using
> > winzip with service stopped.
> > b) un-install FB 1.03
> > c) Install FB 1.5.3
> > d) Restore database backup
> >
> > Run process to load records, inspect data and records do not have
> > unique record id. Come similar records have
> >