Conference azur::mcc

>E_US0845 Table 'mcc_snmp_ip_13' does not exist or is not owned by you.
>    (Wed Jan 27 16:14:27 1993)

	This message tells that "SNMP IP" has not been exported.
	
	It looks like you exported only SNMP but not SNMP IP.

	The second problem is that you are exporting with interval 30 seconds
        and your system can not handle this:

             Number of successful polls = 2368,

               Last poll failure reason = "schedule time passed",
                 Number of failed polls = 2718,

	It means that database is half empty. Do you really need such a
        short export period? 


	SAm
    

>Do you really need such a short export period? 

No, I to be 30 minutes.  I'll change that.  But, ..

>It looks like you exported only SNMP but not SNMP IP.


I have tried different reports and get the same error with a different table name.

'mcc_int_hourly_gr_tbl'
'mcc_snmp_interface_13'
'mcc_tmp2039'
'mcc_snmp_traff_sum1599' ... does not exist or is not owned by you.

r traffic statistics?  I though the export
command got everything.  

I will chang the export interval to be 30 minutes and try again.

... scott

I have reset the exporting to a larger time and can run reports on Phase V 
entites (DECNIS 600s) and the SNMP entities, but I only get the SNMP traffic
reports.

I have set up exporting on mulitple SNMP entites that look like this:
(note that i restarted exporting several times so all numbers won't match)

MCC> show exporting snmp tblcp-cpr1

SNMP tblcp-cpr1
AT 1993-01-29-17:01:26.928

Exporting parameters are:
                        Exporting state = ACTIVE,
                            State since = 1993-01-29-13:44:24.032,
                          Export period = +0-01:00:00.000I-----,
                             Begin time = 1993-01-29-13:44:18.008,
                               End time = 2012-05-25-00:00:00.000,
                          Export target = "mcc_export_rdb",
                           Request time = 1993-01-29-13:44:18.008,
                           Requested by = "scott",
           Time of last successful poll = "1993-01-29-16:57:23.040",
             Number of successful polls = 3,
               Time of last failed poll = "NONE",
               Last poll failure reason = "N/A",
                 Number of failed polls = 0,
                       Last export time = "1993-01-29-16:57:24.645",
            Time of last export failure = "NONE",
             Last export failure reason = "Background exporting process is not
                                          set up",
              Number of export failures = 0,
                          Sequence name = "EXPORT",
                Initial sequence number = 0,
                Current sequence number = 3
MCC>

When run reports I get the following under the SNMP Traffic Summary for the above node:



Host Name: tblcp-cpr1
Number of Interfaces:     2

               Total             Total               Avg Octets/
               Octets            Packets             Packet
               ------            -------             ----------
In:            194070               1423                 136.38
Out:           158806               2211                  71.83
Total:         352876               3634                  97.10

Successful Polls:     6 out of     6 total polls.
  

THat is the only report I can get,  For the IP Traffic and TCP Traffic and
Interface traffic I get an error. I have included the log files below.

My Phase V reports are working.

I am polling multiple types of SNMP entities, a DECsystem 5000, a Wellfleet AFN,
& a DECNIS 600.

Why am I not getting any IP or TCP traffic, or Interface traffic.???


I get the following in the log file

# more tcpip_ip_traffic.rpt.rpt_log
INGRES REPORT -- Copyright (c) 1981, 1990 Ingres Corporation
Reading report specifications and preparing query...
File '/usr/mcc/reports/tcpip_ip_traff_rpt.rw': Start of specifications for Repor
t 'tcpip_ip_traff_rpt'.
E_US0845 Table 'mcc_snmp_ip_13' does not exist or is not owned by you.
    (Fri Jan 29 16:57:06 1993)

E_RW1019 Either you had errors in the .QUERY command, or you didn't
    specify either a .QUERY or .DATA command.  Processing stops.

E_RW100A 1 nonfatal errors have occurred in setting up the report. No
    report will be written.  Correct errors and rerun.
                

#  more tcpip_int_traffic_sum.rpt.rpt_log
INGRES TERMINAL MONITOR -- Copyright (c) 1981, 1990 Ingres Corporation
ULTRIX/SQL Version 2.0  login Fri Jan 29 16:57:27 1993
Copyright (c) 1991, Digital Equipment Corporation.

ULTRIX/SQL Version 2.0

continue
* * * * * * * * * Executing . . .

E_US0845 Table 'mcc_snmp_interface_13' does not exist or is not owned by
    you.
    (Fri Jan 29 16:57:27 1993)

continue
* * *
ULTRIX/SQL Version 2.0  logout
Fri Jan 29 16:57:28 1993
INGRES REPORT -- Copyright (c) 1981, 1990 Ingres Corporation
Reading report specifications and preparing query...
File '/usr/mcc/reports/tcpip_int_traff_summary_rpt.rw': Start of specifications
for Report 'tcpip_int_traff_sum'.
E_US0845 Table 'mcc_snmp_interface_13' does not exist or is not owned by
    you.
    (Fri Jan 29 16:57:29 1993)

E_RW1019 Either you had errors in the .QUERY command, or you didn't
    specify either a .QUERY or .DATA command.  Processing stops.

E_RW100A 1 nonfatal errors have occurred in setting up the report. No
    report will be written.  Correct errors and rerun.

INGRES TERMINAL MONITOR -- Copyright (c) 1981, 1990 Ingres Corporation
ULTRIX/SQL Version 2.0  login Fri Jan 29 16:57:29 1993
Copyright (c) 1991, Digital Equipment Corporation.
* * * Executing . . .

E_US0AC1 DROP: 'mcc_int_traff_sum2216' does not exist or is not owned by
    you.
    (Fri Jan 29 16:57:29 1993)

continue
* * *
ULTRIX/SQL Version 2.0  logout
Fri Jan 29 16:57:29 1993
#
ULTRIX/SQL Version 2.0

continue

> Why am I not getting any IP or TCP traffic, or Interface traffic.???

  
The Export command exports data ONLY for an entity instance which class 
is specified in the command.
IP, TCP, and Interface are defined as child entities of an SNMP. 
So in addition to "Export snmp <snmp_name> ...." you need to set up 
the following exportings:
	
		- "Export snmp <snmp_name> ip ...."
		- "Export snmp <snmp_name> tcp ...."
		- "Export snmp <snmp_name> interface * ...."

	SAm