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

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.