RevisionID: 630 for revision set 1560 fails when upgrading from 4.0 SP5 to SP11

When upgrading from Blackbaud CRM V4 SP5 to SP11 RevisionID: 630 for revision set 1560 the following error may occur.

Loading xml catalog item: 630.Opportunity.Query.xml
The "RunServiceRevisions" task failed unexpectedly.
Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionExecutionException: An error occurred while executing a service revision. Procedure Return Code: 0
Revision text: LoadSpec: 630.Opportunity.Query.xml Blackbaud.AppFx.Galileo.ServiceRevisions.Specs1560.zip ---> Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.LoadSpecException: Procedure Return Code: 0 ---> System.Exception: The multi-part identifier "O.ID" could not be bound.
The multi-part identifier "o.ID" could not be bound. ---> System.Data.SqlClient.SqlException: A .NET Framework error occurred during execution of user-defined routine or aggregate "USP_LOADSPEC_AS_STRING":
System.Data.SqlClient.SqlException: The multi-part identifier "O.ID" could not be bound.
The multi-part identifier "o.ID" could not be bound.
System.Data.SqlClient.SqlException:
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Blackbaud.AppFx.Platform.SqlClr.QueryViewSpecProcessor.ExecuteSqlNonQuery(String sqlToExecute)
   at Blackbaud.AppFx.Platform.SqlClr.QueryViewSpecProcessor.ProcessSpec(String specXml, String specExtensionXml, Nullable`1 changeAgentID, SqlBoolean processPageAlterations)
   at Blackbaud.AppFx.Platform.SqlClr.QueryViewSpecClr.ProcessSpec(String specXml, Nullable`1 changeAgentID, SqlBoolean skipValidation, SqlBoolean processPageAlterations)
   at Blackbaud.AppFx.Platform.SqlClr.LoadSpec.LoadSpecInternal(String specTypeName, String specXmlText, SqlString itemName, Nullable`1 changeAgentId, SqlBoolean processPageAlterations, SqlBoolean skipValidation, SqlBoolean compareToExistingSpecXml)
   at Blackbaud.AppFx.Platform.SqlClr.LoadSpec.LoadSpecAsString(String specXmlText, Nullable`1 changeAgentID, SqlString sourceName, SqlString itemName, SqlBoolean loadAsDependency, SqlBoolean forceReload, SqlBoolean processPageAlterations, SqlBoolean skipValidation, SqlBoolean compareToExistingSpecXml)
.
LOADSPEC ERROR:The multi-part identifier "O.ID" could not be bound.
The multi-part identifier "o.ID" could not be bound.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.ExecuteLoadSpecAndTrapSpecialError(SqlCommand cmd)
   --- End of inner exception stack trace ---
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.ExecuteLoadSpecAndTrapSpecialError(SqlCommand cmd)
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.ExecuteLoadSpecProcedure(SqlConnection conn, String specXML, String assemblyName, String specResourceName, Boolean loadAsDependency, Boolean forceReload, Guid changeAgentID, Boolean skipValiation, String itemType, LoadSpecLogger logger, Boolean compareToExistingSpecXml)
   --- End of inner exception stack trace ---
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.ExecuteLoadSpecProcedure(SqlConnection conn, String specXML, String assemblyName, String specResourceName, Boolean loadAsDependency, Boolean forceReload, Guid changeAgentID, Boolean skipValiation, String itemType, LoadSpecLogger logger, Boolean compareToExistingSpecXml)
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.ExecuteLoadSpecProcedure(SqlConnection conn, String specXML, String assemblyName, String specResourceName, Boolean loadAsDependency, Boolean forceReload, Guid changeAgentID, Boolean skipValiation, String itemType, LoadSpecLogger logger, Int32 revisionId, Boolean compareToExistingSpecXml)
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.LoadSpecInternal(SqlConnection conn, DBRevision r, String assemblyName, String specResourceName, Boolean onlyLoadNonDesignerSpecs, Boolean loadAsDependency, Boolean forceReload, SpecResource specResource, Int32 revisionSetNumber, Int32 revisionID, Boolean compareToExistingSpecXml)
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.RunRevs(DBRevisions revs, Int32 startAtRevisionID, Boolean onlyLoadNonDesignerSpecs)
   --- End of inner exception stack trace ---
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.RunRevs(DBRevisions revs, Int32 startAtRevisionID, Boolean onlyLoadNonDesignerSpecs)
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.RunLatestRevisions()
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisions.Execute()
   at Microsoft.Build.BackEnd.TaskExecutionHost.Microsoft.Build.BackEnd.ITaskExecutionHost.Execute()
   at Microsoft.Build.BackEnd.TaskBuilder.<ExecuteInstantiatedTask>d__20.MoveNext()
Process failed.


 
We are currently evaluating this issue for a fix in a future service pack.

 

Environment

 Blackbaud CRM
 4.0
 4.0.170.41

Was this article helpful?