SAP Knowledge Base Article - Public

2104429 - 'java.net.UnknownHostException' error generated when testing connection to PRD

Symptom

Error is generated when testing connection to SuccessFactors Learning in Plateau Report Designer:

org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException: java.net.UnknownHostException: <host name>

OR

org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException: java.net.SocketException: Connection reset

Environment

  • SuccessFactors Learning Management System (LMS) - All Supported Versions
  • Plateau Report Designer (PRD) 

Reproducing the Issue

1. Create an JDBC Data Source to SuccessFactors Learning in PRD.
    => For hosted customer, please refer KBA 2104424 about how to build one connection to hosted stage database in PRD.

2. Click Test Connection button.
    => Test failed with error "java.net.UnknownHostException".
    => Error detail:
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException: java.net.UnknownHostException: <host name>
      at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
      at java.net.PlainSocketImpl.connect(Unknown Source)
      at java.net.SocksSocketImpl.connect(Unknown Source)
      at java.net.Socket.connect(Unknown Source)
      at  ....

OR

org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at sun.security.ssl.InputRecord.readFully(Unknown Source)
at sun.security.ssl.InputRecord.read(Unknown Source)
at sun.security. ....

Cause

You may require a Proxy in your network environment to access internet, but it is not configured for PRD to connect to the hosted stage database through a Proxy.

Resolution

Go to root directory of PRD (e.g. C:\Program Files (x86)\PlateauReportDesigner).

1. Open file PlateauReportDesigner.ini with a text editing program (e.g. NotePad).
    => By default, you should see the following lines:
    -vmargs
    -Xms40m
    -Xmx256m
    -XX:MaxPermSize=128m

2. Add the following lines to the file as appropriate. Notations following each line describing when and if it should be included)
   -Dhttp.proxySet=true (Required - keep at http regardless if http or https is being used)

   (If using http)
   -Dhttp.proxyHost=[value of proxy host]     
   -Dhttp.proxyPort=[value of proxy port]        

  OR

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

3. The following should be added is a user id/password combo is required to access the internet via the Proxy. 
   -Dhttp.proxyUser=[User ID]
   -Dhttp.proxyPassword=[Password]

4. For hosted customer, as we use VJDBC url to connect to hosted staging database which includes https, https proxy should be used. So the final file should look like this:
   -vmargs
   -Xms40m
   -Xmx256m
   -XX:MaxPermSize=128m
   -Dhttp.proxySet=true
   -Dhttps.proxyHost=<replace with proxy host>
   -Dhttps.proxyPort=<replace with proxy port>
   -Dhttp.proxyUser=<replace with proxy user>
   -Dhttp.proxyPassword=<replace with proxy user password>

Keywords

test connection, PRD, PlateauReportDesigner.ini, proxy, UnknownHostException, LMS, learning, stage, staging, hosted, java.net.UnknownHostException, Connection reset , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-PRD , Plateau Report Designer , Problem

Product

SAP SuccessFactors Learning all versions