Cannot enable compression for object 'ACTUALACTION' error when upgrading the Endpoint Protection Manager.

Products

• Endpoint Protection

Issue/Introduction

When attempting to upgrade the Endpoint Protection Manager (SEPM) to 14.3 RU1 or later, you receive the following error during the database schema upgrade:

upgrade-0.log:
2021-07-06 15:37:19.059 THREAD 30 GRAVE: Message:  Cannot enable compression for object 'ACTUALACTION'. Only SQL Server Enterprise Edition supports compression.
2021-07-06 15:37:19.059 THREAD 30 GRAVE: Vendor:  7738
2021-07-06 15:37:19.059 THREAD 30 GRAVE: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot enable compression for object 'ACTUALACTION'. Only SQL Server Enterprise Edition supports compression.
2021-07-06 15:37:19.059 THREAD 30 GRAVE:  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
2021-07-06 15:37:19.059 THREAD 30 GRAVE:  at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1632)
2021-07-06 15:37:19.059 THREAD 30 GRAVE:  at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:872)

Environment

SQL Server 2016 Standard RTM release. 

Cause

This issue occurs when using SQL Server 2016 Standard RTM release.  Compression was not added until SP1 per MS documentation:

(Data Compression) applies to SQL Server 2016 (13.x) SP1 as part of creating a Common Programmability Surface Area (CPSA) across editions. 

https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-ver15

Resolution

Upgrade SQL Server 2016 to SP1 or later. 

Additional Information

ESCRT-6030