Questions about this article, topic, or product? Click here. 

System.IndexOutOfRangeException ODC error

  Product(s): APM Implementation and Performance Management
  Version(s): All
  Area: ODC

Problem

ODC log file reports the following error:

2021-09-17 22:21:27.4452Z - ERROR: Failed to read optional quality field (third column)  <SampleRank::nnnnnnn>. System.IndexOutOfRangeException: Index was outside the bounds of the array.

   at System.Data.Odbc.DbCache.AccessIndex(Int32 i)
   at System.Data.Odbc.OdbcDataReader.internalGetInt32(Int32 i)
   at System.Data.Odbc.OdbcDataReader.GetInt32(Int32 i)
   at Ivara.ServiceProvider.ODC.DB.OdcAgentForDb.GetValues(ODCTagInfo taginfo)
2021-09-17 22:21:27.4452Z - ERROR: Failed to read optional quality as string field (fourth column)  <SampleRank::nnnnnnnn>. System.IndexOutOfRangeException: Index was outside the bounds of the array.
   at System.Data.Odbc.DbCache.AccessIndex(Int32 i)
   at System.Data.Odbc.OdbcDataReader.internalGetString(Int32 i)
   at System.Data.Odbc.OdbcDataReader.GetString(Int32 i)
   at Ivara.ServiceProvider.ODC.DB.OdcAgentForDb.GetValues(ODCTagInfo taginfo)
2021-09-17 22:21:27.4452Z - DEBUG: OdcAgentForDB.GetValues() found a reading value: 0 timestamp: 2021-08-12 12:00:00 AM



Solution

The APM ODC DB plugin supports a query that returns certain values in a certain order.
We look for:
   value (numeric or string)
   timestamp (datetime)
   quality (integer)
   qualityAsString (string)
The last two are optional, although we do log an error if they are not present (we could make this more of an info log message).  This error is benign, and can be ignored in this case.  These shouldn't contribute to any instability.

Recommended
Related
Communities
Support and Services
Training and Learning
Social Media