Subject | Re: [firebird-support] Erroring Restoring backup file created with v2.1 to version 2.5 |
---|---|
Author | Helen Borrie |
Post date | 2010-10-12T22:54:16Z |
At 10:09 AM 13/10/2010, you wrote:
./heLen
>When running the restore process on v2.5 I am receiving the following error: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"?
>
>"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?
./heLen