Error: The RunServiceRevisions" task failed unexpectedly. Violation of PRIMARY KEY constraint ''PK_FINANCIALTRANSACTION''. Cannot insert duplicate key in object ''dbo.FINANCIALTRANSACTION''. when upgrading from 2.91 to 2.94"

When upgrading from version 2.91 to 2.94 and running service revisions, the revisions fail on the following task:
 

Loading xml catalog item: 2283.StockSale.Extension.Table.xml

Running revision ... RevisionID: 2284 (240 of 316) for revision set 1140

The "RunServiceRevisions" task failed unexpectedly.

---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint ''PK_FINANCIALTRANSACTION''. Cannot insert duplicate key in object ''dbo.FINANCIALTRANSACTION''. The duplicate key value is (d3024aed-47b2-490d-bc61-00be50e76458).

Article Number: 64641

Products:

  • Blackbaud_CRM
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. 

Workaround: For testing purposes, all stock revenue transactions were removed from the database.  However, this is not a viable workaround in a production environment.

Environment

 2.94

Was this article helpful?

Blackbaud Community

Connect and collaborate with fellow Blackbaud users.

Chat with Support

Chat with our experienced staff to receive help right away.

Connect

The Blackbaud team is online and ready to connect with you!