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.