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

• 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

SAP SuccessFactors Learning

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.

Note: This information is to provide some guidance on setting up the proxy values. Assistance with setting up the proxy and finding the details falls outside the scope of Support due to the issue being on an external network. Please work with your IT team to find the values that are needed for the .ini file.

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?

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

2324197 - Plateau Report Designer problems

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 , connection timed out , jdbcexception , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , How To