SAP Knowledge Base Article - Public

2258560 - Received "Bad Gateway", "Error 502" or "Time out error", blank screen when running table report online

Symptom

Users receive the below errors or an empty report when running certain Table reports online:

error.png Time out error1.jpg

Note: Running the report offline fetches expected results

Environment

  • SAP SuccessFactors HXM Suite
  • Table Reports

Reproducing the Issue

  1. Navigate to 'Table Reports' in the Reports Center
  2. Click the affected report and select 'Run Report'
  3. Choose the 'Run Online' option and Generate the Report
  4. In such cases the report run for over 5 minutes until the below messages are shown:
    1. Bad Gateway", "Error 502"
      • Bad Gateway!
      • The proxy server received and invalid response form an upstream server.
      • The proxy server could not handle the request POST/acme
      • Reason: Error reading from remote server
      • If you think this is a server error, please contact the webmaster
      • Error 502
      • performancemanager4.successfactors.com
      • Tue Nov 24 15.20.59.201
      • Apache
    2. Time Out error
      • Your report has timed out and cannot be completed Online. This could be due to a number of factors, including report size and complexity. Please run the report Offline
      • Show Exception Stack Trace

Cause

  • The Table reporting framework has a time-out limitation of 5 minutes
  • The report fails with the error since it took more than the defined time limit
  • Such errors may be caused by a temporary inconsistency with the Report Server communication

Resolution

There could be multiple reasons for such errors to occur - Table report size, complexity or some issues with the report server communication.

  • The issue occurs only with specific reports and they work at the preview screen and Run Offline,
    but not online or via export to excel.
    This report job is killed by the server since it kept running for more than 5 minutes.
    Please use the 'Run Offline' option.

    If you wish to Run it Online only, you could try reducing the report's runtime by modifying it.
    For example, adding/Removing filters, Use 'Team View' instead of 'Other Filters', etc.,

  • If the issue occurs with all Table reports independent of the complexity or output size, please refer KBA 2219570 and Report an case with the error and timestamp details.

Keywords

Error 502, Ad Hoc, Bad Gateway, Run, Online, Time Out, Fail, Blank, Report Table

, KBA , ad hoc report error , bad gateway , error 502 , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HCM Suite all versions