Error: Loading xml catalog item: 1690.RevenueUpdate.Batch.xml. The RunServiceRevisions" task failed unexpectedly when running service revisions for a patch."

Loading xml catalog item: 1690.RevenueUpdate.Batch.xml
The "RunServiceRevisions" task failed unexpectedly.
Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionExecutionException: An error occurred while executing a service revision.
Revision text: LoadSpec: 1690.RevenueUpdate.Batch.xml Blackbaud.AppFx.Galileo.ServiceRevisions.Specs1121.zip ---> Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.LoadSpecException: Procedure Return Code: 0 ---> System.Exception: Unexpected routine type in Common.GetRoutineType. Did not expect '' ---> System.Data.SqlClient.SqlException: A .NET Framework error occurred during execution of user-defined routine or aggregate "USP_LOADSPEC":
System.Exception: Unexpected routine type in Common.GetRoutineType. Did not expect ''
System.Exception:
   at Blackbaud.AppFx.Platform.SqlClr.Common.GetRoutineType(SqlConnection conn, String sp)
   at Blackbaud.AppFx.Platform.SqlClr.Common.GetRoutineParamList(SqlConnection conn, String routineName, KnownRoutineType knownType)
   at Blackbaud.AppFx.Platform.SqlClr.Common.GetRoutineParamList(SqlConnection conn, String routineName)
   at Blackbaud.AppFx.Platform.SqlClr.BatchTypeSpecProcessor.GetParams(SqlConnection conn, String templateProc)
   at Blackbaud.AppFx.Platform.SqlClr.BatchTypeSpecProcessor.GetExtensionParamsForSP(SqlConnection conn, String spName)
   at Blackbaud.AppFx.Platform.SqlClr.BatchTypeSpecProcessor.GetExtensionsForBatch(SqlConnection conn, Guid batchTypeCatalogID)
   at Blackbaud.AppFx.Platform.SqlClr.BatchTypeSpecProcessor.ProcessSpec(BatchTypeSpec batchSpec, Nullable`1 changeAgentID)
   at Blackbaud.AppFx.Platform.SqlClr.BatchTypeSpecProcessor.ProcessSpec(String specXml, Nullable`1 changeAgentID)
   at Blackbaud.AppFx.Platform.SqlClr.BatchTypeSpecCLR.ProcessSpec(SqlXml specXml, Nullable`1 changeAgentID)
   at Blackbaud.AppFx.Platform.SqlClr.LoadSpec.LoadSpec(SqlXml specXml, Nullable`1 changeAgentID, SqlString sourceName, SqlString itemName, SqlBoolean loadAsDependency, SqlBoolean forceReload, SqlBoolean processPageAlterations, SqlBoolean skipValidation)
.
LOADSPEC ERROR:Unexpected routine type in Common.GetRoutineType. Did not expect ''
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   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)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   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)
   --- 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)
   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)
   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.BuildEngine.TaskEngine.ExecuteInstantiatedTask(EngineProxy engineProxy, ItemBucket bucket, TaskExecutionMode howToExecuteTask, ITask task, Boolean& taskResult)
Process failed.

This is caused by customizations.  To support attributes in batch we create batch extensions for each attribute.  Those extensions have corresponding form specs created.  If the stored procedures mentioned in the generated form specs don’t actually exist we will see the above error. 
 

Environment

 2.91.1535, patch 33

Was this article helpful?