SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

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

Cause

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.

Resolution

Workaround:

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.

Keywords

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

Product

SAP SuccessFactors HXM Core 2211

Attachments

Pasted image.png
Snag_605c26.png