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 18, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.3.2.0 and later
Information in this document applies to any platform.

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

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