RevisionID: 17895 for revision set 1341 Loading xml catalog item: when running Service Pack 8

When running service revisions for SP 8, users may encounter the following error:

RevisionID: 17895 for revision set 1341 Loading xml catalog item: 17895.ConstituentUpdate.Batch.xml Opening package C:\Program Files\BBCRM_SP8P47\bbappfx\MSBuild\Revisions\Blackbaud.AppFx.Galileo.ServiceRevisions.Specs1341.zip The "RunServiceRevisions" task failed unexpectedly. Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionExecutionException: An error occurred while executing a service revision. Revision text: LoadSpec: 17895.ConstituentUpdate.Batch.xml Blackbaud.AppFx.Galileo.ServiceRevisions.Specs1341.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_AS_STRING":  System.Exception: Unexpected routine type in Common.GetRoutineType. Did not expect ''''
We are currently evaluating this issue and will update this article when we have more information.

Environment

 3.0.516, Service Pack 8

Was this article helpful?