Error: Cannot insert duplicate key row in object 'dbo.PDACCOUNTSTRUCTURE' with unique index 'UIX_PDACCOUNTSTRUCTURE_DESCRIPTION_PDACCOUNTSYSTEMID' during a configuration import

When exporting configuration data for account systems and accounts structure from one database to another, users may receive the error: "Cannot insert duplicate key row in object 'dbo.PDACCOUNTSTRUCTURE' with unique index 'UIX_PDACCOUNTSTRUCTURE_DESCRIPTION_PDACCOUNTSYSTEMID'"

This issue occurs when the System Generated Account System or Account Code is deleted or re-added from the database.  These should not be deleted.  If a desired account system requires a different structure, a new account system should be added to the database. 

This issue was caused by a data conversion problem.  If you are experiencing a similar issue, review  How to identify data conversion issues in Blackbaud CRM for more information. 

Environment

 2.91.1535.36

Was this article helpful?