RevisionID: 4510 for revision set 1490 fails when upgrading a 3.0 SP12 database to 4.0 SP3

When attempting to upgrade a 3.0 SP12 database to 4.0 SP3, a revision error is received:
An error occurred while executing a service revision. Procedure Return Code: 0
Revision text: LoadSpec: 4510.USP_BBNC_GETNETCOMMUNITYCLIENTUSERIDS.xml Blackbaud.AppFx.Galileo.ServiceRevisions.Specs1490.zip ---> Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.LoadSpecException: Procedure Return Code: 0 ---> System.Exception: The procedure 'USP_BBNC_GETNETCOMMUNITYCLIENTUSERIDS' already exists with a different ID. ---> System.Data.SqlClient.SqlException: A .NET Framework error occurred during execution of user-defined routine or aggregate "USP_LOADSPEC_AS_STRING": 
System.Exception: The procedure 'USP_BBNC_GETNETCOMMUNITYCLIENTUSERIDS' already exists with a different ID.
 

We’re currently evaluating this issue for a fix in a future patch or service pack. 
 

Workaround:

delete the existing stored procedure with the ID 'A35EF9CA-F358-4DC0-965D-AD032CF37CF7', and then restart revisions. This allows the stored procedure to get added with the new ID:
 
delete from SQLPROCEDURECATALOG
where ID = 'A35EF9CA-F358-4DC0-965D-AD032CF37CF7'
 

Environment

 Blackbaud CRM
 4.0
 4.0.141.12

Was this article helpful?