DLP upgrade fails during 'DatabaseUpdate' with ORA-00933

Products

• Data Loss Prevention

Issue/Introduction

When performing the Enforce Server upgrade to DLP 16.1 or 25.1, the Migration fails during phase 2 during DatabaseUpdate

MigratorUtility logs report:

TASK_ID     : 8
TASK_NAME   : Data Migration
BATCH_NUM   : 1
ERROR_TYPE  : FATAL
ERRANT_STMT : UPDATE AipLabel SET formattedName = 'Example's name' WHERE aipLabelId = ##
ERROR     : ORA-00933: SQL command not properly ended
====================================================================================================
 
TASK_ID     : 8
TASK_NAME   : Data Migration
BATCH_NUM   : 1
ERROR_TYPE  : FATAL
ERRANT_STMT :
ERROR     : ORA-20001: UpgradeSchema_Data_Migration.Data_Migration: User-Defined Exception

Environment

Symantec Data Loss Prevention 16.1 and 25.1

Cause

The error appears because MIP labels in the DLP environment have a ' in the name. This causes the Oracle commands to end prematurely during the upgrade.
This has been resolved in DLP 26.1

Resolution

Apply one of the following three options:

Option 1:

1. Revert both your Database and Enforce Server to the backups taken before the upgrade attempt.
2. Update the MIP labels to remove any ' in the names.
3. Re-run the upgrade.

Option 2:

1. Revert both your Database and Enforce Server to the backups taken before the upgrade attempt.
2. Upgrade to DLP 26.1

Option 3: If Option 1 or 2 are not possible

1. Revert both your Database and Enforce Server to the backups taken before the upgrade attempt.
2. Contact Support for further assistance