Unable to populate SAA graphs *PLS HELP*

[spaso]

I have got really strange problem. I have imported templates for monitoring SAA values, that are configured on my router:

***SAA example***

rtr 188
type echo protocol ipIcmpEcho 10.x.x.x source-ipaddr 10.x.x.x
tag test
rtr schedule 188 life forever start-time now

After I click verbose query, everything seems to be OK, I see all 40 devices that are configured to be monitored via SAA. When I select two devices to start creating graphs (and select SAA Basic statistics from roll-down menu) and when I click below button "create", it notifies me that graph are being created, but I do not see any .rrd file in my cacti/rra directory and there are no graphs.

I also want to mention that other graphs for this device are working just fine, I got only problems with SAA. I imported files published on this forum (cacti_data_query_cisco_saa_632.xml AND cisco_saa.xml).
I am also monitoring SAA with MRTG and there is no problem.
I am currently using cacti 0.8.6g, Win2k, PHP 4.4.1, RRDTool 1.0.48
Maybe some useful logs:

c:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Od - SAA Basic Statistics (|query_rttMonCtrlAdminTag|)" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="ms" \
DEF:a="C\:/Apache2/htdocs/cacti/rra/od_rttmin_357.rrd":rtt:AVERAGE \
LINE1:a#FF0000:"RTT Ave" \
GPRINTLAST:"Current\:%8.2lf %s" \
GPRINTAVERAGE:"Average\:%8.2lf %s" \
GPRINTMAX:"Maximum\:%8.2lf %s\n" \
COMMENT:"|query_rttMonCtrlAdminTag| (Count: |query_rttMonLatestJitterOperNumOfRTT|, Size: |query_rttMonEchoAdminPktDataRequestSize| Bytes, Type: |query_rttMonCtrlAdminRttType|)" \
HRULE:|query_rttMonCtrlAdminThreshold|#0000FF:"Threshold\: |query_rttMonCtrlAdminThreshold|.00"

Sorry on my bad English, I hope you will understand what I ment!

Please help!!!

[BSOD2600]

You're not getting valid data, hence the lack of rrd files.

Turn the logging level in cacti to debug for one cycle and look in the log for the SAA stuff. Did it get valid data?

I suggest you read the guide in my signature too.

[spaso]

So the results of all debugging processes I have turned on are:

I click create new graphs, check two entries and click create.
It says to me that Graphs are created, but in Cacti RRA folder I do not see any .rrd file. I click to see with data sources and there is the output:

c:\rrdtool\rrdtool.exe create \
C:/Apache2/htdocs/cacti/rra/od_cisco_rtt_378.rrd \
--step 300 \
DS:cisco_rtt:GAUGE:600:0:U \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \
RRA:LAST:0.5:1:600 \
RRA:LAST:0.5:6:700 \
RRA:LAST:0.5:24:775 \
RRA:LAST:0.5:288:797 \

After I check what says "Graph Managment" debug output, I see:

ERROR: opening 'C:/Apache2/htdocs/cacti/rra/od_cisco_rtt_378.rrd': No such file or directory

So far it would be OK if there would be any od_cisco_rtt_378.rrd file as it mentioned above in debug output. So it means that cacti never created this file, but it should.

So last step I took was debugging watching output in cacti log file for one poll cycle, and there was no query for SAA (just for CPU and interface...).

I also check the values with SNMPwalk and there everything seems to be OK.

Any clue???

[BSOD2600]

Turn the polling level in cacti to debug (Settings | Polling level) for one cycle and paste the output of the actual log file (./cacti/log/cacti.log). If it contains WEBLOG entries, then don't bother posting since they just clutter up the log. Turn off WEBEVENTS logging and try again.

[spaso]

This is the debug output with no WEBLOG entries:

12/08/2005 08:35:01 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:\php\php.exe, ARGS: -q c:/apache2/htdocs/cacti/cmd.php 0 41]
12/08/2005 08:35:02 AM - PHPSVR: Poller[0] DEBUG: SERVER: cmd
12/08/2005 08:35:02 AM - PHPSVR: Poller[0] DEBUG: GETCWD: c:/apache2/htdocs/cacti
12/08/2005 08:35:02 AM - PHPSVR: Poller[0] DEBUG: DIRNAM: c:/apache2/htdocs/cacti
12/08/2005 08:35:02 AM - PHPSVR: Poller[0] DEBUG: FILENM: c:\apache2\htdocs\cacti\script_server.php
12/08/2005 08:35:02 AM - PHPSVR: Poller[0] PHP Script Server has Started - Parent is cmd
12/08/2005 08:35:02 AM - CMDPHP: Poller[0] PHP Script Server Started Properly
12/08/2005 08:35:02 AM - CMDPHP: Poller[0] Host[2] SNMP: Host responded to SNMP
12/08/2005 08:35:02 AM - CMDPHP: Poller[0] Host[2] RECACHE: Processing 7 items in the auto reindex cache for '10.x.x.2'.
12/08/2005 08:35:02 AM - CMDPHP: Poller[0] Host[2] DS[113] SNMP: v1: 10.x.x.2, dsname: 5min_cpu, oid: .1.3.6.1.4.1.9.2.1.58.0, output: 5
12/08/2005 08:35:02 AM - CMDPHP: Poller[0] Host[2] DS[114] SNMP: v1: 10.x.x.2, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, output: 2769891854
12/08/2005 08:35:02 AM - CMDPHP: Poller[0] Host[2] DS[114] SNMP: v1: 10.x.x.2, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, output: 502308119
12/08/2005 08:35:02 AM - CMDPHP: Poller[0] Host[2] DS[115] SNMP: v1: 10.x.x.2, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.2, output: 958315388
12/08/2005 08:35:02 AM - CMDPHP: Poller[0] Host[2] DS[115] SNMP: v1: 10.x.x.2, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.2, output: 1540979611
12/08/2005 08:35:02 AM - CMDPHP: Poller[0] Host[2] DS[234] SNMP: v1: 10.x.x.2, dsname: cisco_usedproc, oid: .1.3.6.1.4.1.9.9.48.1.1.1.5.1, output: 17582860
12/08/2005 08:35:02 AM - CMDPHP: Poller[0] Host[2] DS[232] SNMP: v1: 10.x.x.2, dsname: cisco_freeproc, oid: .1.3.6.1.4.1.9.9.48.1.1.1.6.1, output: 48156980
12/08/2005 08:35:02 AM - CMDPHP: Poller[0] Host[2] DS[233] SNMP: v1: 10.x.x.2, dsname: cisco_largefreeproc, oid: .1.3.6.1.4.1.9.9.48.1.1.1.7.1, output: 47970084
12/08/2005 08:35:03 AM - POLLER: Poller[0] CACTI2RRD: c:\rrdtool\rrdtool.exe update C:\Apache2\htdocs\cacti\rra\od_5min_cpu_113.rrd --template 5min_cpu 1134027301:5
12/08/2005 08:35:03 AM - POLLER: Poller[0] CACTI2RRD: c:\rrdtool\rrdtool.exe update C:\Apache2\htdocs\cacti\rra\od_traffic_in_114.rrd --template traffic_in:traffic_out 1134027301:2769891854:502308119
12/08/2005 08:35:03 AM - POLLER: Poller[0] CACTI2RRD: c:\rrdtool\rrdtool.exe update C:\Apache2\htdocs\cacti\rra\od_traffic_in_115.rrd --template traffic_out:traffic_in 1134027301:958315388:1540979611
12/08/2005 08:35:03 AM - POLLER: Poller[0] CACTI2RRD: c:\rrdtool\rrdtool.exe update C:\Apache2\htdocs\cacti\rra\od_cisco_usedproc_234.rrd --template cisco_usedproc 1134027301:17582860
12/08/2005 08:35:03 AM - POLLER: Poller[0] CACTI2RRD: c:\rrdtool\rrdtool.exe update C:\Apache2\htdocs\cacti\rra\od_cisco_freeproc_232.rrd --template cisco_freeproc 1134027301:48156980
12/08/2005 08:35:03 AM - CMDPHP: Poller[0] Host[4] DS[72] SNMP: v1: 10.250.250.38, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.2, output: 1902479517
12/08/2005 08:35:03 AM - POLLER: Poller[0] CACTI2RRD: c:\rrdtool\rrdtool.exe update C:\Apache2\htdocs\cacti\rra\od_cisco_largefreeproc_233.rrd --template cisco_largefreeproc 1134027301:47970084

So what can it be seen from output is that there is no query for SAA. Any solution?

[BSOD2600]

1) Do you have the SAA queries in the Data Sources section for that host?
2) Do you see the SAA queries in your poller cache?
3) What version of everything are you running?

[spaso]

Never mind, thanks for your effort, but I solved the problem. The issue was indexing. All configured SAAs was configured in same way, without tags, so cacti could not distinguish between them. After I put tags in configuration it started to working without problems.

Thanks once again.

[Frizz]

....The issue was indexing. All configured SAAs was configured in same way, without tags, so cacti could not distinguish between them. After I put tags in configuration it started to working without problems....

Hello spaso,
realy interesting because i´m running into nearly the same issue. I have configured the rtr with the Cisco IPM, get all defined jobs, could create graphs, get valid SNMP data but all graphs are broken graphs. What do mean with "After I put tags in configuration" ?. Do you can post an config example, or what else have you done?

[lorcs]

Hi,

I also have identical problem issue when trying to use SAA in Cacti. There is not RRD file written to the directory as well. I have already configure TAG in the Cisco router and I can also see SAA in query but I just can't see any graph and rrd file.

I am using 0.86h in FC4 platform.

Ray

....The issue was indexing. All configured SAAs was configured in same way, without tags, so cacti could not distinguish between them. After I put tags in configuration it started to working without problems....

Hello spaso,
realy interesting because i´m running into nearly the same issue. I have configured the rtr with the Cisco IPM, get all defined jobs, could create graphs, get valid SNMP data but all graphs are broken graphs. What do mean with "After I put tags in configuration" ?. Do you can post an config example, or what else have you done?

[BSOD2600]

Does a verbose query show valid data?

Did you look in your cacti log with debugging enabled and checked for valid data?

[TheWitness]

In order for SAA to work properly, you must provide a name for every
SAA query object. If you don't, Cacti will have no way to maintain an index primary key.

Please edit your host and perform a "verbose query" from the Data Query. Post your output.

TheWitness

[vishnubraj]

I am also facing the probelm. When i do the verbose query i get the tags but it is not getting applied when i create the new graphs. Please help.

+ Running data query [10].
+ Found type = '3' [SNMP Query].
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/cisco_saa.xml'
+ XML file parsed ok.
+ <oid_num_indexes> missing in XML file, 'Index Count Changed' emulated by counting oid_index entries
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.4.1.9.9.42.1.2.1.1.2' Index Count: 8
+ Index found at OID: '1.3.6.1.4.1.9.9.42.1.2.1.1.2.2027010' value: 'NET'
+ Index found at OID: '1.3.6.1.4.1.9.9.42.1.2.1.1.2.2063006' value: 'NET'
+ Index found at OID: '1.3.6.1.4.1.9.9.42.1.2.1.1.2.2094001' value: 'NET'
+ Index found at OID: '1.3.6.1.4.1.9.9.42.1.2.1.1.2.2113002' value: 'NET'
+ Index found at OID: '1.3.6.1.4.1.9.9.42.1.2.1.1.2.2114001' value: 'NET'
+ Index found at OID: '1.3.6.1.4.1.9.9.42.1.2.1.1.2.2114006' value: 'NET'
+ Index found at OID: '1.3.6.1.4.1.9.9.42.1.2.1.1.2.2115001' value: 'NET'
+ Index found at OID: '1.3.6.1.4.1.9.9.42.1.2.1.1.2.2116006' value: 'NET'
+ Located input field 'rttMonCtrlAdminTag' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.9.9.42.1.2.1.1.3'
+ Found item [rttMonCtrlAdminTag='TL3_BOM2'] index: 2027010 [from value]
+ Found item [rttMonCtrlAdminTag='TL3_TLV1'] index: 2063006 [from value]
+ Found item [rttMonCtrlAdminTag='PL2_FRA1'] index: 2094001 [from value]
+ Found item [rttMonCtrlAdminTag='PL2_BOM2'] index: 2113002 [from value]
+ Found item [rttMonCtrlAdminTag='PL2_ASH1'] index: 2114001 [from value]
+ Found item [rttMonCtrlAdminTag='TL2_ASH1'] index: 2114006 [from value]
+ Found item [rttMonCtrlAdminTag='PL2_FRA1'] index: 2115001 [from value]
+ Found item [rttMonCtrlAdminTag='TL3_HKG1'] index: 2116006 [from value]
+ Located input field 'rttMonEchoAdminProtocol' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.9.9.42.1.2.2.1.1'
+ Found item [rttMonEchoAdminProtocol='27'] index: 2027010 [from value]
+ Found item [rttMonEchoAdminProtocol='27'] index: 2063006 [from value]
+ Found item [rttMonEchoAdminProtocol='27'] index: 2094001 [from value]
+ Found item [rttMonEchoAdminProtocol='27'] index: 2113002 [from value]
+ Found item [rttMonEchoAdminProtocol='27'] index: 2114001 [from value]
+ Found item [rttMonEchoAdminProtocol='27'] index: 2114006 [from value]
+ Found item [rttMonEchoAdminProtocol='27'] index: 2115001 [from value]
+ Found item [rttMonEchoAdminProtocol='27'] index: 2116006 [from value]
+ Located input field 'rttMonEchoAdminPktDataRequestSize' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.9.9.42.1.2.2.1.3'
+ Found item [rttMonEchoAdminPktDataRequestSize='1024'] index: 2027010 [from value]
+ Found item [rttMonEchoAdminPktDataRequestSize='1024'] index: 2063006 [from value]
+ Found item [rttMonEchoAdminPktDataRequestSize='1024'] index: 2094001 [from value]
+ Found item [rttMonEchoAdminPktDataRequestSize='1024'] index: 2113002 [from value]
+ Found item [rttMonEchoAdminPktDataRequestSize='1024'] index: 2114001 [from value]
+ Found item [rttMonEchoAdminPktDataRequestSize='1024'] index: 2114006 [from value]
+ Found item [rttMonEchoAdminPktDataRequestSize='1024'] index: 2115001 [from value]
+ Found item [rttMonEchoAdminPktDataRequestSize='1024'] index: 2116006 [from value]
+ Located input field 'rttMonCtrlAdminThreshold' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.9.9.42.1.2.1.1.5'
+ Found item [rttMonCtrlAdminThreshold='3000'] index: 2027010 [from value]
+ Found item [rttMonCtrlAdminThreshold='3000'] index: 2063006 [from value]
+ Found item [rttMonCtrlAdminThreshold='3000'] index: 2094001 [from value]
+ Found item [rttMonCtrlAdminThreshold='3000'] index: 2113002 [from value]
+ Found item [rttMonCtrlAdminThreshold='3000'] index: 2114001 [from value]
+ Found item [rttMonCtrlAdminThreshold='5000'] index: 2114006 [from value]
+ Found item [rttMonCtrlAdminThreshold='3000'] index: 2115001 [from value]
+ Found item [rttMonCtrlAdminThreshold='3000'] index: 2116006 [from value]
+ Located input field 'rttMonCtrlAdminRttType' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.9.9.42.1.2.1.1.4'
+ Found item [rttMonCtrlAdminRttType='9'] index: 2027010 [from value]
+ Found item [rttMonCtrlAdminRttType='9'] index: 2063006 [from value]
+ Found item [rttMonCtrlAdminRttType='9'] index: 2094001 [from value]
+ Found item [rttMonCtrlAdminRttType='9'] index: 2113002 [from value]
+ Found item [rttMonCtrlAdminRttType='9'] index: 2114001 [from value]
+ Found item [rttMonCtrlAdminRttType='9'] index: 2114006 [from value]
+ Found item [rttMonCtrlAdminRttType='9'] index: 2115001 [from value]
+ Found item [rttMonCtrlAdminRttType='9'] index: 2116006 [from value]
+ Located input field 'rttMonLatestJitterOperNumOfRTT' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.9.9.42.1.5.2.1.1'
+ Found item [rttMonLatestJitterOperNumOfRTT='100'] index: 2027010 [from value]
+ Found item [rttMonLatestJitterOperNumOfRTT='100'] index: 2063006 [from value]
+ Found item [rttMonLatestJitterOperNumOfRTT='100'] index: 2094001 [from value]
+ Found item [rttMonLatestJitterOperNumOfRTT='100'] index: 2113002 [from value]
+ Found item [rttMonLatestJitterOperNumOfRTT='100'] index: 2114001 [from value]
+ Found item [rttMonLatestJitterOperNumOfRTT='100'] index: 2114006 [from value]
+ Found item [rttMonLatestJitterOperNumOfRTT='100'] index: 2115001 [from value]
+ Found item [rttMonLatestJitterOperNumOfRTT='100'] index: 2116006 [from value]
+ Located input field 'rttMonLatestHTTPOperMessageBodyOctets' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.9.9.42.1.5.1.1.5'

[BSOD2600]

I'd agree, the verbose output would seem correct. Follow the steps in http://forums.cacti.net/viewtopic.php?f=3&t=11747 and post your findings.

[vishnubraj]

This isssue is fixed. I had two IPSLA with same tag. after deleting one IPSLA the issue got resolved.
Now I understand the Lines "The more you see the Less you see"