Error: "PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target" In P6WebAcess.html Log File When Utilizing An SSL Connection To The P6 EPPM Database (Doc ID 1970878.1)

Last updated on JULY 25, 2023

Applies to:

Symptoms

When attempting to login to the P6 (web) module after creating a connection to the oracle database over the SSL protocol, the following error occurs on the login page of P6 after entering in the username/password:
"Unexpected login error. Please contact your administrator."

The following errors are generated in the P6WebAccess.html log file after the failed login attempt:

ERROR
-----------------------
MESSAGE CATEGORY
Establish connection error. Pool=PMR


STACKTRACE
-----------------------

java.sql.SQLRecoverableException: IO Error: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:467)
  at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:546)
  at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:236)
  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
  at java.sql.DriverManager.getConnection(DriverManager.java:571)
  at java.sql.DriverManager.getConnection(DriverManager.java:187)
  at com.primavera.infr.db.PoolableConnection.a(Unknown Source)
  at com.primavera.infr.db.SQLConnectionPool.d(Unknown Source)
  at com.primavera.infr.db.SQLConnectionPool.getConnection(Unknown Source)
  at com.primavera.infr.db.SQLConnectionPool.getConnection(Unknown Source)
  at com.primavera.infr.srvcs.LicenseServiceImpl$EnterpriseManagerJob.execute(Unknown Source)
  at com.primavera.infr.threadpool.ThreadPoolException refreshing Job Master Could not get JDBC Connection; nested exception is java.sql.SQLException: Establish connection error.Impl.run(Unknown Source)
  at java.lang.Thread.run(Thread.java:745)
Caused by: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.