ALTER TABLE statement conflicted with the FOREIGN KEY constraint (ePO upgrade fails)
Last Modified: 7/26/2023
Affected Products
Languages:
This article is available in the following languages:
Trellix CEO, Bryan Palma, explains the critical need for security that’s always learning.
As per Gartner, "XDR is an emerging technology that can offer improved threat prevention, detection and response."
Trellix announced the establishment of the Trellix Advanced Research Center to advance global threat intelligence.
Trellix Advanced Research Center analyzes threat data on ransomware, nation-states, sectors, vectors, LotL, MITRE ATT&CK techniques, and emails.
As of May 14, 2024, Knowledge Base (KB) articles will only be published and updated in our new Trellix Thrive Knowledge space.
Log in to the Thrive Portal using your OKTA credentials and start searching the new space. Legacy KB IDs are indexed and you will be able to find them easily just by typing the legacy KB ID.
ALTER TABLE statement conflicted with the FOREIGN KEY constraint (ePO upgrade fails)
Technical Articles ID:
KB91255
Last Modified: 7/26/2023 Environment
ePolicy Orchestrator (ePO) 5.10.x, 5.9.x
Problem
The ePO upgrade fails and rolls back. The "C:\Users\<username>\AppData\Local\Temp\McAfeeLogs\EPO590-Troubleshoot\OutputFiles\epoST.bat" Return code: 1 1: 08:32:01 EPO590CALog: Service MCAFEETOMCATSRV590 is running 1: 08:32:01 EPO590CALog: Setting gAbortInstall=1 1: 08:32:01 EPO590CALog: End executeExternalCommand() 1: 08:32:01 EPO590CALog: epoST.err: Error encountered while running command:ext.install extension=file:///C:/PROGRA~2/McAfee/EPOLIC~1/INSTAL~1/ePO/EXTENS~2/epoST.zip 1: 08:32:01 EPO590CALog: epoST.err: 1: 08:32:01 EPO590CALog: epoST.err: java.io.IOException: Error 0 : 1: 08:32:01 EPO590CALog: epoST.err: The following error occurred while executing this line: 1: 08:32:01 EPO590CALog: epoST.err: C:\Program Files (x86)\McAfee\ePolicy Orchestrator\Server\extensions\installed\EPOCore\5.9.1.251\install.xml:800: The following error occurred while executing this line: 1: 08:32:01 EPO590CALog: epoST.err: C:\Program Files (x86)\McAfee\ePolicy Orchestrator\Server\extensions\installed\EPOCore\5.9.1.251\install.xml:188: java.sql.SQLException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_EPOPolicyObjectSettings_EPOPolicySettings". The conflict occurred in database "<epo Database Name>", table "dbo.EPOPolicySettingsMT", column 'PolicySettingsID'. 1: 08:32:01 EPO590CALog: End runRemoteClentCommand(epoST,...) returnCode=1 InstallShield 8:32:01: CallScriptFunctionFromMsiCA() ends CustomAction Prod_InstallEpoCore returned actual error code 1603 (note this error might not be 100% accurate if translation happened inside sandbox) Action ended 8:32:01: InstallFinalize. Return value 3. The java.io.IOException: Error 0 : The following error occurred while executing this line: C:\Program Files (x86)\McAfee\ePolicy Orchestrator\Server\extensions\installed\EPOCore\5.9.1.251\install.xml:800: The following error occurred while executing this line: C:\Program Files (x86)\McAfee\ePolicy Orchestrator\Server\extensions\installed\EPOCore\5.9.1.251\install.xml:188: java.sql.SQLException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_EPOPolicyObjectSettings_EPOPolicySettings". The conflict occurred in database "<epo database name>", table "dbo.EPOPolicySettingsMT", column 'PolicySettingsID'. Cause
There are one or more missing entries in the ePO database.
Solution
To determine if you have this issue, run the following query against the ePO database using Management Studio: IMPORTANT:
Affected ProductsLanguages:This article is available in the following languages: |
|