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.
SAP SuccessFactors Learning
Reproducing the Issue
VJDBC connection has been confirmed as been created
Connect to PRD and the error is generated:
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.
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.
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