SAP Knowledge Base Article - Public

2531352 - Errors When Connecting to Plateau Report Designer

Symptom

Any of the following errors may occur when trying to connect to Learning Database using PRD (Plateau Report Designer):

  • HTTP 502:

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: 502 for URL: https://<baseURL>/vjdbc/vjdbc at sun.net.http://www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source) at sun.net.http://www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)

  • HTTP 504:

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: 504 for URL: https://<baseURL>/vjdbc/vjdbc at sun.net.http://www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source) at sun.net.http://www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)

  • Error to connect:

org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, java.sql.SQLException: java.io.EOFException at java.io.ObjectInputStream$BlockDataInputStream.peekByte(Unknown Source) at java.io.ObjectInputStream.readObject0(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at de.simplicit.vjdbc.servlet.ServletCommandSinkJdkHttpClient

  • Unknown user:

java.sql.SQLException:de.simplicit.jvdbc.VJdbcException: Unknown user USER <username> at com.plateau.vjdbc.PlateauLoginHandler.checkLogin(PlateauLoginHandler.java:80)

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Use PRD to connect to an LMS Stage database
  2. The connection is refused

Resolution

Initially, make sure that REPORT_DEVELOPER is in the system and is associated to the admin user that is attempting to connect. Reference 2171592 for all initial setup information.

If the issue is still occurring, please submit a case, providing ALL the following information:

  1. Error message (in a TXT file + screenshot) 
  2. VJDBC URL
  3. Admin ID used to login in PRD

Keywords

SF, success factors, LMS, PRD, rpt, connection issue , KBA , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , Problem

Product

SAP SuccessFactors HCM suite all versions ; SAP SuccessFactors Learning all versions