"Failed to run Migration Action Compiledbpackages" when running EnforceMigrationUtility

Products

• Data Loss Prevention Enforce
• Data Loss Prevention

Issue/Introduction

The following error occurs when running the EnforceMigrationUtility, and the utility closes automatically:

SEVERE: Failed to execute migration actions. Please refer to the log file for details
com.symantec.dlp.migrationcommon.MigrationException: Failed to run migration action "CompileDbPackages"
at com.symantec.dlp.migrationcommon.MigrationActionsExecutor.runMigrationAction(MigrationActionsExecutor.java:54)
at com.symantec.dlp.migrationcommon.MigrationActionsExecutor.executeMigrationActions(MigrationActionsExecutor.java:100)
at com.symantec.dlp.migrationcommon.MigrationUtility.runMigrationUtility(MigrationUtility.java:117)
at com.symantec.dlp.migrationcommon.MigrationUtility.runMigrationUtility(MigrationUtility.java:70)
at com.symantec.dlp.enforceservermigrationutility.EnforceServerMigrationUtility.runMigration(EnforceServerMigrationUtility.java:17)
Caused by: java.nio.file.InvalidPathException: Illegal char <"> at index 0: "C:\OracleClient12c_64bit\oracle\product\client\12.2.0"
at sun.nio.fs.WindowsPathParser.normalize(WindowsPathParser.java:182)
at sun.nio.fs.WindowsPathParser.parse(WindowsPathParser.java:153)
at sun.nio.fs.WindowsPathParser.parse(WindowsPathParser.java:77)
at sun.nio.fs.WindowsPath.parse(WindowsPath.java:94)
at sun.nio.fs.WindowsFileSystem.getPath(WindowsFileSystem.java:255)
at java.nio.file.Paths.get(Paths.java:84)
at com.symantec.dlp.enforceservermigrationutility.actions.util.OracleUtilities.getOracleHome(OracleUtilities.java:22)
at com.symantec.dlp.enforceservermigrationutility.actions.CompileDbPackagesAction.runAction(CompileDbPackagesAction.java:48)
at com.symantec.dlp.migrationcommon.MigrationActionsExecutor.runMigrationAction(MigrationActionsExecutor.java:47)
... 4 more

Cause

1. The Oracle client is not set in the path variable and Oracle home is not set, which produces the following error:
   
   com.symantec.dlp.enforceservermigrationutility.actions.util.OracleUtilities.getOracleHome
   
   
2. Some or all of the Database Objects are in a NONEDITIONABLE state, which is not supported by DLP.

Resolution

1. Add the client to the path variable.
   1. Go to System > Advanced System Settings > Environment Variables.
   2. Select New > variable name = ORACLE_HOME, variable value = C:\oracle\product\19.x.x.x\db_1.
   3. Select Path variable > select Edit > add C:\oracle\product\19.x.x.x\db_1\bin > and click OK.
      Note: Paths may be different depending on where the Oracle client is installed.
   4. While in the Migrator folder you should be able to run the command 'sqlplus' and have the program execute. If it does not run, then you need to check the path variable.
      
      
2. Change the DB Objects from "NONEDITIONABLE" to "EDITIONABLE".
   1. The responsible DBA will need to make this change.