Migrator fails with 'Verify Database Process Migration Action failed as the database processes are still running' error

Products

• Data Loss Prevention
• Data Loss Prevention Enforce
• Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

Enforce During DLP 15.8 Migrator phase 2 you see Verify Database Process Migration Action failed as the database processes are still running in MigrationUtility logs. Have already confirmed with database team jobs are stopped as per guide Stopping Oracle database jobs

MigrationUtility.log: 

Apr 16, 2022 10:12:24 AM com.symantec.dlp.enforceservermigrationutility.actions.VerifyDatabaseProcessMigrationAction runAction
SEVERE: Verify Database Process Migration Action failed as the database processes are still running. Check the following KB article for solution.
https://knowledge.broadcom.com/external/article/173221/the-enforce-server-migration-may-fail-fo.html
Apr 16, 2022 10:12:24 AM com.symantec.dlp.enforceservermigrationutility.actions.VerifyDatabaseProcessMigrationAction runAction
SEVERE: Unexpected exception in Verify Database Process Migration Action.
com.symantec.dlp.migrationcommon.MigrationException: Verify Database Process Migration Action failed as the database processes are still running. Check the following KB article for solution.
https://knowledge.broadcom.com/external/article/173221/the-enforce-server-migration-may-fail-fo.html
 at com.symantec.dlp.enforceservermigrationutility.actions.VerifyDatabaseProcessMigrationAction.runAction(VerifyDatabaseProcessMigrationAction.java:70)
 at com.symantec.dlp.migrationcommon.MigrationActionsExecutor.runMigrationAction(MigrationActionsExecutor.java:65)
 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)

Environment

Release: 15.7, 15.8, 16.0

Component: Data Loss Prevention Enforce

Cause

DLP processes in database from Enforce server are still running.

Resolution

To allow the DB processes to stop, please terminate all DLP services (manually with kill command, if necessary) before running phase 2.