Error: RunServiceRevisions task failed unexpectedly

Service revisions fail when attempting to upgrade from 6.10 to 6.51.

The "RunServiceRevisions" task failed unexpectedly.
Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionExecutionException: An error occurred while executing a service revision.
Revision text: LoadSpec: 1585.LedgerAccountProfile.View.xml Blackbaud.AppFx.Galileo.ServiceRevisions.Specs1069.zip ---> Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.LoadSpecException: Procedure Return Code: 0 ---> System.Exception: Keyword 'as' could not be found in the SQL statement. ---> System.Data.SqlClient.SqlException: A .NET Framework error occurred during execution of user-defined routine or aggregate "USP_LOADSPEC_AS_STRING":
System.Exception: Keyword 'as' could not be found in the SQL statement.
 
If you encounter this error, please reach out to support to obtain the installer for version 6.45.  Click Chat with Support and reference this article

Workaround: Upgrade to 6.45.2034, then upgrade to 6.51.736.

Environment

 6.51.736, patch 8 ; 6.1

Was this article helpful?