Cancel changes

Description

Performance Analytic jobs are failing when using an Indicator Condition based on a field with the type Translated Text. The error displayed is "Error collecting for 20170606 java.lang.IllegalStateException: Sparse storage format has one field, sys_id".

Steps to Reproduce

Note – This example is based on the [asmt_metric_definition.display] field which is the type of Translated Text.

Ensure that the Performance Analytics - Premium plugin [com.snc.pa.premium] is installed and active.

Workaround

Add the Condition based on a field with the type Translated Text at the Indicator Source level instead of at the Indicator level.

Note that you need only to re-create the Additional Conditions from the indicator into the Indicator Source. You do not need to reference each individual question, for every translated text field, in the Indicator Source conditions.