Data Loss Prevention upgrade fails during the Data Migration task. Unique constraint when merging application.

Products

• Data Loss Prevention Endpoint Prevent

Issue/Introduction

Data Loss Prevention (DLP) upgrade fails during the Data Migration task. The migration SQL script fails when attempting to merge built-in applications into the Application table.

The following error appears in the upgrade logs: ERROR : ORA-00001: unique constraint (PROTECT.SYS_C007694) violated

The errant statement involves a MERGE INTO Application command attempting to insert or update an application (such as iCloud (Mac) or fileproviderd) where the IDENTIFIER already exists in the database but is marked as deleted.

Environment

DLP environment that has been upgraded from a prior release . 

Cause

This issue occurs when a previous upgrade or administrative action added a built-in application to the database that was subsequently deleted (ISDELETED = 1). and then later merged due to the application becoming a built-in application as part of a new feature
The upgrade migration script attempts to insert the application as a new record because it only searches for active records (ISDELETED = 0). Because the IDENTIFIER (e.g., -189) must be unique, the insertion fails with a unique constraint violation.

Resolution

 Identify built-in applications mistakenly marked as deleted before proceeding with the upgrade.

1. Run the following SQL query as the database schema owner to identify affected records:

   SELECT applicationid, productalias, binaryname, internalname, originalfilename, isdeleted FROM application WHERE identifier < 0 AND isdeleted = 1;

2. If the query returns any rows, contact Broadcom Support for assistance in correcting the data state.