SAP Knowledge Base Article - Public

2635704 - PRD Error "Server returned HTTP response code: 500 for URL" - LMS

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 Management System

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:

  1. Error is generated as there are no tables in the BIRT schema you are trying to connect to.
  2. The customers BIRT schema password was not the same as the one in their configuration.

Resolution

Product Support should engage with the Operations team via COSD JIRA to check the configuration to see if there is a need for rebuilding BIRT schema.

Keywords

SF, Success Factors, LMS, learning, 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