Subject Re: [firebird-support] Erroring Restoring backup file created with v2.1 to version 2.5
Author Helen Borrie
At 10:09 AM 13/10/2010, you wrote:
>When running the restore process on v2.5 I am receiving the following error:
>"attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_39"
>I have reviewed the RDB$INDICES table on the source database and this index refers to the RDB$ROLES table and specifically is the unique index on RDB$ROLE_NAME. Their is only one record in RDB$ROLES and it is the RDB$ADMIN role.
>Any ideas on how to address this issue?

Are you by any chance attempting to restore a database of ODS <11.2 that already had a user-defined role with the name RDB$ADMIN or "RDB$ADMIN"?