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 futher reources.
See Also
- 2074219 - Configure PRD to connect to a database through a proxy
- 2324197 - Plateau Report Designer problems
- Proxy Server Settings for Plateau Report Designer
- Using Plateau Report Designer
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