2581167 - PRD error "unable to find valid certification path to requested target"

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

• SAP SuccessFactors Learning
• Plateau Learning Report Designer (PRD)

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

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

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. Make sure you are using the new process to login the PRD. Please kindly check KBA 2981530 for further guidance. 
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 engaged to check with operations if they are any connections issues on our end.

Note: Please note below are some settings which worked for few customers and was proposed by their IT Team. We would suggest you to explore these settings with your IT team and see if this works for you. However,please be informed that this solution/settings are out of LMS and is not in SAP Support scope. 

Please check with your IT team if you are behind a proxy server. If so, then you can apply below Proxy settings in order to fix the issue:

Proxy Server Settings (required for users that are behind a Proxy Server)

1. In a text editor, open My Documents/Plateau Report Designer/PlateauReportDesigner.ini, and add one of the following blocks of code:

       SSL -Dhttp.proxySet=true -Dhttps.proxyHost=[value of proxy host] -Dhttps.proxyPort=[value of proxy port]

       Non SSL -Dhttp.proxySet=true -Dhttp.proxyHost=[value of proxy host] -Dhttp.proxyPort=[value of proxy port]

       Example -Dhttp.proxySet=true -Dhttps.proxyHost=10.0.1.15 -Dhttps.proxyPort=8080

1. Set any other properties you need to set, e.g. -Dhttp(s).nonProxyHosts, -Dhttp.proxyUser, and -Dhttp.proxyPassword.
2. Save and close the PlateauReportDesigner.ini file.
3. Restart Plateau Report Designer.

Please check internally with your IT team if you are using SSL proxy or Non SSL Proxy and apply the settings accordingly

KBA: 2981530 - New Plateau Report Designer (PRD) Authentication and Launching - 2H 2020 [LMS]

SF SuccessFactors, LMS, Learning Eclipse, BIRT, PRD, Plateau Learning Report Designer, JDBCException, VJDBC valid certificate, SunCertPathBuilderException, JAVA, unable to find valid certification path to requested target , KBA , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-REP , Reporting Data , Problem