>
> select rdb$relation_name from rdb$indices where
> rdb$index_name='RDB$PRIMARY19'

Found the name of the table.....

>
> This index is broken most probably due to power failure etc on

your

> customer's machine. As a result, table contains duplicate(s). Find
> them
>
> Select ID, Count(*)
> From This_Table
> Group By ID
> Having Count(*) >1

This gives me NONE.

The specified table only contains some 100 records, so its easy
covered even manually.
The PK is 1 fields which is VARCHAR(30).

There are only unique values in the fields.

>
> (supposing you have one-segment PK on this table and column name is
> ID) in database restored with inactive indices. Try
>
> Select *
> Group By ID
> where ID Is Null

This gives me NO records.

>
> too (can exists in case if fragments of garbage records got status

of

> normal record because of corruption). After you find problem

records,

I have made my backup WITHOUT garbage collection.
Does that matter ?


Whatever duplicates should be deleted.
And because it only contains some 100 records, its easy to find and
correct, if I could find the error ;-)


Thank you so far anyway.......


Michael