Enforce 15.5 EnforceMigrationUitlity failure with: Failed to read installation parameters error

Products

• Data Loss Prevention Enforce

Issue/Introduction

Data Loss Prevention (DLP)

The migration utility fails imediately and the logs report " Failed to read installation parameters error".

SEVERE: Failed to read installation parameters
com.symantec.dlp.migrationcommon.MigrationException: Problem occurred 
reading Oracle parameters
.
.
.

com.symantec.dlp.enforceservermigrationutility.EnforceMSIInstallationParamet
ersReader.readInstallationParameters(EnforceMSIInstallationParametersReader.
java:35)
.
.
.
com.symantec.dlp.enforceservermigrationutility.EnforceServerMigrationUtility
.runMigration(EnforceServerMigrationUtility.java:17)
Caused by: com.symantec.dlp.migrationcommon.MigrationException: Problem 
parsing jdbc.dbalias.oracle-thin
        

Cause

This issue is due to Oracle expecting the jdbc string to be in a certain format and is case sensitive.

Environment

EnforceMigrationUtility.exe for 15.5 

Resolution

This issue is fixed in versions above 15.5.
Versions 15.5 and below follow the below workaround. 

WORKAROUND:

The JDBC string in jdbc.properties from the current version has some formating issues - such as extra spaces in the string - or has case sensitivivity issues in versions 15.5 and below.

E.g., if as below

[email protected](description=(address = (host=192.168.1.5)(protocol = tcp)(port = 1521))(connect_data=(SERVICE_NAME = protect)))

change to 

[email protected](description=(address=(host=192.168.1.5)(protocol=tcp)(port=1521))(connect_data=(service_name=protect)))