SAP Knowledge Base Article - Preview

2953261 - Error Rendering List Component for a Specific user due to "SQL statement is too long" - Report-Canvas / Advanced Reporting

Symptom

  • A user which has all the required permissions to run a Canvas - Advanced Reporting query gets an "Error rendering list report component" message.
  • The report may fail when previewed or executed Online.
  • The report may fail when executed or downloaded Offline.
  • The report may run successfully Online but fail Offline, or vice versa.
  • The same report runs successfully for some users (for example, Admin users) but fails for specific users.
  • In the backend, support can observe the following error log: "SQL statement is too long"


Read more...

Environment

SAP SuccessFactors HCM Suite

Product

SAP SuccessFactors HCM Suite all versions ; SAP SuccessFactors Platform all versions

Keywords

SQL statement is too long, Error rendering component, report fails for one user, complex report, permissions, Role‑Based Permissions, RBP, target population, advanced reporting, Canvas report, Online Report Designer, Error rendering list report component, report fails offline, report fails online , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.