Help!

Loading data into a table. Table has a Before Insert trigger that sets
RECID = Gen_Id(Gen,1);

When loading 45000 records, 23,000+ have duplicate values in columns
that should be unique per generator assignment. The field value is
null on insert.

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

My next step is to re-build database using SQL script and then try
again. If anyone is interesting in helping, I an provide Databases,
but they are large 1.2 GB+.

I have tried just have 1.5.3 server open original FDB file. Also
restored badkup to much faster server (win 32 dual xeon) running
1.5.3 Classic. and same problem occurs.

Tried on a dev workstation that was upgraded from 1.0.3 to 1.5.3 and
process works fine and triggers / gen_id function correctly .

Cannot reliably reproduce problem, but thought I would report here.

- Lou