When adding the PA_CPNT_FORMULA & PA_CPNT_FORMULA_FIN_VAR tables in a query, the system throws "There is an error in get connection, java.SQL.Exception: java.io.IOException: Server returned HTTP response code: 504 FOR url: your LMS VJDBC".
SAP SuccessFactors Learning Management System (LMS)
The error is being generated because there is a timeout from a server or an intermediary waiting for the request to complete from the VJDBC connection.
If you are working on a report within Plateau Report Designer (PRD), it is necessary to add a limit to the data that is being returned. If no filters are added to the report then what PRD is trying to do is preview all data that should be returned.
As an example, it is possible to test this by running the desired report for a subset of users, like three users. Take a note of the three users, add them to the query in PRD and run it again. Instead of trying to preview the data for all users, it will now just check for three.
PRD, 504, java.SQL.Exception, java.io.IOException, PA_CPNT_FORMULA, PA_CPNT_FORMULA_FIN_VAR , KBA , LOD-SF-LMS , SuccessFactors Learning , LOD-SF-LMS-PRD , Plateau Report Designer , Problem