SAP Knowledge Base Article - Public

2635704 - PRD Error "Server returned HTTP response code: 500 for URL" in SuccessFactors Learning

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

  1. VJDBC connection has been confirmed as been created
  2. Connect to PRD and the error is generated:

KBA PRD error.jpg

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

Product

SAP SuccessFactors Learning all versions