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
- Use PRD to connect to an LMS Stage database
- 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:
- Error message (in a TXT file + screenshot)
- VJDBC URL
- 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