2585761 - Dashboard Tile drilldown error: An error occurred while calculating data, please try again later or contact your administrator

SAP Knowledge Base Article - Public

2585761 - Dashboard Tile drilldown error: An error occurred while calculating data, please try again later or contact your administrator

Symptom

An error is thrown when selecting drill down in the dashboard tile.

Tile error.png

Environment

  • SAP SuccessFactors HCM Core
  • Dashboards

Reproducing the Issue

  1. Login to Home Page
  2. Select Tile then Click to drill down on any of the sections
  3. No data – Error:
    An error occurred while calculating data, please try again later or contact your administrator.
    txt
    Error encountered in getting the data.com.successfactors.analytics.queryengine.exceptions.QueryEngineException: Error encountered in executing the query Error encountered in executing the query.ORA-00904: "G"."COLUMN3": invalid identifier
    id 17
    5. From Splunk:
    12:53:04,474 ERROR [CalculationManager] [87.198.171.157] [1017547] [WkTbIAp2GGsAAD2wRx0AAAB5] [Gist,Gist Ltd,dc5prd_STOCKPM900312.,dbPool8,SFADMIN,SFADMIN,en_GB] Error in calculating [17] AdHoc List Report with function AdHocReportsDefinition
    com.successfactors.analytics.common.AnalyticsException: Error encountered in getting the data.com.successfactors.analytics.queryengine.exceptions.QueryEngineException: Error encountered in executing the query Error encountered in executing the query.ORA-00904: "G"."COLUMN3": invalid identifier

Cause

System defect.

Resolution

The issue will be fixed with the 1802 release.

The issue will happen if drill down has columns such as first name, last name (anything that shows quickcard).
The issue is not specific to a particular tile/dashboard.
So one possible workaround is to remove such columns from drill down (temporarily) or to turn off the cell level for group by reports switch from provisioning.

Keywords

KBA , LOD-SF-ANA-DSH , Dashboard and YouCalc , Problem

Product

SAP SuccessFactors HCM Core 1711