When upgrading to a more recent version of NetCommunity, the process fails when attempting to run revisions with the following error:
The "RunServiceRevisions" task failed unexpectedly. Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionExecutionException: An error occurred while executing a service revision. Revision text: LoadSpec: 23200.AcknowledgementProcessEmailOutputExtended.DataList.xml Blackbaud.AppFx.Galileo.ServiceRevisions.Specs1000.zip ---> Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.LoadSpecException: Procedure Return Code: 0 ---> System.Data.SqlClient.SqlException: .NET Framework execution was aborted. Another query caused the AppDomain BBNC.dbo[runtime].22 to be unloaded. There is insufficient system memory in resource pool 'default' to run this query. Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.
This error is an indication that the server doesn't have enough memory for the revisions to run without interruption. To resolve, restart SQL and manually re-run revisions again. If the revisions go farther after restarting SQL, this verifies that it is a memory issue. If revisions fail again, continue restarting SQL and re-running revisions until they complete.