Extension upgrade fails with FOREIGN KEY constraint "FK_MAEnforcementStatus_EPOProductProperties"

Technical Articles ID: KB93049
Last Modified: 2021-06-03 14:09:14 Etc/GMT

Environment

McAfee Agent (MA) 5.7.0 - 5.7.2, 5.6.2 - 5.6.6

Problem

You are unable to upgrade the MA Extension.

The file records the following errors:

pay Caused by: D:\Program Files (x86)\McAfee\ePolicy Orchestrator\Server\extensions\installed\EPOAGENTMETA\5.6.5.102\install.xml:414: java.sql.SQLException:
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_MAEnforcementStatus_EPOProductProperties".
The conflict occurred in database "ePO_INHYSZSVAV001", table "dbo.EPOProductPropertiesMT", column 'AutoID'.Caused by: D:\Program Files (x86)\McAfee\ePolicy
Orchestrator\Server\extensions\installed\EPOAGENTMETA\5.6.5.102\install.xml:414: java.sql.SQLException:
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_MAEnforcementStatus_EPOProductProperties".
The conflict occurred in database "ePO_INHYSZSVAV001", table "dbo.EPOProductPropertiesMT", column 'AutoID'. at com.mcafee.orion.core.ext.tasks.SqlTask.execute(SqlTask.java:78) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291) at sun.reflect.GeneratedMethodAccessor1349.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:392) at org.apache.tools.ant.Target.performTasks(Target.java:413) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1251) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442) ... 87 moreCaused by: java.sql.SQLException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_MAEnforcementStatus_EPOProductProperties".
EPO console.

Cause

The value of the Foreign key FK_MAEnforcementStatus_EPOProductProperties for the table MAEnforcementStatus must be null.

Any value present in the table generates an error in the orion.log file.

Solution

This issue is resolved in McAfee Agent 5.7.3. This version is available from either the ePO Software Manager or the Product Downloads site.

NOTE: You need a valid Grant Number to access the update.

To view other known and resolved issues, see KB93773 - Trellix Agent 5.7.x Known Issues.

Workaround

If you see the error above when you check in the McAfee Agent 5.7.x extension:

Check in the McAfee Agent 5.6.6.x extension.
Upgrade to the McAfee Agent 5.7.x extension.

If this solution or workaround does not resolve your issue, log on to the ServicePortal and create a Service Request. Include this article number in the Problem Description field.

Affected Products

Languages:

This article is available in the following languages:

Knowledge Center

Extension upgrade fails with FOREIGN KEY constraint "FK_MAEnforcementStatus_EPOProductProperties"

Environment

Problem

Cause

Solution

Workaround

Affected Products

Languages:

Title

Title

Knowledge Center

Extension upgrade fails with FOREIGN KEY constraint "FK_MAEnforcementStatus_EPOProductProperties"

Environment

Problem

Cause

Solution

Workaround

Affected Products

Languages:

Choose your region

Title

Title