SAP Knowledge Base Article - Public

2581167 - Plateau Report Designer throws "unable to find valid certification path to requested target" JDBCException when connecting

Symptom

When attempting to connect to VJDBC data source using Plateau / Learning Report Designer (PRD), the following error occurs:

org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

Environment

  • SAP SuccessFactors Learning Management System (LMS)
  • Plateau Learning Report Designer (PRD)

Reproducing the Issue

  1. Setup VJDBC connection to non-production learning system (see KBA 2171592 for details on how to do this)
  2. Attempt to connect or test connection
  3. The following JDBCException is thrown:
    1. org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

Cause

This is likely due to a certificate or Java installation issue on the client the Plateau Report Designer is running on

Resolution

The exception indicates that the key chain of the certificate is broken or that it’s simply a self signed certificate:

  • The "unable to find valid certification path to requested target" message is being produced due to the missing intermediate certificate
  • Check with your local IT Department for any certificate issues as the SuccessFactors Support and Operations team do not have access or insight on the certificate or Java setup on the environment the PRD is being run

Some things to check to help troubleshoot if a certificate issue is not discovered:

  1. The REPORT_DEVELOPER role remains assigned to the User connecting via VJDBC
  2. The User is able to log on to the LMS natively (https://[instancename].plateau.com/learning/admin/nativelogin.jsp
  3. Test connecting outside of the company network
  4. Test connecting from a different machine and network
  5. If the above 4 steps do not end up working, support may be enaged to check with operations if they are any connecitons issues on our end.

Keywords

SF SuccessFactors LMS Learning Eclipse BIRT PRD Plateau Learning Report Designer JDBCException JDBC exception VJDBC unable cannot can't connect valid certificate SunCertPathBuilderException JAVA COSD-14487 , KBA , LOD-SF-LMS , SuccessFactors Learning , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-PRD , Plateau Report Designer , Problem

Product

SAP SuccessFactors Learning 1711