Null values in InterfaceTraffic_Detail

This article addresses Null values found in the InterfaceTraffic_Detail table:

The following error message is also found in SolarwindsDiagnostics.zip\Collector\Logs\Plugins\DataProcessor_SolarWinds.Interfaces.SNMP.log:

2016-04-16 20:03:33,125 [STP DatabaseProcessing Thread #56785] ERROR SolarWinds.Interfaces.Collector.DAL.InterfaceTrafficDAL - Bulk insert failed on PRIMARY_KEY check

2016-04-16 20:03:39,187 [STP DatabaseProcessing Thread #56785] ERROR SolarWinds.Collector.DBProcessing.DBProcessingWorkerWithAccess - Commit of  - SolarWinds.Interfaces.SNMP failed.
System.InvalidOperationException: There was an error generating the XML document. ---> System.ArgumentOutOfRangeException: Inbps

Parameter name: name

• 7 pollers with 15000 elements at 5 minutes polling
• Previously encountered issues saw gaps in data because the polled utilization is over 100% and such polls are skipped by default.
• Found the ValidateCounters key with a TRUE value. For errors found, the value should be set to FALSE.

1. Open C:\Program Files (x86)\SolarWinds\Orion\Interfaces\Solarwinds.Interfaces.Collector.dll.config in a text editor.
2. Change the value for  the ValidateCounters key to False:
   <add key="ValidateCounters" value="True" />
   to
   <add key="ValidateCounters" value="False" />
3. Restart services.
4. Repeat the steps on additional pollers.