Error: The "RunServiceRevisions" task failed unexpectedly - when installing or updating to NetCommunity version 6.64

When installing NetCommunity version 6.64 on your web server, the install goes through all the steps but fails on the service revision line. Reviewing the install log we see the error:

The "RunServiceRevisions" task failed unexpectedly.
Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionExecutionException: An error occurred while executing a service revision.
Procedure Return Code: 0 Revision text: LoadSpec: 1035.USP_REVENUEBATCH_CONSTITUENTCOMMITMENT.xml Blackbaud.AppFx.Galileo.ServiceRevisions.Specs1490.zip ---> Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.LoadSpecException: Procedure Return Code: 0 --->
System.Exception: "FORCESCAN" is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90.
This is resolved in a newer version of the product.

Steps to Duplicate

  1. Download NetCommunity Version 6.64
  2. Open and run installer file on server
  3. Observe error while running installer on server

Environment

 Windows Server 2008 (32-bit);Windows Server 2008 (64-bit);Windows Server 2008 R2
 SQL Server 2008;SQL Server 2008 R2
 Blackbaud NetCommunity
 6.64

Was this article helpful?