PA Indicators for survey responses

[CezaryBasta]

Hi all,

I have a problem with performance analytics. I have to create an indicator for average survey score.

Really simple scenario:

1. Indicator source on Metric Result (asmt_metric_result),

2. 2 automated indicators based on this source, one for sum of Actual Value field, the other one for count of records (no breakdowns or scripts)

3. 1 formula indicator (sum / count) (no breakdown or script)

However when I run the scheduled job that's supposed to collect data for indicators, I get java.lang.IllegalStateException: Sparse storage format has one field, sys_id. I tried googling around, but neither HI kb article nor any community thread similar to my problem could help.

I'll be grateful for any help.

[pieter_goris]

Hi Cezary,

a quick test with an indicator on the Actual Value column of the asmt_metric_result table works fine for me.

Do you get the error when collecting for the count or the sum indicator, or both? What release are you on?

Maybe you better log a ticket in Hi for this one.

Cheers, Pieter

[CezaryBasta]

Hie Pieter,

Thanks for the response. I get this error for both indicators, both indicators set to count and a single count - whenever there are data to be collected. It happens on Istanbul Patch 6.

[vinothkumar]

Hi Cezay,

This error may occur, when the field you are referring   in the PA configuration is not available in your instance. Can you double check it?

[CezaryBasta]

Which field should I look for? Actual Value is available - I can see it in an aggregate indicator when I define sum on that field.