Symptom
After a recent refresh, connecting with Plateau Report Developer (PRD) client, the connection fails with error:
Failed: java.sql.SQLException: java.io.IOException: Server returned HTTP response code: 500 for URL: https://<LMS-URL>/vjdbc/vjdbc
Environment
SAP SuccessFactors Learning
Reproducing the Issue
-
Validate the PRD client was connecting successfully before an Instance is refreshed.
- After Instance refresh, ensure default REPORT_DEVELOPER security role exists within Learning Administration and is assigned to the same admin.
- Open the PRD client and test connection to receive the error.
Cause
VJDBC connection details on database may need to be modified after some Instance Refreshes
Resolution
A Customer Success case can be opened to request Operations DB team to run the VJDBC script for 500 error.
See Also
2104424 - Connect to LMS stage instance via Plateau Report Designer
2324168 - Connecting Plateau Report Designer with LMS Database
2324197 - Plateau Report Designer Problems
Keywords
SF, LMS, connect, data source, JDBC, report_developer, developing, custom reporting, PRD, error 500 , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-CRI , Custom Report Issues , Problem