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 Workforce Analytics
  • Advanced Reporting
  • Report Canvas - Advanced reporting query
  • SAP SuccessFactors HCM Suite

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.

Without Report Center 

  1. Go to Home > Analytics > Analytics;
  2. Go to Advanced Peporting;
  3. Drag and Drop any table to the objects tab
  4. 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