SAP Knowledge Base Article - Public

2604279 - Error getting query preview on Advanced Reporting

Symptom

  • The user receives "Error getting query preview" trying to edit an existing query in Advanced Reporting
  • When creating a new query no information is fetching. The query is showing the error message "Error getting query preview"

Environment

  • SAP SuccessFactors HXM Suite
  • SAP SuccessFactors Workforce Analytics
  • Report Canvas - Advanced reporting query

Reproducing the Issue

With Report Center 

  1. Go to Home > Reporting;
  2. Create a new Canvas report
  3. Add a list report component
  4. Select the component and click on "Edit Query";
  5. Select Advanced Reporting
  6. Click New
  7. Drag and Drop any table to the objects tab
  8. Go to Results tab and see the error.

error.png

Cause

  • If the error is happening creating a new simple query in Advanced Reporting (e.g. with Global Job Information table), that means the Advanced Reporting tool is not working.
  • If the error is happening to one object, that could be an issue with the configuration of that specific table.

Resolution

Open a support ticket requesting a full metadata reload in Advanced Reporting in order to fix the issue.

Keywords

Advanced reporting - Error getting query preview , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors Workforce Analytics all versions