[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference azur::mcc

Title:DECmcc user notes file. Does not replace IPMT.
Notice:Use IPMT for problems. Newsletter location in note 6187
Moderator:TAEC::BEROUD
Created:Mon Aug 21 1989
Last Modified:Wed Jun 04 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:6497
Total number of notes:27359

3749.0. "Ingres sql problem with Report generation - E_US0845 Table 'mcc_snmp_ip_13' does not exist or is not owned by yo" by MDCRAB::STUART (Scott Stuart - MARVA Network Sales Support DTN 341-3132 - MARVA District) Wed Sep 16 1992 13:13

I am trying to generate TCP and IP traffic reports and get the message listed below.
ULTRIX SQL is installed and running and have installed the appropriate parts
of INGRES report writer.

I have set up recording on IP and TCP under all partitions on a node.  When I run any report
(traffic for IP or TCP) I get the following log file:  

Any suggestion? Thanks...  scott

# 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.
    (Thu Sep 10 18:18:17 1992)

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.
#
T.RTitleUserPersonal
Name
DateLines
3749.1use EXPORTER not HISTORIANTOOK::SHMUYLOVICHWed Sep 16 1992 14:175
  In order to run report package you have to EXPORT data  (NOT record). 

	SAm
    
3749.2MDCRAB::STUARTScott Stuart - MARVA Network Sales Support DTN 341-3132 - MARVA DistrictWed Sep 16 1992 20:136
1) I have set up exporting on the data as well as recoding and I get the same
error.  What does is indicate?

2) Do I not have to set up any recoding to run reports?  Only exporting?

 If yes, what use do I make of the recording?
3749.3TOOK::SHMUYLOVICHThu Sep 17 1992 15:3137


>1) I have set up exporting on the data as well as recoding and I get the same
>error.  What does is indicate?

	The error message "E_US0845 Table 'mcc_snmp_ip_13' does not exist or 
	is not owned by you" indicates that:
	
		a. The database used in the Export directive has been 
		   created as private and the user running reports has no
		   access to it (see INGRES createdb utility) OR
		  
		b. The exporting for "snmp ip" has not been set up
		   ( use the Show Exporting directive to verify the status
		     of exporting).


>2) Do I not have to set up any recoding to run reports?  Only exporting?

	ONLY exporting.

> If yes, what use do I make of the recording?

	It's to much details to explain here the difference between
 the usage of the Historian and Exporter FMs. You can find them in
 the Historical Data Services Use manual.
	
	The main difference is that Historian collects data in the 
 MCC internal database and Exporter exports data outside of MCC.
 Data collected by Historian are accessible ONLY through MCC using 
 Show directive. Data exported by Exporter are stored in the standard
 Rdb/VMS or ULTRIX/SQL database and can be obtained using any database
 tool.
 
	SAm
    
3749.4thanksMDCRAB::STUARTScott Stuart - MARVA Network Sales Support DTN 341-3132 - MARVA DistrictThu Sep 17 1992 22:131
thanks . I'll take a look at the database access . and rtfm again... scott