Conference azur::mcc

4575.0. "TCP/IP Reports --> MCC_SNMP_INTERFACE NOT...." by SPANKY::SAWYER () Fri Feb 19 1993 11:43

    Hi,
    
    I'm having problems generating reports for tcp/ip entities.
    
    The SNMP,TCP,and the IP traffic reports work fine but I cannot
    generate any of the INTERFACE TRAFFIC REPORTS or GRAPHS. (RPTS 5-10)
    
    The error I'm getting in the log file is:
    MCC_SNMP_INTERFACE IS NOT A READIED SOURCE,COLLECTION,OR LIST.
    CURRENT IS NOT A READIED SOURCE,COLLLECTION,OR LIST.
    
    Here is a copy of the log file.
    
    $!---------------------------------------
    $! disable Control Y
    $!---------------------------------------
    $ set nocontrol=Y
    $!
    $!---------------------------------------
    $!        redefine DTR symbol
    $!---------------------------------------
    $ XX = ""
    $ IF XX .EQS. ""
    $ THEN
    $   IF f$search("SYS$SYSTEM:DTR32.EXE") .nes. ""
    $   THEN
    $       DTR == "$DTR32"
    $   ELSE
    $   ENDIF
    $ ENDIF
    $!---------------------------------------
    $! end dtr definition
    $!---------------------------------------
    $!
    $!
    $!  Avoid customer  the use of /Nocommand at login
    $!
    $!
    $ aa= F$GETJPI(0,"ACCOUNT")
    $ if aa .eqs. "CUSTOMER"
    $ else
    $  set control=Y
    $ endif
    $!
    $!
    $!
    $!
    $! This command procedure is always run when anybody on the entire
    system
    $! logs in. It is equivalent to LOGIN.COM except that the instructions
    $! contained herein are executed everytime anyone on the VMS system
    $! logs in to their account.
    $!
    $! For interactive processes, turn on Control T, and set the terminal
    type
    $!
    $ IF (F$MODE() .EQS. "INTERACTIVE") THEN SET CONTROL=T
    $ IF (F$MODE() .EQS. "INTERACTIVE") THEN SET TERMINAL/INQUIRE
    $ IF (F$MODE() .EQS. "INTERACTIVE") THEN MC :== MCR
    $ SET TERM/PERM/INSERT
    %SET-W-NOTSET, error modifying DKA200:
    -CLI-E-IVDEVTYPE, invalid device type - specify a mailbox device
    $!
    $! For MicroVAX systems only, use the command MOUNT/NOASSIST.
    $!
    $ IF (.NOT. F$TRNLNM("SYS$MICROVAX")) THEN GOTO SKIP_MICROVAX_COMMANDS
    $SKIP_MICROVAX_COMMANDS:
    $!
    $! Place your site-specific LOGIN commands below
    $!
    $ IF (F$MODE() .EQS. "INTERACTIVE")
    $ ENDIF
    $!
    $! This command procedure is a framework for building an individual
    $! login command procedure. It is executed every time that you log
    $! into your account.
    $!
    $  IF F$MODE() .NES. "INTERACTIVE" THEN GOTO ENDINTER
    $ENDINTER:
    $  IF F$MODE() .NES. "BATCH" THEN GOTO ENDBATCH
    $!
    $! Put commands you want executed only in batch mode between this
    comment
    $! and the "ENDBATCH:" symbol.
    $!
    $
    $ENDBATCH:
    $!
    $! Put commands that you want executed in any mode of login below.
    $!
    $
    $ ! Generate the reports.
    $ THIS_PROCESS = ""
    $ PID = F$PID(THIS_PROCESS)
    $! show sym PID
    $ TIME = F$TIME()
    $ DAY = F$CVTIME(TIME,,"DAY")
    $ MONTH= F$CVTIME(TIME,,"MONTH")
    $ YEAR = F$CVTIME(TIME,,"YEAR")
    $ HOUR = F$CVTIME(TIME,,"HOUR")
    $ MIN = F$CVTIME(TIME,,"Minute")
    $ SEC = F$CVTIME(TIME,,"second")
    $ HUNDREDTH = F$CVTIME(TIME,,"HUNDREDTH")
    $!
    $ define peak_dt_int_temp1 peak_dt_int_temp1.0000004119112658
    $ define int_tbl_temp1 int_tbl_temp1.0000004119112658
    $ define n_tbl_temp1 n_tbl_temp1.0000004119112658
    $!
    $define mcc$node1 "ALL"
    $define mcc$interface "999"
    $define mcc$date1 "18-FEB-1993 11:00:00.00"
    $define mcc$date2 "19-FEB-1993 11:00:00.00"
    $define mcc$report_file  "tcpip_int_traffic.rpt"
    $dtr
    VAX DATATRIEVE V5.1
    Digital Query and Report System
    Type HELP for help
    
    :TCPIP_INT_TRAFF_RPT
    "MCC_SNMP_INTERFACE" is not a readied source, collection, or list.
    "CURRENT" is not a readied source, collection, or list.
    "CURRENT" is not a readied source, collection, or list.
    "CURRENT" is not a readied source, collection, or list.
    "RPT_RECORDS" is not a readied source, collection, or list.
    "RPT_RECORDS" is not a readied source, collection, or list.
    "EXP_CVR_STATISTICS" is undefined or used out of context.
    exit
    $ DELETE/NOCONFIRM INT_TBL_TEMP1.0000004119112658;*
    $ DELETE/NOCONFIRM N_TBL_TEMP1.0000004119112658;*
    $ DELETE/NOCONFIRM PEAK_DT_INT_TEMP1.0000004119112658;*
    $exit
      SYSTEM       job terminated at 19-FEB-1993 11:27:35.99
    
      Accounting information:
      Buffered I/O count:             319         Peak working set size:   
    3831
      Direct I/O count:              1180         Peak page file size:    
    13695
      Page faults:                   4362         Mounted volumes:            
    0
      Charged CPU time:           0 00:00:10.48   Elapsed time:     0
    00:00:38.95
    
    Thanks for the help,
    
    Rob

What version of DECmcc are you running?
There has been significant work on the sample reports for V1.3,
which should be available shortly.

-- Erik

    I am running version T1.3.1.

In looking through the Datatrieve manuals, this is what it says about
this error:

        Explanation:

        The source for a DATATRIEVE collection must be a readied domain,
        relation, or VAX DBMS record; a collection; or a list.

        User Action:

        Check that you have spelled all names correctly.  Ready the
        appropriate record source, if necessary, and reenter the
        statement.

Since others are able to get the report to work properly, it seems to
me that one of two things are missing.

	1) you didn't export any INTERFACE data - see note 4461.4
	2) MCC_EXPORT wasn't properly defined in Datatrieve.
		see the Reports Use manual (page 2-3)
	    basically:
		DTR> DELETE MCC_EXPORT;
		DTR> REDEFINE DATABASE MCC_EXPORT ON disk:[directory]name;
		DTR> SHOW MCC_EXPORT

Personally, I think it is possibility number 1 since you state that you are
able to have the TCP, IP, and SNMP reports working.