SAP Knowledge Base Article - Public

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 same report works for an Admin user and other users with similar permissions but different roles.
  • This happens with both Online and Offline Export and can happen intermittently or not
  • In the backend, support can observe the following error log: "SQL statement is too long"

Environment

SAP SuccessFactors HXM Suite

Cause

  • Complexity of report query (number of objects, fields, calculated columns, filters, etc)
  • Complexity of user's RBP roles/Target Population

Resolution

"SQL statement is too long" indicates that when running as this user, the complexity of the current report query combined with the user's RBP target population causes reporting to create a statement backend that exceeds database limitations.  There are 2 ways to resolve this:

  1. Simplify the report query - remove objects that are not in use, exclude fields that can be excluded, simplify filters, remove calculated column etc.  This optimizes the report as well.
  2. Simplify RBP permissions - e.g. if user has 2-3 roles granting a certain Report or Employee Central Effective Dated Entity Field that has different target populations, please consider reducing the number of roles.


Note:

Option #1 generally works and is the easiest to apply. However, the support team cannot determine what should be changed/simplified in the report. Therefore, the test should be done on customer side.


Option #2 will involve a lot of re-evaluation of permission roles, but it is necessary to reduce complexity.

PS: The RBP configuration/evaluation is out of the support scope. Please contact your partner or the professional services if you need help to reduce its complexity.

Keywords

SQL statement is too long, Error rendering component, report fails for one user, complex report, permissions, advanced reporting , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors HCM Suite all versions