Loading...

Knowledge Center


The MERGE statement attempted to UPDATE or DELETE the same row (Endpoint Migration Assistant fails to migrate Host Intrusion Prevention to Endpoint Security Firewall)
Technical Articles ID:   KB89746
Last Modified:  8/29/2017

Environment

McAfee Endpoint Migration Assistant 10.5.x, 10.2.x
McAfee Endpoint Security (ENS) Firewall 10.5.x, 10.2.x
McAfee Host Intrusion Prevention (Host IPS) 8.0

Problem

Endpoint Migration Assistant fails to migrate the Host IPS catalog to ENS Firewall. The migration fails with the following error in the ePolicy Orchestrator Orion.log:
 
2017-05-24 11:24:52,126 WARN  [scheduler-TaskQueueEngine-thread-2] framework.AutoMigrationServerTask  - Migration END:
2017-05-24 11:24:52,142 DEBUG [scheduler-TaskQueueEngine-thread-2] audit.AuditLogWriterImpl  - audited: com.mcafee.orion.core.audit.AuditLog@3700def1[m_id=31540,m_tenantId=1,m_orionUserId=9,m_userName=<user-name>,m_priority=1,m_cmdName=Migrate to Endpoint Security,m_message=The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A MERGE statement cannot UPDATE/DELETE the same row of the target table multiple times. Refine the ON clause to ensure a target row matches at most one source row, or use the GROUP BY clause to group the source rows.,m_success=false,m_startTime=2017-05-24 11:24:51.727,m_endTime=2017-05-24 11:24:52.126,m_remoteAddress=<null>]
 
A SQL trace shows the following failing statement:
 
MERGE FW_ApplicationExecutableMT AS T
USING HIP8_ApplicationExecutable AS S
ON (T.ApplicationId = S.ApplicationId) AND (T.ExecutableId = S.ExecutableId)
WHEN NOT MATCHED BY TARGET
    THEN INSERT (ApplicationId, ExecutableId, TenantId) VALUES (S.ApplicationId, S.ExecutableId,'1')
WHEN MATCHED
    THEN UPDATE SET T.ApplicationId = S.ApplicationId, T.ExecutableId = S.ExecutableId, T.TenantId = '1';

Cause

Groups in the Host IPS catalog that contain multiple instances of the same rule, or applications that contain multiple instances of the same executable, cause the migration to fail.

Solution

This issue is resolved in Endpoint Security 10.5.2, which is available from the Product Downloads site at: http://mcafee.com/us/downloads/downloads.aspx.

NOTE: You need a valid Grant Number for access. KB56057 provides additional information about the Product Downloads site, and alternate locations for some products.

Updates are cumulative; Technical Support recommends that you install the latest one.

Solution

This issue is resolved in Endpoint Security 10.2.2, which is available from the Product Downloads site at: http://mcafee.com/us/downloads/downloads.aspx.

NOTE: You need a valid Grant Number for access. KB56057 provides additional information about the Product Downloads site, and alternate locations for some products.

Updates are cumulative; Technical Support recommends that you install the latest one.

Rate this document

Languages:

This article is available in the following languages:

English United States
Japanese

Beta Translate with

Select a desired language below to translate this page.

Glossary of Technical Terms


 Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.