"data query returned 0 rows", but it returned 6.

[wfaulk]

I know this is going to seem like a FAQ, but I'm pretty sure it's not. Please read through it before you dismiss me.

I created an indexed data query to get filesystem usage data for NetApp Filers. The first one I created worked fine. But the next one tells me, when creating a graph that the "data query returned 0 rows". However, when I run the query in debug mode, it seems fine:

Code: Select all

+ Running data query [12].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/auto/site/rtp-local/cacti-0.8.7b/resource/snmp_queries/netapp_disk.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.4.1.789.1.5.4.1.1'
+ Located input field 'fsIndex' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.789.1.5.4.1.1'
+ Found item [fsIndex='1'] index: 1 [from value]
+ Found item [fsIndex='2'] index: 2 [from value]
+ Found item [fsIndex='3'] index: 3 [from value]
+ Found item [fsIndex='4'] index: 4 [from value]
+ Found item [fsIndex='5'] index: 5 [from value]
+ Found item [fsIndex='6'] index: 6 [from value]
+ Located input field 'fsPath' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.789.1.5.4.1.2'
+ Found item [fsPath='/vol/vol1/'] index: 1 [from value]
+ Found item [fsPath='/vol/vol1/.snapshot'] index: 2 [from value]
+ Found item [fsPath='/vol/vol2/'] index: 3 [from value]
+ Found item [fsPath='/vol/vol2/.snapshot'] index: 4 [from value]
+ Found item [fsPath='/vol/vol0/'] index: 5 [from value]
+ Found item [fsPath='/vol/vol0/.snapshot'] index: 6 [from value]
+ Found data query XML file at '/auto/site/rtp-local/cacti-0.8.7b/resource/snmp_queries/netapp_disk.xml'
+ Found data query XML file at '/auto/site/rtp-local/cacti-0.8.7b/resource/snmp_queries/netapp_disk.xml'
+ Found data query XML file at '/auto/site/rtp-local/cacti-0.8.7b/resource/snmp_queries/netapp_disk.xml'

This filer is running a different firmware version, which I'm sure is at the root of the difference, but I can't figure out where Cacti is getting confused.

The device has other data sources that are getting collected and working fine, including an interface graph, which is also an indexed SNMP request. I am using SNMPv1 on both hosts (because they don't support v2 at all), so it's not an snmpwalk vs. snmpbulkwalk problem.

There's nothing in the log file that indicates any sort of error.

Where else can I look to figure this out?

[Robstar]

I have the same issue for SNMP - Mounted Partitions pointed at a windows box. We have dozens of other boxes that work.

When I go to create graphs, none are available, but if I run the query manually 11 items are available, ARGH.

[gandalf]

Cacti is afraid of some "strange" characters in 087b. 087c should cure this
Reinhard