SAP Knowledge Base Article - Public

3310147 - Boolean field used in aggregated Table Widget in Story returns Internal Error Message


Boolean field is used in aggregated Table Widget in Story returns Internal Error Message - {"Messages":[{"Type":2,"Number":42014,"Text":"Internal error occurred while processing.","DetailedError":"Caught exception : exception 70000264: invalid datatype: aggr::sum() cannot receive a Boolean type argument\n"}]} 

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


SAP SuccessFactors HXM Suite Core 2211

Reproducing the Issue

1. Create Story Report including Boolean Field in Data Source

2. Add Aggregated Table Widget in Story Designer and try add boolean field

3. Observe Internal Error Message in UI and detailer error in Network Logs


There is a known issue where custom boolean fields are added in the query and are coming as "measure" instead of "dimension".  This is a known limitation.



Create a calculated dimension using the field you require and included in aggregated table widget

Boolean fields use 0 to represent false and 1 to represent True.

Alternatively, Boolean fields show as dimensions when taken from related table, so include the fields from the related table rather than driving table in Story Reports note below example when Job Classification is taken as related table of Job Information.


Boolean, Story Report, Internal error, Aggregated, Table Widget, cannot receive a Boolean type argument , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , Problem


SAP SuccessFactors HXM Core 2211


Pasted image.png