--- In firebird-support@yahoogroups.com, "L" <lfeliz@...> wrote:

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

I assume you mean:

NEW.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.

Is it possible that the trigger as been de-activated by someone. Even
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
>
> 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+.

Too large sorry. Do you get the same issue if you do a 'meta-data
only' backup/restore? I believe there was an issue in 1.0.x where you
could disable a PK index (1.5+ prevents this). If the index is
disabled, then NULLs (and duplicates) will be legal. If the trigger is
also inactive you will get this issue.

>
> 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
>

Adam