[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

4551.0. "Line & Circuit Reporting Problems" by SPANKY::SAWYER () Tue Feb 16 1993 10:51

    I'm having problems using DECmcc Reports.
    
    I've exported data on a PhaseIV Entity and on its Child
    Entities "Line QNA-0" and "Circuit QNA-0".
    
    But the only reports that will generate any data are the
    Node Traffic,Node Error,Summary Traffic, and Summary Error
    Reports.
    
    None of the Line or Circuit Reports will generate any data.
    The files all have size 0 and the log files have no errors in
    them.
    
    Here's 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.
    $!
    $! 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.
    $!
    $
    $!mcc_rpts_node4_line_traffic_summary_dtr.com
    $!************************************************************
    $!  Copyright (c) Digital Equipment Corporation, 1990
    $!  All Rights Reserved.  Unpublished rights reserved
    $!  under the copyright laws of the United States.
    $!
    $!  The software contained on this media is proprietary
    $!  to and embodies the confidential technology of
    $!  Digital Equipment Corporation.  Possession, use,
    $!  duplication or dissemination of the software and
    $!  media is authorized only pursuant to a valid written
    $!  license from Digital Equipment Corporation.
    $!
    $!  RESTRICTED RIGHTS LEGEND   Use, duplication, or
    $!  disclosure by the U.S. Government is subject to
    $!  restrictions as set forth in Subparagraph (c)(1)(ii)
    $!  of DFARS 252.227-7013, or in FAR 52.227-19, as
    $!  applicable.
    $!************************************************************
    $!********************************
    $! This command procedure is submitted by
    mcc_rpts_node4_node_traffic_summary.com
    $! This procedure is submitted with four parameters.
    $! It uses PID, dAY,hour etc in the extension of file name to create
    unique
    $! temporary files.
    $!***************************************************************************
    $ !
    $ ! 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")
    $ space1 = " "
    $
    $ define node4_line_sum line_tmp.000000411516172755
    $!
    $define mcc$top_num "ALL"
    $define mcc$date1  "15-FEB-1993 15:00:00.00"
    $define mcc$date2  "15-FEB-1993 16:00:00.00"
    $define mcc$report_file  "NODE4_LINE_TRAFFIC_SUM.RPT"
    $datatrieve
    VAX DATATRIEVE V5.1
    Digital Query and Report System
    Type HELP for help
    
    :node4_line_traffic_sum_rPT
    exit
    $ delete/noconfirm line_tmp.000000411516172755.*
    $ exit
      SYSTEM       job terminated at 15-FEB-1993 16:17:54.91
    
      Accounting information:
      Buffered I/O count:             221         Peak working set size:   
    4105
      Direct I/O count:               813         Peak page file size:    
    14119
      Page faults:                   4794         Mounted volumes:            
    0
      Charged CPU time:           0 00:00:08.95   Elapsed time:     0
    00:00:29.03
    
    
    
    Some of the lines are a little off because of different screen widths
    when I pasted.
    
    Is there any other child entities I forgot to export on to get
    more data??
    
    Thanks in advance,
    
    Rob Sawyer
T.RTitleUserPersonal
Name
DateLines
4551.1TOOK::STAMTue Feb 16 1993 14:0314
 From the information that you have presented, I am stumped as
to why you are not able to get a report.  If you note the note 4520.0
the report has been successfully generated (but not fully understood)
by others.  My first quick answer might be - is there any data in your
database (dtr) for the line QNA-0?  Can you enter the following command
to check to see if the data is being properly exported?   And further
investigation can be taken at that point.

$ manage/enter
mcc> show export node4 <your node name> line qna-0
mcc> show export node4 <your node name> circuit qna-0

			
4551.2also having a similar problemCOMICS::MISTRYWed Feb 17 1993 03:5513
Hi,

I couldn't get the line error reports to work. It always came back complaining
about EXP_CVR_STATISTICS not being defined, which i associated with something
wrong with the datatrieve routine being called to generate that particular
report. However, i'm also having a similar problem generating any sort of SNMP
report. The data is there and in the RdB database but the *.rpt file is 
always empty and i have exported everything i can think of. If you could shed 
some light on this, because i've come across similar entries to this in the 
notesfile without any satisfactory solutions.

Bipin.	

4551.3SHOW EXPORT dataSPANKY::SAWYERWed Feb 17 1993 10:1490
    Here is the data from the SHOW EXPORT command.
    It seems reasonable enough.
    
    MCC> show export node4 canam export target mcc_common:mcc_export.rdb
    
    Node4 canam
    AT 17-FEB-1993 09:55:14
    
    Exporting parameters are:
                            Exporting state = ACTIVE,
                                State since = 17-FEB-1993 09:54:39.13,
                              Export period = 0 00:05:00.00,
                                 Begin time = 15-FEB-1993 09:51:11.89,
                                   End time = 17-FEB-1993 12:00:00.24,
                              Export target = "MCC_COMMON:MCC_EXPORT.RDB",
                               Request time = 15-FEB-1993 09:51:11.89,
                               Requested by = "SYSTEM",
               Time of last successful poll = "NONE",
                 Number of successful polls = 0,
                   Time of last failed poll = "NONE",
                   Last poll failure reason = "N/A",
                     Number of failed polls = 0,
                           Last export time = "NONE",
                Time of last export failure = "NONE",
                 Last export failure reason = "N/A",
                  Number of export failures = 0,
                              Sequence name = "canam",
                    Initial sequence number = 1,
                    Current sequence number = 60
    MCC> show export node4 canam circuit qna-0 export target
    mcc_common:mcc_export.r
    db
    
    Node4 canam Circuit qna-0
    AT 17-FEB-1993 09:56:13
    
    Exporting parameters are:
                            Exporting state = SUSPENDED,
                                State since = 15-FEB-1993 16:05:21.68,
                              Export period = 0 00:05:00.00,
                                 Begin time = 15-FEB-1993 09:53:40.07,
                                   End time = 15-FEB-1993 16:10:00.57,
                              Export target = "MCC_COMMON:MCC_EXPORT.RDB",
                               Request time = 15-FEB-1993 09:53:40.07,
                               Requested by = "SYSTEM",
               Time of last successful poll = "15-FEB-1993 16:05:21.54",
                 Number of successful polls = 19,
                   Time of last failed poll = "NONE",
                   Last poll failure reason = "N/A",
                     Number of failed polls = 0,
                           Last export time = "15-FEB-1993 16:05:35.15",
                Time of last export failure = "NONE",
                 Last export failure reason = "N/A",
                  Number of export failures = 0,
                              Sequence name = "circ qna-0",
                    Initial sequence number = 1,
                    Current sequence number = 58
    MCC> show export node4 canam line qna-0 export target
    mcc_common:mcc_export.rdb
    
    Node4 canam Line qna-0
    AT 17-FEB-1993 09:58:07
    
    Exporting parameters are:
                            Exporting state = SUSPENDED,
                                State since = 15-FEB-1993 16:09:10.53,
                              Export period = 0 00:05:00.00,
                                 Begin time = 15-FEB-1993 09:52:41.79,
                                   End time = 15-FEB-1993 16:10:00.25,
                              Export target = "MCC_COMMON:MCC_EXPORT.RDB",
                               Request time = 15-FEB-1993 09:52:41.79,
                               Requested by = "SYSTEM",
               Time of last successful poll = "15-FEB-1993 16:09:10.42",
                 Number of successful polls = 20,
                   Time of last failed poll = "NONE",
                   Last poll failure reason = "N/A",
                     Number of failed polls = 0,
                           Last export time = "15-FEB-1993 16:09:23.23",
                Time of last export failure = "NONE",
                 Last export failure reason = "N/A",
                  Number of export failures = 0,
                              Sequence name = "line qna-0",
                    Initial sequence number = 1,
                    Current sequence number = 59
    MCC>
    
    From looking at this data, I would assume that there IS data being
    gathered for the line and the circuit QNA-0.
    
    - Rob
4551.4EXP_CVR_STATISTICSDORIOT::STAMWed Feb 17 1993 11:456
The functionality for the line error report has been slightly reduced
to work around the problem of EXP_CVR_STATISTICS not being defined.
Looking at the datatrieve code there is no reason for this error since
other routines perform the exact same thing.  So in the next version
of the reports package in the BMS V1.3.0 kit it should be fixed.
4551.5re: -2TOOK::STAMMon Feb 22 1993 16:5415
Yes, the data seems reasonable enough.  I am still looking 
through this and was hoping that someone else saw an error
in why no report was generated.

One thing that I noticed is that you are producing a Phase IV
line traffic summary report for an ONE HOUR time period.  The 
system realizes that there is data present because it would have
returned an error statement in the fashion of:

	... is not a readied source, collection, or list.

Since it didn't do this, my current thoughts are on the line of
what happens if there is nothing to report?  Will it produce a
blank report (ie a report with a header but no values) or will it
just not generate a report file?