SAP Knowledge Base Article - Public

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

Symptom

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

error.png Time out error1.jpg

Note: Running the report offline fetches expected results

Environment

  • SuccessFactors HCM Core
  • Ad Hoc Report
  • Reporting and Analytics

Reproducing the Issue

  1. Navigate to 'Ad Hoc 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 Ad Hoc 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 - Ad Hoc 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 Ad Hoc reports independent of the complexity or output size, please refer KBA 2219570 and Report an incident with the error and timestamp details.

Keywords

Error 502, Ad Hoc, Bad Gateway
Ad Hoc Run Online
Ad Hoc
Run
Online
Time Out
Bad
Gateway
Report
Fail
Blank
Report-Table , KBA , error 502 , ad hoc report error , bad gateway , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HCM Suite all versions