Error: "Failed to execute migration actions" when migrating DLP to 15.8
Article ID: 211085
Updated On:
Products
Issue/Introduction
Symantec Data Loss Prevention (DLP) migration fails during phase 2 due to a time-out.
Migration log error:
SQLPlus standard output end
Mar 09, 2021 10:50:47 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:168)
at com.symantec.dlp.migrationcommon.MigrationUtility.runMigrationUtility(MigrationUtility.java:106)
at com.symantec.dlp.migrationcommon.MigrationUtility.runMigrationUtility(MigrationUtility.java:112)
at com.symantec.dlp.enforceservermigrationutility.EnforceServerMigrationUtility.runMigration(EnforceServerMigrationUtility.java:37)
Caused by: com.symantec.dlp.migrationcommon.MigrationException: com.symantec.dlp.migrationcommon.MigrationException: Failed to execute migration SQL script
at com.symantec.dlp.enforceservermigrationutility.actions.DatabaseUpdateMigrationAction.runAction(DatabaseUpdateMigrationAction.java:98)
at com.symantec.dlp.migrationcommon.MigrationActionsExecutor.runMigrationAction(MigrationActionsExecutor.java:65)
... 5 more
Caused by: com.symantec.dlp.migrationcommon.MigrationException: Failed to execute migration SQL script
at com.symantec.databasemigration.DatabaseMigrationProvider.migrate(DatabaseMigrationProvider.java:60)
at com.symantec.dlp.enforceservermigrationutility.actions.DatabaseUpdateMigrationAction.runAction(DatabaseUpdateMigrationAction.java:89)
... 6 more
Caused by: java.lang.Exception: SQLPlus timed out
at com.symantec.databasemigration.oracle.sqlplus.SQLPlusExecutor.execute(SQLPlusExecutor.java:185)
at com.symantec.databasemigration.oracle.sqlplus.SQLPlusExecutor.execute(SQLPlusExecutor.java:127)
at com.symantec.databasemigration.DatabaseMigrationProvider.migrate(DatabaseMigrationProvider.java:55)
... 7 more
Environment
Release : 15.8
Component : Upgrade Migrator
Cause
Longer running migrations can now timeout if the run_upgradeschema.sql takes longer than 20 minutes to complete.
Resolution
For some deployments, the database upgrade takes more than the 20 minute execution timeout during phase 2 of the migration to Symantec Data Loss Prevention 15.8. Symantec has provided a fix for the issue.
The fix is contained in the Preventing_DLP_15.8_migration_timeouts.zip file, which is available from the Product Downloads portal. See the readme file included with the download for steps to install the fix.
The migration logs should be stored here: "Install Drive:\SymantecDLP\EnforceServer\15.80000\logs\debug\migrator_report\"
Feedback
