2259963 - 'Error Rendering List report Component' due to time out Explained - Report Canvas (ORD)

• When attempting to edit or run a 'Live Data' report in ORD, it loads for some time and fails with a Rendering error.
• This occurs in both List reports and Pivot Queries.  
• The following logs are captured in the Analytics server: ExceptionStatus: Timeout, Exception: The operation has timed out, RequestContent: . ---> System.Net.WebException: The operation has timed out
• In Edit query mode for the affected component, the table displays data preview results. 

• SAP SuccessFactors HCM Suite
  • Analytics & Reporting  (Ad Hoc, YouCalc, ORD)
    • Online Report Designer

• Login to the instance
• Navigate to Online Report Designer
• Attempt to edit or run a 'Live Data' report in ORD

There is a time-out limit set, for running an online report in ORD:

• This is implemented because the same servers are used for both transactional and reporting purposes.
• If a query runs for more than this time, it can cause issues with other jobs on the server. 

The report's run time depends on multiple parameters. Examples:

• Number of columns and rows (amount of data)
• Cell level permissions
• User’s target population
• Server load

The Edit query view only queries the top 100 rows and will not time out due to sheer volume of records (though query complexity may still cause timeouts) but the Run Report Online attempts to render the entire query. If the query is too large, it will not complete.  

• Run any report that takes more than 5 minutes to load using the Report Distributor to run offline.
• Add the report to a bundle in Report Distributor and select Run Offline to view the complete results.  
• Download the export from Report Distributor Downloads to avoid timeout issues, timeouts will not be a concern.  

ARB timeout, Online Report Designer, Canvas timeout, Canvas error, large queries, query complexity, server load, data volume, offline report, Report Distributor, time limit, rendering error, query view, data preview, transactional server, reporting server , KBA , ss_anonymizedkba , LOD-SF-ANA-ORD , Online Report Designer , Problem