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
|