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).

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?