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.

See Also

Proxy Server Settings for Plateau Report Designer

2379690 - LMS: Custom Report Development and Support

Using Plateau Report Designer

2171592 - What's the process to set up REPORT_DEVELOPER Role and VJDBC Setup to enable the use of Plateau Report Designer?

2318900 - How to download the latest version Plateau Report Designer (PRD)

2544735 - How to find Plateau Report Designer (PRD) Job Aids, Training and Guides

2324197 - Plateau Report Designer problems

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 , SuccessFactors Learning , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-PRD , Plateau Report Designer , How To

Product

SAP SuccessFactors Learning all versions