You would want to work with McAfee Support on this.
Upgrade of DLPE 9.3.0 to 9.3.1 fails with a SQL Error
Technical Articles ID: KB79973
Last Modified: 20/01/2014
EnvironmentMcAfee Data Loss Prevention Endpoint (DLPE) 9.3
The article referenced above is available to registered ServicePortal users only.
To view registered articles:
- Log in to the McAfee ServicePortal at http://support.mcafee.com.
- Type the Article ID in Search the Knowledge Center on the Home page.
- Click Search or press ENTER.
ProblemWhen attempting to upgrade the DLPE extension from 9.3.0 to 9.3.1, the upgrade fails and the following error displays:Unable to install extension. Installation error: custom_tasks: upgrade: [echo] Upgrade called for DATALOSS2000 (version 126.96.36.199) [execute-sql] [execute-sql] [execute-sql] [execute-sql] [execute-sql] [execute-sql] [execute-sql] [execute-sql] [execute-sql] [execute-sql] [execute-sql] [execute-sql] [execute-sql] [execute-sql] install_query_group: install_query_group: Queries_v9.0.1_rollup: Delete_Queries_v9.0.1_rollup: Queries_v9.1.0_rollup: Delete_Queries_v9.1.0_rollup: Remove-Rollup-Queries: Remove-EnforcedRules-Rollup: Remove-Events-Rollup: Remove-CMAProperties-Rollup: Remove-MAProperties-Rollup: Remove-Passwords-Rollup: install-rollup: Add-Rollup: [execute-sql] Remove-EnforcedRules-Rollup: Add-EnforcedRules-Rollup: Remove-Events-Rollup: Add-Events-Rollup: Remove-CMAProperties-Rollup: Add-CMAProperties-Rollup: Remove-MAProperties-Rollup:
UniqueKey (dlp.prop.rollup.bypassed.agents) already exists in a read-only query Violates uniqueness constraint
CauseThe default DLP queries were modified and cannot be upgraded automatically during the extension upgrade process.
SolutionThis issue will be resolved in DLPE 9.3.3, which is not currently available. This article will be updated as newer information becomes available.
WorkaroundNOTE: McAfee recommends that you always maintain a current backup of the ePO server and SQL database before running any queries or updates against the database. For detailed information, see KB66616.
For ePO 4.x and 5.0:
Delete from OrionQuery where UniqueKey like 'dlp%'
Delete from OrionQueryMT where UniqueKey like 'dlp%'