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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.