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

  • SAP SuccessFactors Learning - 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

See Knowledge Base Article 2074219 - "Configure PRD to connect to a database through a proxy" and refer to your IT team for further troubleshooting regarding proxy connections or refer to the See Also section below for further resources.

See Also

Keywords

success factors; test connection; PRD; PlateauReportDesigner.ini; proxy; UnknownHostException; java.net.UnknownHostException; Connection reset , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , Problem

Product

SAP SuccessFactors Learning all versions