SAP Knowledge Base Article - Public

2635356 - 504 error PRD - PA_CPNT_FORMULA & PA_CPNT_FORMULA_FIN_VAR

Symptom

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".

Environment

SAP SuccessFactors Learning Management System (LMS)

Cause

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.

Resolution

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.

See Also

2544735 - LMS - General guide for using Plateau Report Designer (SAP Wiki)

Keywords

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

Product

SAP SuccessFactors Learning all versions