2074219 - Configure PRD to connect to a database through a proxy

SAP Knowledge Base Article - Public

2074219 - Configure PRD to connect to a database through a proxy

Symptom

  • How to configure PRD to connect to the hosted staging database through a Proxy.
  • When connecting, the admin user may generate the following error which indicates a Proxy issue: 
    • org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException: java.net.UnknownHostException

PROXY error.jpg

Environment

SuccessFactors Learning Management System (LMS) - All Supported Versions

Resolution

To configure PRD to connect through a Proxy, the PlateauReportDesigner.ini file will need to be modified.  This file can be located in the root directory of PRD (e.g. 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

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
-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 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]

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

Save the file.

Keywords

PRD; proxy; firewall; database; org.eclipse.birt.report.data.oda.jdbc.JDBCException; There is an error in get connection; java.sql.SQLException; java.net.UnknownHostException; , KBA , LOD-SF-LMS-PRD , Plateau Report Designer , LOD-SF-LMS-REP , Reporting Data , How To

Product

SAP SuccessFactors Learning all versions