Please help!! Keep showing NaN in the rrd file

[michaellei]

Hi all,

Recently I make a data query for iDrac power status as attached "idrac_psupply.xml".

idrac_psupply.xml

(901 Bytes) Downloaded 92 times

And I make a data template and graph template for this data query but there is no output on the graph

cacti_snapshot1.PNG (20.95 KiB) Viewed 1226 times

The title of the chart "psName" is correctly read and the xml file parsed well as following.

cacti_snapshot2.PNG (22.81 KiB) Viewed 1226 times

However, the "psVoltage" (output direction) does not shown on the chart and when I check the rrd file in linux using rrdtool, it lists below:

cacti_snapshot3.PNG (44.18 KiB) Viewed 1226 times

I search the forum and find that the problem may be contributed by permission problem and I changed the log and rrd directory to 777 but the problem still existed...very frustrated after trying for several weeks hope someone can offer his help

[thuck]

Your graph has a value it is 0.
Can you do snmpwalk and copy here?
Can you show your data template and data query?
Can you double check in the data template and in the graph template which is the value on the max value?

[michaellei]

Attached the completed log of the rrdtool output, there is one line in between have value of zero.

cacti_log_1635.txt

(4.92 KiB) Downloaded 85 times

snmpwalk voltage oid
SNMPv2-SMI::enterprises.674.10892.5.4.600.12.1.9.1.1 = INTEGER: 264
SNMPv2-SMI::enterprises.674.10892.5.4.600.12.1.9.1.2 = INTEGER: 264

The data template screencap, initially it is 0 for the max value, I changed it to "1.0000000000e+02" but still not working

cacti_snapshot4.PNG (94.16 KiB) Viewed 1214 times

The data query screencap

cacti_snapshot5.PNG (39.39 KiB) Viewed 1214 times

The graph template screencap

cacti_snapshot6.PNG (99.63 KiB) Viewed 1214 times

[thuck]

In the data template set the Maximum to 0.
In your graph template you have the Upper Limit set to 100, change it to 0 (no limit), in your snmpwalk you have values as 262 so the values will not be plotted.
If this doesn't solve your problem, could you change the cacti log to debug and check if the values are being returned correctly by the poller?
Also which version of cacti are you using?

[michaellei]

Hi,

I tried changing the data template and graph template upper limit but still cannot solve the problem.

And I set the "Poller Specific Logging" - Poller Logging Level to Debug and then look at the log
04/21/2014 09:51:21 PM - SPINE: Poller[0] Host[63] TH[1] RECACHE: Processing 2 items in the auto reindex cache for '10.89.xx.xx'
04/21/2014 09:51:21 PM - SPINE: Poller[0] Host[63] TH[1] Recache DataQuery[1] OID: .1.3.6.1.2.1.1.3.0, output: 652202467
04/21/2014 09:51:21 PM - SPINE: Poller[0] Host[63] TH[1] Recache DataQuery[28] OID: .1.3.6.1.2.1.1.3.0, output: 652202467
04/21/2014 09:51:21 PM - SPINE: Poller[0] Host[63] TH[1] NOTE: There are '14' Polling Items for this Host
04/21/2014 09:51:22 PM - SPINE: Poller[0] Host[63] TH[1] DS[1412] SNMP: v2: 10.89.XX.XX, dsname: globalsys_status, oid: .1.3.6.1.4.1.674.10892.5.2.1.0, value: 3
04/21/2014 09:51:22 PM - SPINE: Poller[0] Host[63] TH[1] DS[1472] SNMP: v2: 10.89.XX.XX, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.2, value: 49770756
04/21/2014 09:51:22 PM - SPINE: Poller[0] Host[63] TH[1] DS[1472] SNMP: v2: 10.89.XX.XX, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.2, value: 152681957
04/21/2014 09:51:22 PM - SPINE: Poller[0] Host[63] TH[1] DS[1473] SNMP: v2: 10.89.XX.XX, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.3, value: 0
04/21/2014 09:51:22 PM - SPINE: Poller[0] Host[63] TH[1] DS[1473] SNMP: v2: 10.89.XX.XX, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.3, value: 1366613742
04/21/2014 09:51:22 PM - SPINE: Poller[0] Host[63] TH[1] DS[1474] SNMP: v2: 10.89.XX.XX, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.10, value: 49770756
04/21/2014 09:51:22 PM - SPINE: Poller[0] Host[63] TH[1] DS[1474] SNMP: v2: 10.89.XX.XX, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.10, value: 152681957
04/21/2014 09:51:22 PM - SPINE: Poller[0] Host[63] TH[1] DS[1471] SNMP: v2: 10.89.XX.XX, dsname: pege_amb_temp, oid: .1.3.6.1.4.1.674.10892.5.4.700.20.1.6.1.2, value: 350
04/21/2014 09:51:22 PM - SPINE: Poller[0] Host[63] TH[1] DS[1486] SNMP: v2: 10.89.XX.XX, dsname: dell_power, oid: .1.3.6.1.4.1.674.10892.5.4.600.30.1.6.1.2, value: 98
04/21/2014 09:51:22 PM - SPINE: Poller[0] Host[63] TH[1] DS[1487] SNMP: v2: 10.89.XX.XX, dsname: dell_power, oid: .1.3.6.1.4.1.674.10892.5.4.600.30.1.6.1.2, value: 98
04/21/2014 09:51:22 PM - SPINE: Poller[0] Host[63] TH[1] DS[1602] SNMP: v2: 10.89.XX.XX, dsname: psVoltage, oid: .1.3.6.1.4.1.674.10892.5.4.600.12.1.9.1, value: U
04/21/2014 09:51:22 PM - SPINE: Poller[0] Host[63] TH[1] DS[1603] SNMP: v2: 10.89.XX.XX, dsname: psVoltage, oid: .1.3.6.1.4.1.674.10892.5.4.600.12.1.9.2, value: U
04/21/2014 09:51:22 PM - SPINE: Poller[0] Host[63] TH[1] DS[1635] SNMP: v2: 10.89.XX.XX, dsname: Power_supply_table, oid: .1.3.6.1.4.1.674.10892.5.4.600.12.1.9.1, value: U
04/21/2014 09:51:22 PM - SPINE: Poller[0] Host[63] TH[1] DS[1636] SNMP: v2: 10.89.XX.XX, dsname: Power_supply_table, oid: .1.3.6.1.4.1.674.10892.5.4.600.12.1.9.2, value: U

The value for the corresponding data source is showing "U"

My cacti version is "Version 0.8.7i"

Thanks a lot!

[thuck]

Did you recreate the graph after changing the data template? If not please recreate the graph.
And let the data template with Max == 0; the graph template Upper Limit == 0.
U means that cacti is not understanding the data that came from the server, that' s why you have NaN, the strange part is that you have the correct snmpwalk.
Also it would be good to update cacti for the last version, probably not related with your problem, but there is a lot fixes in the last releases.

[michaellei]

problem still there after recreate the graphs.

[thuck]

Can you change the Upper Limit and the Max to 1000000, and recreate the graph?
Also check the cacti.log again to see what is going on.

[michaellei]

Still return U for the corresponding oid, should it be the problem of my data query xml file?

04/22/2014 08:00:02 PM - SPINE: Poller[0] Host[63] TH[1] DS[1412] SNMP: v2: 10.89.4.27, dsname: globalsys_status, oid: .1.3.6.1.4.1.674.10892.5.2.1.0, value: 3
04/22/2014 08:00:02 PM - SPINE: Poller[0] Host[63] TH[1] DS[1472] SNMP: v2: 10.89.4.27, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.2, value: 50220859
04/22/2014 08:00:02 PM - SPINE: Poller[0] Host[63] TH[1] DS[1472] SNMP: v2: 10.89.4.27, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.2, value: 152975031
04/22/2014 08:00:02 PM - SPINE: Poller[0] Host[63] TH[1] DS[1473] SNMP: v2: 10.89.4.27, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.3, value: 0
04/22/2014 08:00:02 PM - SPINE: Poller[0] Host[63] TH[1] DS[1473] SNMP: v2: 10.89.4.27, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.3, value: 1372651542
04/22/2014 08:00:02 PM - SPINE: Poller[0] Host[63] TH[1] DS[1474] SNMP: v2: 10.89.4.27, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.10, value: 50220859
04/22/2014 08:00:02 PM - SPINE: Poller[0] Host[63] TH[1] DS[1474] SNMP: v2: 10.89.4.27, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.10, value: 152975031
04/22/2014 08:00:02 PM - SPINE: Poller[0] Host[63] TH[1] DS[1471] SNMP: v2: 10.89.4.27, dsname: pege_amb_temp, oid: .1.3.6.1.4.1.674.10892.1.700.20.1.6.1.3, value: U
04/22/2014 08:00:02 PM - SPINE: Poller[0] Host[63] TH[1] DS[1684] SNMP: v2: 10.89.4.27, dsname: Power_supply_table, oid: .1.3.6.1.4.1.674.10892.5.4.600.12.1.9.1, value: U
04/22/2014 08:00:02 PM - SPINE: Poller[0] Host[63] TH[1] DS[1685] SNMP: v2: 10.89.4.27, dsname: Power_supply_table, oid: .1.3.6.1.4.1.674.10892.5.4.600.12.1.9.2, value: U
04/22/2014 08:00:02 PM - SPINE: Poller[0] Host[63] TH[1] DS[1651] SNMP: v2: 10.89.4.27, dsname: Dell_iDrac_RAID, oid: .1.3.6.1.4.1.674.10892.5.5.1.20.130.1.1.37.1, value: 3
04/22/2014 08:00:02 PM - SPINE: Poller[0] Host[63] TH[1] DS[1650] SNMP: v2: 10.89.4.27, dsname: iDrac_PowerConsump, oid: .1.3.6.1.4.1.674.10892.5.4.600.30.1.6.1.2, value: 98
04/22/2014 08:00:02 PM - SPINE: Poller[0] Host[63] TH[1] DS[1660] SNMP: v2: 10.89.4.27, dsname: iDrac_PowerConsump, oid: .1.3.6.1.4.1.674.10892.5.4.600.30.1.6.1.2, value: 98
04/22/2014 08:00:02 PM - SPINE: Poller[0] Host[63] TH[1] DS[1661] SNMP: v2: 10.89.4.27, dsname: Dell_iDrac_PS1, oid: .1.3.6.1.4.1.674.10892.5.4.600.12.1.6.1.1, value: 4950
04/22/2014 08:00:02 PM - SPINE: Poller[0] Host[63] TH[1] DS[1662] SNMP: v2: 10.89.4.27, dsname: Dell_iDrac_PS2, oid: .1.3.6.1.4.1.674.10892.5.4.600.12.1.6.1.2, value: 4950