Error: "ORA-06512: at "PROTECT.UPGRADESCHEMA_SDI_MIGRATION"" during phase 2 of the DLP upgrade

Products

• Data Loss Prevention
• Data Loss Prevention Enforce

Issue/Introduction

The phase 2 DLP migration fails with the following error:

BEGIN
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "PROTECT.UPGRADESCHEMA_SDI_MIGRATION", line 1388
ORA-06512: at "PROTECT.UPGRADESCHEMA_SDI_MIGRATION", line 727
ORA-06512: at line 285
 
 
No errors.
 
SQLPlus standard output end
Apr 16, 2024 7:38:24 AM com.symantec.dlp.migrationcommon.MigrationActionsExecutor executeMigrationActions
SEVERE: Failed to execute migration actions. Please refer to the log file for details
com.symantec.dlp.migrationcommon.MigrationException: Failed to run migration action "DatabaseUpdate"
at com.symantec.dlp.migrationcommon.MigrationActionsExecutor.runMigrationAction(MigrationActionsExecutor.java:72)
at com.symantec.dlp.migrationcommon.MigrationActionsExecutor.executeMigrationActions(MigrationActionsExecutor.java:118)
at com.symantec.dlp.migrationcommon.MigrationUtility.runMigrationUtility(MigrationUtility.java:183)
at com.symantec.dlp.migrationcommon.MigrationUtility.runMigrationUtility(MigrationUtility.java:109)
at com.symantec.dlp.migrationcommon.MigrationUtility.runMigrationUtility(MigrationUtility.java:119)
at com.symantec.dlp.enforceservermigrationutility.EnforceServerMigrationUtility.runMigration(EnforceServerMigrationUtility.java:37)
Caused by: com.symantec.dlp.migrationcommon.MigrationException: com.symantec.dlp.migrationcommon.MigrationException: java.lang.Exception: SQLPlus error: 
Type created.

 

Note that the line numbers in the above ORA-06512 lines may differ depending upon the DLP version you upgrade from and to.

Resolution

Roll back to (restore) the previous DLP version.

Open a case with Support and provide this KB number.
Collect the following data, if it exists, and attach it to your case.

Collect the MigrationUtility.log from each version you have upgraded from starting with 15.8.
C:\ProgramData\Symantec\DataLossPrevention\DetectionServer\<DLPversion>\logs\debug\migrationutility.log

Collect the following files from each version you have upgraded from starting with 15.8:
"<dir>:\Program Files\Symantec\DataLossPrevention\EnforceServer\<version>\Protect\Migrator\SQL\add_di_regex_pattern.sql"
"<dir>:\Program Files\Symantec\DataLossPrevention\EnforceServer\<version>\Protect\Migrator\SQL\update_di_prepost_valid_characters.sql"

Label each of the files with the version they came from.