Error: The RunServiceRevisions" task failed unexpectedly when updating MOD from version 2.8 to 2.9"

When updating MOD from version 2.8 to 2.9, you may receive the following error:

Error: The "RunServiceRevisions" task failed unexpectedly. Blackbaud.AppFx.Platform. BuildTasks.RunServiceRevisionsHelpers. RevisionExecutionException: An error occurred while executing a service revision. Revision text: LoadSpec: 7120.OpportunityDesignation. Table.xml Blackbaud.AppFx.Galileo. ServiceRevisions.Specs1110.zip ---> Blackbaud.AppFx.Platform. BuildTasks.RunServiceRevisionsHelpers. LoadSpecException: Procedure Return Code: 0 ---> System.Exception: The ALTER TABLE statement conflicted with the CHECK constraint "CK_OPPORTUNITYDESIGNATION_ DESIGNATION_ISUNIQUE". The conflict occurred in database "7023S28_e7326604-884d- 4f55-8b31-a113211ca942", table "dbo.OPPORTUNITY DESIGNATION". ---> System.Data.SqlClient. SqlException: A .NET Framework error occurred during execution of user defined routine or aggregate 'USP_LOADSPEC':  System.Data.SqlClient. SqlException: The ALTER TABLE statement conflicted with the CHECK constraint "CK_OPPORTUNITYDESIGNATION _DESIGNATION_ISUNIQUE". The conflict occurred in database "7023S28_e7326604 -884d-4f55-8b31- a113211ca942", table "dbo.OPPORTUNITYDESIGNATION".
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 2.9.1001
 2.9.1001.5

Was this article helpful?