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
Environment
SAP SuccessFactors Learning
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.
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.
See Also
Proxy Server Settings for Plateau Report Designer
2379690 - LMS: Custom Report Development and Support
2544735 - How to find Plateau Report Designer (PRD) Job Aids, Training and Guides
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 , 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