SAP Knowledge Base Article - Public

2921818 - Error encountered invalid column name - Dashboards and Tiles

Symptom

A tile created in Tile Builder/Report Center is showing the error message "Error encountered in getting the data... Error encountered in executing the query. SAP DBTech JDBC: invalid column name"

Environment

SAP SuccessFactors HXM Suite

Cause

A custom field mapped to a Custom MDF object is being used in the Chart data or filter

Resolution

Since Custom MDF objects are not supported in Adhoc and Dashboards, the tile can throw this error message if a custom field from a standard portlet (e.g. Job Information) is mapped to a custom MDF and it is being used in the tile configuration. The solution is to remove this field from Chart Data, Filters and replace it by a regular field.

See Also

2518464 - Is it possible to report on Custom MDF Objects in Report Table reports / Dashboards / detailed reporting queries

Keywords

tile dashboard Error encountered in executing the query SAP DBTech JDBC invalid column name , KBA , LOD-SF-ANA-DSH , YouCalc Dashboards and Tiles (Dashboards 2.0) , Problem

Product

SAP SuccessFactors HXM Core 1911