nv-l
[Top] [All Lists]

RE: [nv-l] MIB Data and Graph

To: <nv-l@lists.us.ibm.com>
Subject: RE: [nv-l] MIB Data and Graph
From: "Anvaj Aliyarukutty" <anvaj.aliyarukutty@ustri.com>
Date: Fri, 21 Apr 2006 17:44:01 +0530
Delivery-date: Fri, 21 Apr 2006 13:15:03 +0100
Envelope-to: nv-l-archive@lists.skills-1st.co.uk
In-reply-to: <OF2870BA6D.D788A8AC-ON85257156.006BE23E-85257156.006C4DD0@us.ibm.com>
Reply-to: nv-l@lists.us.ibm.com
Sender: owner-nv-l@lists.us.ibm.com
Thread-index: AcZksrWUHgzYwfVGT/K7OLqNjvn1OwAhGwuw
Thanks James and I did enable the option. 

Still I am not able to see the graphs or data collected on NetView screen. I
looked at the nv.log file and see error like below. These errors comes in to
nv.log and looks like generated when i  go to see the data collected using
mib data collect, or mib graph

What can I do to fix on the sql database? Do we have any docs available for
SQL database on Windows?


------------------------------------------------------------------------


04/20/06 15:25:58 [tess] (setConnectionString) Information from connecting
to SQL Driver Data source: tess_ds

04/20/06 15:25:58 [tess]   1. [Microsoft][ODBC SQL Server Driver][SQL
Server]Changed database context to 'NetViewDb'.

04/20/06 15:25:58 [tess]   2. [Microsoft][ODBC SQL Server Driver][SQL
Server]Changed language setting to us_english.

04/20/06 15:33:46 [collect] (RequeryThread) SQL error querying database.
select call

04/20/06 15:33:46 [collect]   1. [Microsoft][ODBC SQL Server Driver][SQL
Server]A column has been specified more than once in the order by list.
Columns in the order by list must be unique. [SQLState: 37000]

04/20/06 15:33:46 [collect]   2. [Microsoft][ODBC SQL Server Driver][SQL
Server]The cursor was not declared. [SQLState: 37000]

04/20/06 15:34:53 [collect] (RequeryThread) SQL error querying database.
select call

04/20/06 15:34:53 [collect]   1. [Microsoft][ODBC SQL Server Driver][SQL
Server]A column has been specified more than once in the order by list.
Columns in the order by list must be unique. [SQLState: 37000]

04/20/06 15:34:53 [collect]   2. [Microsoft][ODBC SQL Server Driver][SQL
Server]The cursor was not declared. [SQLState: 37000]

04/20/06 15:35:18 [collect] (RequeryThread) SQL error querying database.
select call

04/20/06 15:35:18 [collect]   1. [Microsoft][ODBC SQL Server Driver][SQL
Server]A column has been specified more than once in the order by list.
Columns in the order by list must be unique. [SQLState: 37000]

04/20/06 15:35:18 [collect]   2. [Microsoft][ODBC SQL Server Driver][SQL
Server]The cursor was not declared. [SQLState: 37000]

04/20/06 15:35:31 [graph] There is no data to graph.
--------------------------------------------------------------------------




-----Original Message-----
From: owner-nv-l@lists.us.ibm.com [mailto:owner-nv-l@lists.us.ibm.com] On
Behalf Of James Shanks
Sent: Friday, April 21, 2006 1:13 AM
To: nv-l@lists.us.ibm.com
Subject: Re: [nv-l] MIB Data and Graph

As memory serves me, I believe that you must also store the data in the
internal files if you want to graph it.
Go to serversetup, pull down Daemon Control --> SNMP Collect Daemon and
then pull down "Store Collected Data In" and select the second option, Both
Internal Files and an  SQL database"


James Shanks
Level 3 Support  for Tivoli NetView for UNIX and Windows
Tivoli Software / IBM Software Group


                                                                           
             "Anvaj                                                        
             Aliyarukutty"                                                 
             <anvaj.aliyarukut                                          To 
             ty@ustri.com>             <nv-l@lists.us.ibm.com>             
             Sent by:                                                   cc 
             owner-nv-l@lists.                                             
             us.ibm.com                                            Subject 
                                       [nv-l] MIB Data and Grapgh          
                                                                           
             04/20/2006 03:03                                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
             nv-l@lists.us.ibm                                             
                   .com                                                    
                                                                           
                                                                           




I am using NetView 7.1.4 on Windows 2000 Advanced Server, with SQL
database. I am facing a strange problem in the MIB data collection, MIB
data windows, where I am not able to see any collected data and hence
couldn't see any graphs as well. But On event monitor I could see threshold
events generated based the data collection given. (Data correspond to the
same threshold events are also not able to see or graph using the MIB data
and MIB graph).

Is it because I am collecting data on SQL database?

Best Regards,
Anvaj







<Prev in Thread] Current Thread [Next in Thread>

Archive operated by Skills 1st Ltd

See also: The NetView Web