"Failed to run Migration Action Compiledbpackages" EnforceMigrationUtility

book

Article ID: 184648

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

When running the EnforceMigrationUtiltiy the utility exits with an error. 

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

The oracle client is not set in the path variable and oracle home is not set.

No Oracle home set see error below:

com.symantec.dlp.enforceservermigrationutility.actions.util.OracleUtilities.getOracleHome

 

Environment

DLP 15.5 upgrade from DLP 15.1 

Resolution

go to System>advanced system settings> enviroment variables 

select New > variable name = ORACLE_HOME, variable value = C:\oracle\product\12.1.0.2.0\db_1

select Path variable > select edit > add C:\oracle\product\12.1.0.2.0\db_1\bin > select OK

 

NOTE: Paths maybe different depending on where oracle client is installed.

NOTE 2: While in the Migrator folder you should be to run the command 'sqlplus' and have the program execute. If it does not then the path variable needs to be checked.