Issue
The following error can appear in the Performance Analytics job logs:
Sparse storage format has one field, sys_id
Example:
Error collecting for 20180508 java.lang.IllegalStateException: Sparse storage format has one field, sys_id
at com.glide.db.meta.SparseStorage.getValue(SparseStorage.java:70)
at com.snc.pa.dc.Row.getValue(Row.java:164)
at com.snc.pa.dc.DataCollector.map(DataCollector.java:565)
at com.snc.pa.dc.DataCollector.collect(DataCollector.java:355)
at com.glide.db.meta.SparseStorage.getValue(SparseStorage.java:70)
at com.snc.pa.dc.Row.getValue(Row.java:164)
at com.snc.pa.dc.DataCollector.map(DataCollector.java:565)
at com.snc.pa.dc.DataCollector.collect(DataCollector.java:355)
Release
Any release
Cause
This error can be caused by:
- the fact table of the breakdown assigned to an indicator being different from the fact table from the indicator
- the script used in an indicator referring to a table column that does not exist
- an indicator using an aggregate combined with a column that does not exist
Resolution
The instance localhost log will just show a stack dump, but nothing else, there is no trace of what table and field is attempted to be read. The following steps may be of help before creating an incident for SN support:
- View the job log in the instance localhost
- Search for the error message "java.lang.IllegalStateException: Sparse storage format has one field, sys_id"
- Just after the error message, you should see a line with the field and table that can not be found "Syntax Error or Access Rule Violation detected by database (Unknown column '<table>.<field>' in 'field list')"
- Identify the first preceding row where the message contains "Processing Indicator Source ..."
- Use the indicator source mentioned, to search for associated automated indicators
- For each indicator verify the breakdowns and scripts used
