Primavera Data Warehouse Diagnostic Utility Fails With Error "Checking SQLPlus connection to STAR... com.oracle.pgbu.ercheck.CheckLogger [main] ERROR ERCHECKER - java.lang.Exception"

(Doc ID 2399989.1)

Last updated on MAY 25, 2018

Applies to:

Primavera Data Warehouse - Version 15.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the Primavera Data Warehouse Diagnostic utility, the following error occurs:

ERROR
-----------------------
Checking SQLPlus connection to STAR... com.oracle.pgbu.ercheck.CheckLogger 14:03:02.800 [main] INFO ERCHECKER - running sqlplus -L STARUSER/xxxxxx@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxx)(PORT=xxxx))(CONNECT_DATA=(SID=xxxxx))) @./checksysuser.sql
FAIL
com.oracle.pgbu.ercheck.CheckLogger 14:03:03.394 [main] ERROR ERCHECKER - java.lang.Exception:
java.lang.Exception:
at com.oracle.pgbu.ercheck.checks.SqlPlusConnectionChecker.runCheck(SourceFile:50) ~[prm-erchecker.jar:?]
at com.oracle.pgbu.ercheck.AbstractChecks.runChecks(SourceFile:28) [prm-erchecker.jar:?]
at com.oracle.pgbu.ercheck.StarChecks.main(SourceFile:54) [prm-erchecker.jar:?]


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Configure Primavera Data WareHouse (config.sh/.cmd).
2. Finally run the Data WareHouse Diagnostic step, but fail with above error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the Data WareHouse Diagnostic step successfully.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms