Error: "Failed to execute migration actions" when migrating DLP to 15.8

book

Article ID: 211085

calendar_today

Updated On:

Products

Data Loss Prevention Enterprise Suite Data Loss Prevention Data Loss Prevention Enforce

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

Cause

Longer running migrations can now timeout if the run_upgradeschema.sql takes longer than 20 minutes to complete.

Environment

Release : 15.8

Component : Upgrade Migrator

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\"