Uploaded image for project: 'Observium'
  1. Observium
  2. OBS-3677

Convertation failed because of String Value

    XMLWordPrintable

Details

    Description

      Hi,

      (Observium Version: Observium CE 20.9.10731)

      we are using Ruckus ICX Switches type 7450, 7750 and 7850.

      I activated optical-monitoring feature in the switch to get values into observium. The output from switch e.g.:

      Port Temperature Voltage Tx Power Rx Power Tx Bias Current
      --------------------------------------------------------------+
      1/1/44 31.6679 C 3.2877 volts -007.8489 dBm -008.9962 dBm 15.792 mA
      Normal Normal Normal Normal Normal

      Via SNMP from obserium we get:

      CMD RUNTIME[0.0537s]
      STDOUT[
      snIfOpticalLaneMonitoringTemperature.44.1 = " 31.6679 C Normal"
      snIfOpticalLaneMonitoringTemperature.300.1 = " 30.6992 C Normal"
      snIfOpticalLaneMonitoringTxPower.44.1 = "-007.8489 dBm Normal"
      snIfOpticalLaneMonitoringTxPower.300.1 = "-007.8595 dBm Normal"
      snIfOpticalLaneMonitoringRxPower.44.1 = "-008.9962 dBm Normal"
      snIfOpticalLaneMonitoringRxPower.300.1 = "-005.3461 dBm Normal"
      snIfOpticalLaneMonitoringTxBiasCurrent.44.1 = " 15.792 mA Normal"
      snIfOpticalLaneMonitoringTxBiasCurrent.300.1 = " 15.980 mA Normal"
      snIfOpticalLaneMonitoringEntry.6.44.1 = "3.2877 volts Normal"
      snIfOpticalLaneMonitoringEntry.6.300.1 = "3.3011 volts Normal"
      ]

       

      if I understand it right, this values normally does have only INT values, right?

      How we can fix this issue to get the values in the right format into observium?

       

       

      SQL[SELECT `mib` FROM `devices_mibs` WHERE `device_id` = '411' AND `use` = 'mib' AND `disabled` = '1']
      SQL RUNTIME[0.00006819s]
      o FOUNDRY-SN-SWITCH-GROUP-MIB
      CMD[/usr/bin/snmpbulkwalk -Cr'60' -t '3' -r '3' -v2c -c *** -Pud -OQUs -m FOUNDRY-SN-SWITCH-GROUP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/brocade 'udp':'100.127.255.2':'161' snIfOpticalMonitoringTxBiasCurrent]

      CMD EXITCODE[0]
      CMD RUNTIME[0.0254s]
      STDOUT[
      snIfOpticalMonitoringTxBiasCurrent = No Such Object available on this agent at this OID
      ]
      SNMP STATUS[FALSE]
      SNMP ERROR1000 - Failed response

      CMD[/usr/bin/snmpbulkwalk -Cr'60' -t '3' -r '3' -v2c -c *** -Pud -OQUs -m FOUNDRY-SN-SWITCH-GROUP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/brocade 'udp':'100.127.255.2':'161' snIfOpticalMonitoringTxPower]

      CMD EXITCODE[0]
      CMD RUNTIME[0.0318s]
      STDOUT[
      snIfOpticalMonitoringTxPower = No Such Object available on this agent at this OID
      ]
      SNMP STATUS[FALSE]
      SNMP ERROR1000 - Failed response

      CMD[/usr/bin/snmpbulkwalk -Cr'60' -t '3' -r '3' -v2c -c *** -Pud -OQUs -m FOUNDRY-SN-SWITCH-GROUP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/brocade 'udp':'100.127.255.2':'161' snIfOpticalMonitoringRxPower]

      CMD EXITCODE[0]
      CMD RUNTIME[0.0344s]
      STDOUT[
      snIfOpticalMonitoringRxPower = No Such Object available on this agent at this OID
      ]
      SNMP STATUS[FALSE]
      SNMP ERROR1000 - Failed response

      CMD[/usr/bin/snmpbulkwalk -Cr'60' -t '3' -r '3' -v2c -c *** -Pud -OQUs -m FOUNDRY-SN-SWITCH-GROUP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/brocade 'udp':'100.127.255.2':'161' snIfOpticalMonitoringTemperature]

      CMD EXITCODE[0]
      CMD RUNTIME[0.0326s]
      STDOUT[
      snIfOpticalMonitoringTemperature = No Such Object available on this agent at this OID
      ]
      SNMP STATUS[FALSE]
      SNMP ERROR1000 - Failed response

      CMD[/usr/bin/snmpbulkwalk -Cr'60' -t '3' -r '3' -v2c -c *** -Pud -OQUs -m FOUNDRY-SN-SWITCH-GROUP-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/brocade 'udp':'100.127.255.2':'161' snIfOpticalLaneMonitoringTable]

      CMD EXITCODE[0]
      CMD RUNTIME[0.0537s]
      STDOUT[
      snIfOpticalLaneMonitoringTemperature.44.1 = " 31.6679 C Normal"
      snIfOpticalLaneMonitoringTemperature.300.1 = " 30.6992 C Normal"
      snIfOpticalLaneMonitoringTxPower.44.1 = "-007.8489 dBm Normal"
      snIfOpticalLaneMonitoringTxPower.300.1 = "-007.8595 dBm Normal"
      snIfOpticalLaneMonitoringRxPower.44.1 = "-008.9962 dBm Normal"
      snIfOpticalLaneMonitoringRxPower.300.1 = "-005.3461 dBm Normal"
      snIfOpticalLaneMonitoringTxBiasCurrent.44.1 = " 15.792 mA Normal"
      snIfOpticalLaneMonitoringTxBiasCurrent.300.1 = " 15.980 mA Normal"
      snIfOpticalLaneMonitoringEntry.6.44.1 = "3.2877 volts Normal"
      snIfOpticalLaneMonitoringEntry.6.300.1 = "3.3011 volts Normal"
      ]
      SNMP STATUS[TRUE]

      SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '411' AND `ifIndex` = '44' AND `deleted` = '0' LIMIT 1]
      SQL RUNTIME[0.00055408s]

      SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '596811']
      SQL RUNTIME[0.00323796s]

      SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '596811']
      SQL RUNTIME[0.00198388s]

      SQL[SELECT * FROM `devices` WHERE `device_id` = '411']
      SQL RUNTIME[0.00287604s]

      SQL[SELECT * FROM `device_graphs` WHERE `device_id` = '411']
      SQL RUNTIME[0.00016904s]
      Discover sensor: [class: temperature, device: 100.127.255.2, oid: .1.3.6.1.4.1.1991.1.1.3.3.10.1.2.44.1, index: 44.1, type: FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTemperature, descr: 10GigabitEthernet1/1/44 Lane 1, scale: 1, limits: (, , , ), CURRENT: 31.6679, ,

      SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'temperature' AND `device_id` = '411' AND `sensor_type` = 'FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTemperature' AND `sensor_index` = '44.1')]
      SQL RUNTIME[0.00191212s]

      SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '411' AND `sensor_type` = 'FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTemperature' AND `sensor_index` = '44.1']
      SQL RUNTIME[0.00207305s]

      SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '33624' AND `attrib_type` = 'sensor_addition']
      SQL RUNTIME[0.00016594s]
      .DOM power sensor forced to dBm sensor.
      Converted DBM value: -7.8489E-6 W -> FALSE
      Discover sensor: [class: dbm, device: 100.127.255.2, oid: .1.3.6.1.4.1.1991.1.1.3.3.10.1.3.44.1, index: 44.1, type: FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTxPower, descr: 10GigabitEthernet1/1/44 Lane 1 TX Power, scale: 1.0E-6, limits: (, , , ), CURRENT: , ,

      SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'dbm' AND `device_id` = '411' AND `sensor_type` = 'FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTxPower' AND `sensor_index` = '44.1')]
      SQL RUNTIME[0.00077009s]

      SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'dbm' AND `device_id` = '411' AND `sensor_type` = 'FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTxPower' AND `sensor_index` = '44.1']
      SQL RUNTIME[0.00129390s]

      SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '33628' AND `attrib_type` = 'sensor_addition']
      SQL RUNTIME[0.00011206s]
      .DOM power sensor forced to dBm sensor.
      Converted DBM value: -8.9962E-6 W -> FALSE
      Discover sensor: [class: dbm, device: 100.127.255.2, oid: .1.3.6.1.4.1.1991.1.1.3.3.10.1.4.44.1, index: 44.1, type: FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringRxPower, descr: 10GigabitEthernet1/1/44 Lane 1 RX Power, scale: 1.0E-6, limits: (, , , ), CURRENT: , ,

      SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'dbm' AND `device_id` = '411' AND `sensor_type` = 'FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringRxPower' AND `sensor_index` = '44.1')]
      SQL RUNTIME[0.00051188s]

      SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'dbm' AND `device_id` = '411' AND `sensor_type` = 'FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringRxPower' AND `sensor_index` = '44.1']
      SQL RUNTIME[0.00060105s]

      SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '33629' AND `attrib_type` = 'sensor_addition']
      SQL RUNTIME[0.00012088s]
      .Discover sensor: [class: current, device: 100.127.255.2, oid: .1.3.6.1.4.1.1991.1.1.3.3.10.1.5.44.1, index: 44.1, type: FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTxBiasCurrent, descr: 10GigabitEthernet1/1/44 Lane 1 TX Bias Current, scale: 0.001, limits: (, , , ), CURRENT: 0.015792, ,

      SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '411' AND `sensor_type` = 'FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTxBiasCurrent' AND `sensor_index` = '44.1')]
      SQL RUNTIME[0.00069189s]

      SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '411' AND `sensor_type` = 'FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTxBiasCurrent' AND `sensor_index` = '44.1']
      SQL RUNTIME[0.00085711s]

      SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '33627' AND `attrib_type` = 'sensor_addition']
      SQL RUNTIME[0.00010991s]
      .
      SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '411' AND `ifIndex` = '300' AND `deleted` = '0' LIMIT 1]
      SQL RUNTIME[0.00034094s]

      SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '596922']
      SQL RUNTIME[0.00108600s]

      SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '596922']
      SQL RUNTIME[0.00011492s]
      Discover sensor: [class: temperature, device: 100.127.255.2, oid: .1.3.6.1.4.1.1991.1.1.3.3.10.1.2.300.1, index: 300.1, type: FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTemperature, descr: 10GigabitEthernet2/1/44 Lane 1, scale: 1, limits: (, , , ), CURRENT: 30.6992, ,

      SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'temperature' AND `device_id` = '411' AND `sensor_type` = 'FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTemperature' AND `sensor_index` = '300.1')]
      SQL RUNTIME[0.00070882s]

      SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '411' AND `sensor_type` = 'FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTemperature' AND `sensor_index` = '300.1']
      SQL RUNTIME[0.00077200s]

      SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '33582' AND `attrib_type` = 'sensor_addition']
      SQL RUNTIME[0.00010896s]
      .DOM power sensor forced to dBm sensor.
      Converted DBM value: -7.8595E-6 W -> FALSE
      Discover sensor: [class: dbm, device: 100.127.255.2, oid: .1.3.6.1.4.1.1991.1.1.3.3.10.1.3.300.1, index: 300.1, type: FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTxPower, descr: 10GigabitEthernet2/1/44 Lane 1 TX Power, scale: 1.0E-6, limits: (, , , ), CURRENT: , ,

      SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'dbm' AND `device_id` = '411' AND `sensor_type` = 'FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTxPower' AND `sensor_index` = '300.1')]
      SQL RUNTIME[0.00045300s]

      SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'dbm' AND `device_id` = '411' AND `sensor_type` = 'FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTxPower' AND `sensor_index` = '300.1']
      SQL RUNTIME[0.00062799s]

      SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '33630' AND `attrib_type` = 'sensor_addition']
      SQL RUNTIME[0.00009894s]
      .DOM power sensor forced to dBm sensor.
      Converted DBM value: -5.3461E-6 W -> FALSE
      Discover sensor: [class: dbm, device: 100.127.255.2, oid: .1.3.6.1.4.1.1991.1.1.3.3.10.1.4.300.1, index: 300.1, type: FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringRxPower, descr: 10GigabitEthernet2/1/44 Lane 1 RX Power, scale: 1.0E-6, limits: (, , , ), CURRENT: , ,

      SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'dbm' AND `device_id` = '411' AND `sensor_type` = 'FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringRxPower' AND `sensor_index` = '300.1')]
      SQL RUNTIME[0.00082088s]

      SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'dbm' AND `device_id` = '411' AND `sensor_type` = 'FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringRxPower' AND `sensor_index` = '300.1']
      SQL RUNTIME[0.00081897s]

      SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '33631' AND `attrib_type` = 'sensor_addition']
      SQL RUNTIME[0.00011182s]
      .Discover sensor: [class: current, device: 100.127.255.2, oid: .1.3.6.1.4.1.1991.1.1.3.3.10.1.5.300.1, index: 300.1, type: FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTxBiasCurrent, descr: 10GigabitEthernet2/1/44 Lane 1 TX Bias Current, scale: 0.001, limits: (, , , ), CURRENT: 0.01598, ,

      SQL[SELECT EXISTS (SELECT 1 FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'current' AND `device_id` = '411' AND `sensor_type` = 'FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTxBiasCurrent' AND `sensor_index` = '300.1')]
      SQL RUNTIME[0.00056100s]

      SQL[SELECT * FROM `sensors` WHERE `sensor_class` = 'current' AND `device_id` = '411' AND `sensor_type` = 'FOUNDRY-SN-SWITCH-GROUP-MIB-snIfOpticalLaneMonitoringTxBiasCurrent' AND `sensor_index` = '300.1']
      SQL RUNTIME[0.00054908s]

      SQL[SELECT `attrib_value` FROM `entity_attribs` WHERE `entity_type` = 'sensor' AND `entity_id` = '33585' AND `attrib_type` = 'sensor_addition']
      SQL RUNTIME[0.00009704s]
      .
      SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '411' AND `ifIndex` = '6' AND `deleted` = '0' LIMIT 1]
      SQL RUNTIME[0.00017905s]

      SQL[SELECT * FROM `ports` WHERE `ports`.`port_id` = '596773']
      SQL RUNTIME[0.00025487s]

      SQL[SELECT * FROM `entity_attribs` WHERE `entity_type` = 'port' AND `entity_id` = '596773']
      SQL RUNTIME[0.00011396s]
      Sensor skipped by not numeric value: '', '10GigabitEthernet1/1/6 Lane 44.1'
      DOM power sensor forced to dBm sensor.
      Sensor skipped by not numeric value: '', '10GigabitEthernet1/1/6 Lane 44.1 TX Power'
      DOM power sensor forced to dBm sensor.
      Sensor skipped by not numeric value: '', '10GigabitEthernet1/1/6 Lane 44.1 RX Power'
      Sensor skipped by not numeric value: '', '10GigabitEthernet1/1/6 Lane 44.1 TX Bias Current'
      Sensor skipped by not numeric value: '', '10GigabitEthernet1/1/6 Lane 300.1'
      DOM power sensor forced to dBm sensor.
      Sensor skipped by not numeric value: '', '10GigabitEthernet1/1/6 Lane 300.1 TX Power'
      DOM power sensor forced to dBm sensor.
      Sensor skipped by not numeric value: '', '10GigabitEthernet1/1/6 Lane 300.1 RX Power'
      Sensor skipped by not numeric value: '', '10GigabitEthernet1/1/6 Lane 300.1 TX Bias Current'

      Attachments

        Activity

          People

            landy Mike Stupalov
            twilms Torsten Wilms
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: