Incorrect syntax near 'MERGE' (Migration Extension installation failure)

Technical Articles ID: KB86470
Last Modified: 7/26/2021

Environment

McAfee Endpoint Security (ENS) 10.x
Microsoft Windows Server

Problem

The Endpoint Security Migration Extension fails to install and the following error message displays:

Error : Unable to install extension. java.sql.SQLException: Incorrect syntax near 'MERGE'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.

Solution

Change the Compatibility Level of the current database. Then, install the Endpoint Security Migration Extension in ePolicy Orchestrator (ePO):

Go to the SQL Server where the ePO database is hosted.
Open Microsoft SQL Server Management Studio.
Expand Databases.
Right-click the ePO database, where the default name is ePO_<ePO_server_name>, and select Properties.
Select Options. The Compatibility Level is on the right.
Set the Compatibility Level to SQL Server 2008 (100).
Click OK.
Close Microsoft SQL Server Management Studio.

Related Information

For information about setting the Compatibility Level using the ALTER DATABASE command, see this Microsoft article on ALTER DATABASE.

Affected Products

Endpoint Security Firewall 10.7.x
Endpoint Security Firewall 10.6.x
Endpoint Security Threat Prevention 10.7.x
Endpoint Security Threat Prevention 10.6.x
Endpoint Security Web Control 10.7.x
Endpoint Security Web Control 10.6.x
Install/Uninstall
Upgrade/Migrate

Languages:

This article is available in the following languages:

English United States
Spanish Spain
French
Italian
Japanese
Portuguese Brasileiro
Chinese Simplified

Knowledge Center

Incorrect syntax near 'MERGE' (Migration Extension installation failure)

Environment

Problem

Solution

Related Information

Affected Products

Languages:

Title

Title

Knowledge Center

Incorrect syntax near 'MERGE' (Migration Extension installation failure)

Environment

Problem

Solution

Related Information

Affected Products

Languages:

Choose your region

Title

Title