snmp data returns values but not graphing

[CanDee]

hi.
i have 3 hosts processing several snmp oids..
2 of them are runnin perfectly but only one is not updating one rrd file...i got no idea why

SPINE: Poller[0] Host[154] TH[1] DS[4115] SNMP: v2: localhost, dsname: _traffic, oid: SNMPv2-SMI::enterprises.17462.1.2.2.2.1.5.3, value: 25268248

There is the Value...but the graph only shows 0.00

as soon as i add this graph to the host log shows:

Code: Select all

10/14/2010 02:26:38 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id=Get Processor Utilization and snmp_query_graph_rrd.data_template_id=95 and data_template_rrd.local_data_id=3801" 

[gandalf]

The "graph id" in that sql statement is invalid. I'm wondering, how you managed to put a string there.
R.