Upgrade Readiness Tool java.lang.NumberFormatException error

Products

• Data Loss Prevention Enterprise Suite
• Data Loss Prevention Enforce
• Data Loss Prevention
• Data Loss Prevention Core Package
• Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

When running the Update Readiness Tool (URT) an error occurs and the tools fail with an exception in thread "main" java.lang.NumberFormatException:

X:\Program Files\Symantec\DataLossPrevention\EnforceServer\15.5\Protect\Migrator\URT>"C:\Program Files\AdoptOpenJRE\jdk8u262-b10-jre\bin\java" UpdateReadinessTool --username oracle --password xxxx --readiness_username urt_user --readiness_password xxxx --service_name protect --target_version 15.8
CMD: sqlplus -S -L <db_user/db_password> @script/dbconn_test.sql
connected
CMD: sqlplus -S -L <db_user/db_password> @script/dbconn_test.sql
connected
CMD: sqlplus -S -L <db_user/db_password> @script/DSH_DLP_Version.sql
CMD: sqlplus -S -L <db_user/db_password> @script/DSH_Version.sql 15.8
v15_8_2022_01_07-17-04-26
Exception in thread "main" java.lang.NumberFormatException: For input string: ""
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
        at java.lang.Integer.parseInt(Integer.java:592)
        at java.lang.Integer.valueOf(Integer.java:766)
        at UpdateReadinessTool.verifyUpdateReadiness(Unknown Source)
        at UpdateReadinessTool.main(Unknown Source)

Environment

Release : 15.x.

Component : URT

Cause

The oracle account being used in URT is not the DLP schema user.

Resolution

The correct DLP schema user can be verified by reviewing the Jdbc.properties file.

X:\Program Files\Symantec\DataLossPrevention\EnforceServer\15.x\Protect\config\Jdbc.properties
/opt/Symantec/DataLossPrevention/EnforceServer/15.8.00000/Protect/config/Jdbc.properties

URT needs to use the account that is listed in these values. 

jdbc.username.oracle=dlp_schema_user
jdbc.username.oracle-thin=dlp_schema_user

Once confirmed rerun URT using the correct user.