SAP Knowledge Base Article - Public

3123979 - 2H 2021 Release - Some Canvas reports with timestamp fields failing offline - Advanced Reporting

Symptom

In 2H 2021 Release, some Advanced Reports (Canvas) that have timestamp fields (e.g. Created Date, Last Modified Date) as the first column of the query are failing when executed offline with error message "Error rendering the list report"

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Go to Reporting
  2. Run the affected Canvas (Advanced Reporting) report
  3. Online run works fine
  4. Export the report offline
  5. Download the report
  6. "Error rendering the list report" is displayed in the output file

Resolution

Engineering team is working on the resolution of the issue.

Workaround:

  1. Edit the query of the report
  2. Go to Columns tab
  3. Notice that there is a timestamp field (e.g. Created Date) as the first column on the list
  4. Move the column away from the first position (e.g. move it to the second position)



  5. Save the query
  6. The report should work offline as well

Note: The workaround is not going to change the order of the column in the output, because this is also set at Component formatting.

Keywords

In 2H 2021 Release KI2111 Advanced Reports canvas that have timestamp fields date as the first column of the query are failing when executed offline "Error rendering the list report" , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Known Error

Product

SAP SuccessFactors HXM Suite all versions

Attachments

Pasted image.png