SAP Knowledge Base Article - Public

2744375 - SSL Handshake Error When Connecting to Plateau Report Designer

Symptom

  • An SSL handshake error happens when trying to connect to Plateau Report Designer.
    • Error:org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException: javax.net.ssl.SSLHandshakeException: Received fatal alert: handshake_failure
  • Connection is possible using a different computer

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Open the Plateau Report Designer
  2. Navigate to File > New > New Report
  3. Finish
  4. Data Menu > New Data Source
  5. After selecting the "JDBC Data Source", fill out the needed information
  6. Test Connection
  7. Error comes up

Cause

This error is caused the network or computer settings that are preventing the connection to PRD.

Resolution

The below steps represent a possible solution for the error. If you continue to receive the error after following these steps, please contact the IT department from your company for assistance as the network and computer settings will need to be reviewed to identify what is causing the error.

The PlateauReportDesigner.ini file will need to be modified.  This file can be located in the root directory of PRD (ex.: C:\Program Files (x86)\PlateauReportDesigner).

Firstly, open the file with a text editing program (Textpad, Notepad, Notepad++). By default, you should see the following lines:

-vmargs
-Xms40m
-Xmx256m
-XX:MaxPermSize=128m

If configured to connect the PRD to the database through a proxy, there may also be the additional lines:

-Dhttp.proxySet=true<===Required - keep at http regardless if http or https is being used
-Dhttp.proxyHost=[value of proxy host]<==If using http
-Dhttp.proxyPort=[value of proxy port]<==If using http

OR

-Dhttps.proxyHost=[value of proxy host]<==If using https
-Dhttps.proxyPort=[value of proxy port]<==If using https

The following line is a user id/password combo that is also required to access the internet via the Proxy.

-Dhttp.proxyUser=[User ID]
-Dhttp.proxyPassword=[Password]

The final file should look like this:

-vmargs
-Xms40m
-Xmx256m
-XX:MaxPermSize=128m
-Dhttp.proxySet=true
-Dhttps.proxyHost=proxy.companyname.com
-Dhttps.proxyPort=1234
-Dhttp.proxyUser=TomUser
-Dhttp.proxyPassword=password

In regards to the handshake error, add the following:

"

-Dhttps.protocols=TLSv1.2

"

It can be inputted directly below the properties for "-Dhttp.proxySet", "-Dhttps.proxyHost", and "-Dhttps.proxyPort"

Save the file.

Keywords

error connecting to PRD, handshake_failure, plateau, report, designer, learning, lms, sf , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , Problem

Product

SAP SuccessFactors Learning all versions