Symptom
The following error is generated when connecting to PRD:
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException: java.io.IOException: Server returned HTTP response code: 500 for URL: https://<customer instance>-stage.plateau.com/vjdbc/vjdbc
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors Learning
Reproducing the Issue
-
VJDBC connection has been confirmed as been created
-
Connect to PRD and the error is generated:
Cause
There are two possible causes:
- Error is generated as there are no tables in the BIRT schema you are trying to connect to.
- The customers BIRT schema password was not the same as the one in their configuration.
Resolution
Support should engage with the Operations team to check the configuration to see if there is a need for rebuilding BIRT schema after validating the setup of the vjdbc already performed.
Keywords
sf, success factors, LMS, BIRT, PRD, JDBCException: There is an error in get connection, java.sql.SQLException: java.io.IOException, Server returned HTTP response code: 500 for URL, COSD-22215, COSD-30631 , KBA , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , LOD-SF-LMS-REP , Reporting Data , Problem