|
After few hours I have figured out what works and what doesn't ...
At least I have many bugs in my report writer (*.rw) file.
My kit is first SSB v1.3 kit.
Fore example, if I try to produce "TCP Traffic report" the
result is
tcpip_tcp_traffic.rpt.rpt_log
INGRES REPORT -- Copyright (c) 1981, 1992 Ingres Corporation
Reading report specifications and preparing query . . .
File '/usr/mcc/reports/tcpip_tcp_traff_rpt.rw': Start of specifications for Repo
rt 'tcpip_tcp_traff_rpt'.
E_RW13CB File '/usr/mcc/reports/tcpip_tcp_traff_rpt.rw' Line 193: Cannot
use boolean expression in this command.
Line in error:
.nl
^
Error processing continues . . .
E_RW100A 1 error(s) have occurred in setting up the report. No report will
be written. Correct errors and rerun.
And the line before '.nl' is
reset_total = 1
If I add .let before reset_total = 1, ie.
.let reset_total = 1
I get decent TCP traffic report.
The same problem exist in files
tcpip_tcp_traff_rpt.rw
tcpip_snmp_traff_rpt.rw
tcpip_snmp_error_rpt.rw
tcpip_int_traff_rpt.rw
tcpip_int_error_rpt.rw
tcpip_ip_traff_rpt.rw
tcpip_ip_error_rpt.rw
*************************************************************
Could someone who knowns something about the reports confirm
that the changes are mandatory.
*************************************************************
After that everything in SNMP reports works but graphs.
I'm exporting SNMP, IP, INTERFACE and TCP informationand
everything is OK from that point of view.
Interface hourly graph produces
INGRES TERMINAL MONITOR -- Copyright (c) 1981, 1992 Ingres Corporation
INGRES ULTRIX Version 6.4/03 (ds3.ulx/00) login Tue Mar 23 13:27:30 1993
continue
* * * Executing . . .
E_US0AC1 DROP: 'mcc_int_hourly_gr_tbl' does not exist or is not owned by
you.
(Tue Mar 23 13:27:30 1993)
continue
* * * * * * * * * * * * * * * * Executing . . .
(0 rows)
continue
* * * * * * * Executing . . .
(0 rows)
continue
* * * * * * * * * * * Executing . . .
(0 rows)
(0 rows)
continue
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Executin
g . . .
(0 rows)
(0 rows)
(0 rows)
(0 rows)
continue
* * * * * * Executing . . .
continue
* * Your SQL statement(s) have been committed.
INGRES Version 6.4/03 (ds3.ulx/00) logout
Tue Mar 23 13:27:37 1993
INGRES RUNGRAPH -- Copyright (c) 1986, 1992 Ingres Corporation
Retrieving graph 'mcc_int_hourly_graph' . . .
Retrieving data . . .
E_GR003C Table or view 'mcc_int_hourly_gr_tbl' has no rows.
It seems to be that something is missing ?!?! What/who adds entries
to mcc_int_hourly_gr_tbl table (it is empty) ?
Rgds,
//pasi
|
| I have run across some of the same problems, but most
should have been fixed. I am just starting to look into
the Ingres/Vigraph commands now that I have the manuals,
so I don't have any answers for you at this moment.
The problem of the missing word (.let) in the *.rw files
will be corrected. Since I didn't write the reports, and
since I ran the reports without the error occuring, I didn't
realize that this was a bug. Thanks for pointing it out, and
I will make the change in the routines.
- signed a very *BUSY* sample report fixer
- Darrell
|