When adding the PA_CPNT_FORMULA & PA_CPNT_FORMULA_FIN_VAR tables in a query, the system throws the following error:
There is an error in get connection, java.SQL.Exception: java.io.IOException: Server returned HTTP response code: 504 FOR url: <CUSTOMER LMS URL>
- SAP SuccessFactors Learning Management System (LMS) - All Supported Versions
- Plateau Report Designer (PRD)
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 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-PRD , VJDBC Setup or Connection Issues , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-REP , Reporting Data , Problem