SNMP Index Query not creating graphs - Please help!

[mediastream]

I searched all over the forums and tried dozens of ways, but I cannot figure out why I cannot create graphs using my SNMP Index Query. The index is really a combination of of 2 OID's. What is interesting is that I tried this for another device that only outputs 2 rows and it works. For all my devices that are more than two rows, it does not work.

Below is what I am doing:

XML
<query>
<name>Get dpStatusSLMSummaryStatus Table Stats</name>
<description>Queries a host for a list of DataPower SLM Summary Stats</description>
<oid_index>.1.3.6.1.4.1.14685.3.1.121.1</oid_index>
<oid_index_parse>OID/REGEXP:^.{31}(.*)</oid_index_parse>
<index_title_format>|chosen_order_field|</index_title_format>
<index_order_type>alphabetic</index_order_type>
<fields>
<SLMPolicy>
<name>SLMPolicy</name>
<method>walk</method>
<source>value</source>
<direction>input</direction>
<oid>.1.3.6.1.4.1.14685.3.1.121.1.1</oid>
</SLMPolicy>
<SLMId>
<name>SLMId</name>
<method>walk</method>
<source>value</source>
<direction>input</direction>
<oid>.1.3.6.1.4.1.14685.3.1.121.1.2</oid>
</SLMId>
<Messages>
<name>Messages</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.14685.3.1.121.1.3</oid>
</Messages>
<Errors>
<name>Errors</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.14685.3.1.121.1.4</oid>
</Errors>
<Throttled>
<name>Throttled</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.14685.3.1.121.1.5</oid>
</Throttled>
<Average>
<name>Average</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.14685.3.1.121.1.6</oid>
</Average>
<Minimum>
<name>Minimum</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.14685.3.1.121.1.7</oid>
</Minimum>
<Maximum>
<name>Maximum</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.14685.3.1.121.1.8</oid>
</Maximum>
<TotalMessages>
<name>TotalMessages</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.14685.3.1.121.1.9</oid>
</TotalMessages>
<TotalErrors>
<name>TotalErrors</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.14685.3.1.121.1.10</oid>
</TotalErrors>
<TotalThrottled>
<name>TotalThrottled</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.14685.3.1.121.1.11</oid>
</TotalThrottled>
<TotalAverage>
<name>TotalAverage</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.14685.3.1.121.1.12</oid>
</TotalAverage>
<TotalMinimum>
<name>TotalMinimum</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.14685.3.1.121.1.13</oid>
</TotalMinimum>
<TotalMaximum>
<name>TotalMaximum</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.14685.3.1.121.1.14</oid>
</TotalMaximum>
</fields>
</query>

SNMP Walk
bash-2.05a$ snmpwalk -v1 -c public server1.company.com .1.3.6.1.4.1.14685.3.1.121.1
enterprises.14685.3.1.121.1.1.1.1 = "ArsAccount"
enterprises.14685.3.1.121.1.1.1.2 = "ArsAccount"
enterprises.14685.3.1.121.1.1.2.1 = "ArsAccountPublic"
enterprises.14685.3.1.121.1.1.2.2 = "ArsAccountPublic"
enterprises.14685.3.1.121.1.1.3.1 = "ArsSubscriber"
enterprises.14685.3.1.121.1.1.3.2 = "ArsSubscriber"
enterprises.14685.3.1.121.1.1.4.1 = "ArsSubscriptionManager"
enterprises.14685.3.1.121.1.1.4.2 = "ArsSubscriptionManager"
enterprises.14685.3.1.121.1.1.5.1 = "ArsUsageTracking"
enterprises.14685.3.1.121.1.1.5.2 = "ArsUsageTracking"
enterprises.14685.3.1.121.1.2.1.1 = Gauge32: 1
enterprises.14685.3.1.121.1.2.1.2 = Gauge32: 2
enterprises.14685.3.1.121.1.2.2.1 = Gauge32: 1
enterprises.14685.3.1.121.1.2.2.2 = Gauge32: 2
enterprises.14685.3.1.121.1.2.3.1 = Gauge32: 1
enterprises.14685.3.1.121.1.2.3.2 = Gauge32: 2
enterprises.14685.3.1.121.1.2.4.1 = Gauge32: 1
enterprises.14685.3.1.121.1.2.4.2 = Gauge32: 2
enterprises.14685.3.1.121.1.2.5.1 = Gauge32: 1
enterprises.14685.3.1.121.1.2.5.2 = Gauge32: 2
enterprises.14685.3.1.121.1.3.1.1 = Counter32: 0
enterprises.14685.3.1.121.1.3.1.2 = Counter32: 0
enterprises.14685.3.1.121.1.3.2.1 = Counter32: 0
enterprises.14685.3.1.121.1.3.2.2 = Counter32: 0
enterprises.14685.3.1.121.1.3.3.1 = Counter32: 0
enterprises.14685.3.1.121.1.3.3.2 = Counter32: 0
enterprises.14685.3.1.121.1.3.4.1 = Counter32: 0
enterprises.14685.3.1.121.1.3.4.2 = Counter32: 0
enterprises.14685.3.1.121.1.3.5.1 = Counter32: 0
enterprises.14685.3.1.121.1.3.5.2 = Counter32: 0
enterprises.14685.3.1.121.1.4.1.1 = Counter32: 0
enterprises.14685.3.1.121.1.4.1.2 = Counter32: 0
enterprises.14685.3.1.121.1.4.2.1 = Counter32: 0
enterprises.14685.3.1.121.1.4.2.2 = Counter32: 0
enterprises.14685.3.1.121.1.4.3.1 = Counter32: 0
enterprises.14685.3.1.121.1.4.3.2 = Counter32: 0
enterprises.14685.3.1.121.1.4.4.1 = Counter32: 0
enterprises.14685.3.1.121.1.4.4.2 = Counter32: 0
enterprises.14685.3.1.121.1.4.5.1 = Counter32: 0
enterprises.14685.3.1.121.1.4.5.2 = Counter32: 0
enterprises.14685.3.1.121.1.5.1.1 = Counter32: 0
enterprises.14685.3.1.121.1.5.1.2 = Counter32: 0
enterprises.14685.3.1.121.1.5.2.1 = Counter32: 0
enterprises.14685.3.1.121.1.5.2.2 = Counter32: 0
enterprises.14685.3.1.121.1.5.3.1 = Counter32: 0
enterprises.14685.3.1.121.1.5.3.2 = Counter32: 0
enterprises.14685.3.1.121.1.5.4.1 = Counter32: 0
enterprises.14685.3.1.121.1.5.4.2 = Counter32: 0
enterprises.14685.3.1.121.1.5.5.1 = Counter32: 0
enterprises.14685.3.1.121.1.5.5.2 = Counter32: 0
enterprises.14685.3.1.121.1.6.1.1 = 0
enterprises.14685.3.1.121.1.6.1.2 = 0
enterprises.14685.3.1.121.1.6.2.1 = 0
enterprises.14685.3.1.121.1.6.2.2 = 0
enterprises.14685.3.1.121.1.6.3.1 = 0
enterprises.14685.3.1.121.1.6.3.2 = 0
enterprises.14685.3.1.121.1.6.4.1 = 0
enterprises.14685.3.1.121.1.6.4.2 = 0
enterprises.14685.3.1.121.1.6.5.1 = 0
enterprises.14685.3.1.121.1.6.5.2 = 0
enterprises.14685.3.1.121.1.7.1.1 = 0
enterprises.14685.3.1.121.1.7.1.2 = 0
enterprises.14685.3.1.121.1.7.2.1 = 0
enterprises.14685.3.1.121.1.7.2.2 = 0
enterprises.14685.3.1.121.1.7.3.1 = 0
enterprises.14685.3.1.121.1.7.3.2 = 0
enterprises.14685.3.1.121.1.7.4.1 = 0
enterprises.14685.3.1.121.1.7.4.2 = 0
enterprises.14685.3.1.121.1.7.5.1 = 0
enterprises.14685.3.1.121.1.7.5.2 = 0
enterprises.14685.3.1.121.1.8.1.1 = 0
enterprises.14685.3.1.121.1.8.1.2 = 0
enterprises.14685.3.1.121.1.8.2.1 = 0
enterprises.14685.3.1.121.1.8.2.2 = 0
enterprises.14685.3.1.121.1.8.3.1 = 0
enterprises.14685.3.1.121.1.8.3.2 = 0
enterprises.14685.3.1.121.1.8.4.1 = 0
enterprises.14685.3.1.121.1.8.4.2 = 0
enterprises.14685.3.1.121.1.8.5.1 = 0
enterprises.14685.3.1.121.1.8.5.2 = 0
enterprises.14685.3.1.121.1.9.1.1 = Counter32: 37
enterprises.14685.3.1.121.1.9.1.2 = Counter32: 37
enterprises.14685.3.1.121.1.9.2.1 = Counter32: 2
enterprises.14685.3.1.121.1.9.2.2 = Counter32: 2
enterprises.14685.3.1.121.1.9.3.1 = Counter32: 0
enterprises.14685.3.1.121.1.9.3.2 = Counter32: 0
enterprises.14685.3.1.121.1.9.4.1 = Counter32: 1200
enterprises.14685.3.1.121.1.9.4.2 = Counter32: 1200
enterprises.14685.3.1.121.1.9.5.1 = Counter32: 0
enterprises.14685.3.1.121.1.9.5.2 = Counter32: 0
enterprises.14685.3.1.121.1.10.1.1 = Counter32: 667
enterprises.14685.3.1.121.1.10.1.2 = Counter32: 667
enterprises.14685.3.1.121.1.10.2.1 = Counter32: 175
enterprises.14685.3.1.121.1.10.2.2 = Counter32: 175
enterprises.14685.3.1.121.1.10.3.1 = Counter32: 147
enterprises.14685.3.1.121.1.10.3.2 = Counter32: 147
enterprises.14685.3.1.121.1.10.4.1 = Counter32: 357
enterprises.14685.3.1.121.1.10.4.2 = Counter32: 357
enterprises.14685.3.1.121.1.10.5.1 = Counter32: 0
enterprises.14685.3.1.121.1.10.5.2 = Counter32: 0
enterprises.14685.3.1.121.1.11.1.1 = Counter32: 0
enterprises.14685.3.1.121.1.11.1.2 = Counter32: 0
enterprises.14685.3.1.121.1.11.2.1 = Counter32: 0
enterprises.14685.3.1.121.1.11.2.2 = Counter32: 0
enterprises.14685.3.1.121.1.11.3.1 = Counter32: 0
enterprises.14685.3.1.121.1.11.3.2 = Counter32: 0
enterprises.14685.3.1.121.1.11.4.1 = Counter32: 0
enterprises.14685.3.1.121.1.11.4.2 = Counter32: 0
enterprises.14685.3.1.121.1.11.5.1 = Counter32: 0
enterprises.14685.3.1.121.1.11.5.2 = Counter32: 0
enterprises.14685.3.1.121.1.12.1.1 = 11
enterprises.14685.3.1.121.1.12.1.2 = 11
enterprises.14685.3.1.121.1.12.2.1 = 4
enterprises.14685.3.1.121.1.12.2.2 = 4
enterprises.14685.3.1.121.1.12.3.1 = 0
enterprises.14685.3.1.121.1.12.3.2 = 0
enterprises.14685.3.1.121.1.12.4.1 = 396
enterprises.14685.3.1.121.1.12.4.2 = 396
enterprises.14685.3.1.121.1.12.5.1 = 0
enterprises.14685.3.1.121.1.12.5.2 = 0
enterprises.14685.3.1.121.1.13.1.1 = 35
enterprises.14685.3.1.121.1.13.1.2 = 35
enterprises.14685.3.1.121.1.13.2.1 = 382
enterprises.14685.3.1.121.1.13.2.2 = 382
enterprises.14685.3.1.121.1.13.3.1 = 0
enterprises.14685.3.1.121.1.13.3.2 = 0
enterprises.14685.3.1.121.1.13.4.1 = 92
enterprises.14685.3.1.121.1.13.4.2 = 92
enterprises.14685.3.1.121.1.13.5.1 = 0
enterprises.14685.3.1.121.1.13.5.2 = 0
enterprises.14685.3.1.121.1.14.1.1 = 3102
enterprises.14685.3.1.121.1.14.1.2 = 3102
enterprises.14685.3.1.121.1.14.2.1 = 400
enterprises.14685.3.1.121.1.14.2.2 = 400
enterprises.14685.3.1.121.1.14.3.1 = 0
enterprises.14685.3.1.121.1.14.3.2 = 0
enterprises.14685.3.1.121.1.14.4.1 = 104924
enterprises.14685.3.1.121.1.14.4.2 = 104924
enterprises.14685.3.1.121.1.14.5.1 = 0
enterprises.14685.3.1.121.1.14.5.2 = 0

Creating Graphs for the device I see what I want to see:

SLMPolicy SLMId
ArsAccount 1
ArsAccount 2
ArsAccountPublic 1
ArsAccountPublic 2
ArsSubscriber 1
ArsSubscriber 2
ArsSubscriptionManager 1
ArsSubscriptionManager 2
ArsUsageTracking 1
ArsUsageTracking 2

Verbose DataQuery

+ Running data query [29].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/usr/local/cacti-0.8.6g/resource/snmp_queries/dpSLMSummary2.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.4.1.14685.3.1.121.1'
+ Located input field 'SLMPolicy' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.14685.3.1.121.1.1'
+ Found item [SLMPolicy='ArsAccount'] index: 1.1 [from value]
+ Found item [SLMPolicy='ArsAccount'] index: 1.2 [from value]
+ Found item [SLMPolicy='ArsAccountPublic'] index: 2.1 [from value]
+ Found item [SLMPolicy='ArsAccountPublic'] index: 2.2 [from value]
+ Found item [SLMPolicy='ArsSubscriber'] index: 3.1 [from value]
+ Found item [SLMPolicy='ArsSubscriber'] index: 3.2 [from value]
+ Found item [SLMPolicy='ArsSubscriptionManager'] index: 4.1 [from value]
+ Found item [SLMPolicy='ArsSubscriptionManager'] index: 4.2 [from value]
+ Found item [SLMPolicy='ArsUsageTracking'] index: 5.1 [from value]
+ Found item [SLMPolicy='ArsUsageTracking'] index: 5.2 [from value]
+ Located input field 'SLMId' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.14685.3.1.121.1.2'
+ Found item [SLMId='1'] index: 1.1 [from value]
+ Found item [SLMId='2'] index: 1.2 [from value]
+ Found item [SLMId='1'] index: 2.1 [from value]
+ Found item [SLMId='2'] index: 2.2 [from value]
+ Found item [SLMId='1'] index: 3.1 [from value]
+ Found item [SLMId='2'] index: 3.2 [from value]
+ Found item [SLMId='1'] index: 4.1 [from value]
+ Found item [SLMId='2'] index: 4.2 [from value]
+ Found item [SLMId='1'] index: 5.1 [from value]
+ Found item [SLMId='2'] index: 5.2 [from value]
+ Found data query XML file at '/usr/local/cacti-0.8.6g/resource/snmp_queries/dpSLMSummary2.xml'
+ Found data query XML file at '/usr/local/cacti-0.8.6g/resource/snmp_queries/dpSLMSummary2.xml'
+ Found data query XML file at '/usr/local/cacti-0.8.6g/resource/snmp_queries/dpSLMSummary2.xml'

My Suggested values for data and graph templates are "|host_description| - |query_SLMPolicy| - |query_SLMId|" for the name and title

When I create the graph, it says:
Created graph: server1.company.com - |query_SLMPolicy| - |query_SLMId|

You can see that the name and title are not being used from the suggested values and the graph does not get created.
So I need help in two areas:
1. Why are the suggested values not being used?
2. Why are the graphs not being created?

[sjsinmi]

Not helpful, but I just spent a few hours creating an SNMP Index Query for Frame-Relay BECNs & FECNs and I see the exact same problem. It works for a single row item, but not for multi-row items.

I do see that the "Index Value" for the correctly working data source is listed as a "1" and I believe it should be "1.107", where 107 is the PVC as configured in the created Index Query.

[gandalf]

Please try to find the SNMP entries at System-Utilities -> SNMP Cache
Reinhard

[mediastream]

In the SNMP cache, I only see entries for the items marked as input in the xml file and see nothing for the output items, or the actual values I need to graph.

[gandalf]

To tackle

Created graph: server1.company.com - |query_SLMPolicy| - |query_SLMId|

I exactly need those SLMPolicy and SLMId from cache. Please post the whole lines.
Reinhard