[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

2247.0. "Exporter function problem with mcc-reports" by F18::ROBERT () Fri Jan 31 1992 11:30

    I have been running the new version of DECmcc 1.2.4 for a week, I
    wanted to run some of the mcc reports to get some output.
    
    I am running into two problems, first I run anyone of the reports
    1-9 and I get the following error when running
    node4_line_bandwidth_rpt:
    
    "EXP_CVR_STATISTICS" is undefined or used out of context.
    
    I went into dtr and did a show all and did not find this defined.
    I stored all of the definitions via datatrieve. in the reports use
    document. 
    
    Another problem I am having is with the graphing function, I get the
    following in my .log file, daily graph, 
    
    
     set verify
     Ready MCC_EXPORT shared read
     DECLARE NODE_HOLD PIC X(7).
     DECLARE CIRCUIT_ID_HOLD PIC X(16).
     DECLARE CIRCUIT_HOLD1 COMPUTED BY FN$UPCASE(CIRCUIT).
     DECLARE DATE1_HOLD USAGE DATE.
     DECLARE DATE2_HOLD USAGE DATE.
     NODE_HOLD = FN$TRANS_LOG("MCC$NODE1")
     CIRCUIT_ID_HOLD = FN$TRANS_LOG("MCC$CIRCUIT_ID1")
     DATE1_HOLD = FN$DATE(FN$TRANS_LOG("MCC$DATE1"))
     DATE2_HOLD = FN$DATE(FN$TRANS_LOG("MCC$DATE2"))
      Find  MCC_NODE4_circuit with NODE4 = NODE_HOLD
    [181 records found]
    if CIRCUIT_ID_HOLD NE "ALL" THEN Find current with circuit_hold1 =
    CIRCUIT_ID_HO
    LD
     Find   current   with time_STAMP between DATE1_HOLD and DATE2_HOLD
    [0 records found]
    define file for circuit_graph
    ready  circuit_graph write
    
    This is on a database that is new, started as of this week, if I use
    some dates that are past, i.e. 1-dec-1991 - 10-dec-1991 it works fine!
    
    Any ideas? Appreciate the help. The new graphs work great on old data.
    They look very good. Good Job.
    
    Thanks dAve
    
T.RTitleUserPersonal
Name
DateLines
2247.1QAR 2245TOOK::MINTZErik Mintz, DECmcc DevelopmentFri Jan 31 1992 11:452
QAR 2245 in MCC_INTERNAL

2247.2Do not use RDB files created by MCC V1.1TOOK::SHMUYLOVICHFri Jan 31 1992 13:4317
	Rdb schema in MCC V1.2 is different from V1.1.

	You can not export data using MCC V1.2 into Rdb file created by
     MCC V1.1. Also you can not run Reports from V1.2 against Rdb files
     created in V1.1.

	Is there a reason you want to keep an old(from V1.1) and new 
     (from V1.2) data together in the same Rdb file or you just ran into 
     this problem by accident?

	If you think that it's very important to make data exported in
     V1.1 and in V1.2 compatible we'll try to provide a conversion 
     procedure. 

	SAm
    
2247.3problem with history/export/reportsNYFDIN::SAMBAMURTYRajaTue Feb 04 1992 16:4526
    I too am running T1.2 on a VS3100/16Meg/VMS5.4-3 and have not been able
    to produce any DTR reports. I did all the steps that are outlined in
    the manual.
    
    1) I start the background job for record with the domain name as the
    parameter, start to record attributes (counters) on a given router (line, 
    circ & node).
    
    2) after 24 hrs, I start the exporter in the background (I have defined
    MCC_EXPORT in DTR, have my CDD$DEFAULT pointing to my CDD dir) with the
    name of the rdb file as a parameter. Then I start to "record". The rdb
    file gets created (the size is about 3100 blocks for the .rdb file). At
    this point I run the mcc_rpts file to generate hourly circuit info,
    line & node traffic info and all the 3 files get created but there is
    nothing in the files (they are all 0/0 size).
    
    I would appreciate if someone can point me in the right direction (if
    you think I am doing something wrong). Also, I can't seem to delete the
    .rdb files from the V1.1 of MCC. (I try 
    RDO> delete database path 'blah'.
    and I get back something about having to invoke a database first.
    
    Is this facility known to work in theis version ? Any help would be 
    appreciated. Thanks
    
    Raja
2247.4NYFDIN::SAMBAMURTYRajaThu Feb 06 1992 13:1714
    I still haven't figured out as to why this doesn't work. Someone told
    me to key the node address instead of the node name and it still
    doesn't seem to work. I know the export works and the DB is getting
    populated (I did a 
     
    RDO> for j in mcc_node4_circuit
    cont> print j.*
    cont> end_for
    
    )
    
    and prints out fields and their stored values. Any help would be
    appreciated. Thanks.
    Raja
2247.5some help coming, hopefullyTOOK::CALLANDERMCC = My Constant CompanionThu Feb 20 1992 19:512
    your request for help has been forwarded to Sam
    he should be getting back to you.
2247.6See note 2315.*TOOK::ANWARUDDINAnwarFri Feb 21 1992 09:431
Note 2315.* answers the questions in .4
2247.7NYFDIN::SAMBAMURTYRajaFri Feb 21 1992 11:0616
� Note 2315.* answers the questions in .4
    
    Indeed, it did and they work better now. There are still a lot problems
    with the reports. (1) One of the most glaring ones is, the word out is
    capitalized in one place and not in the other (I know it is trivial,
    but that was one of the first things the customer noticed). (2)
    Sometimes I see that circuit syn-0 was polled n times and was
    successful n-2 (or3) times. Why would the polling fail (both the mcc
    station and the router are on the same ethernet and neither of them
    went down during the polling period) ? (3) the peak times/dates as
    reported by the reports is still a suspect (and at times inconsistent,
    i.e. sometimes it prints just the date and other times, date/time
    combo). And last (but not least), the exporter is very, very slow (as I
    have pointed out in another note). Thanks for your time.
    
    Raja
2247.8TOOK::ANWARUDDINAnwarTue Mar 24 1992 09:4143
� Note 2315.* answers the questions in .4
    
    Indeed, it did and they work better now. There are still a lot problems
    with the reports. (1) One of the most glaring ones is, the word out is
    capitalized in one place and not in the other (I know it is trivial,
    but that was one of the first things the customer noticed). 

************ OK

    (2) Sometimes I see that circuit syn-0 was polled n times and was
    successful n-2 (or3) times. Why would the polling fail (both the mcc
    station and the router are on the same ethernet and neither of them
    went down during the polling period) ? 

************ This means that the Exporter got back an exception from a MM.
************ You can tell by looking at two fields "exp_cvr_<partition_name>"
************ & "exp_cvr1_<partition_name>" in the tables. These fields are
************ in every partition. The values that are valid for the first 
************ field are:
************	1 = reposponse (success)
************    2 = mcc_error
************    3 = Common Exception
************    4 = Specialized Exception
************ The field "exp_cvr1_<partition_name>" will contain one of the following:
************	reposponse id , if successful (value 1)
************    error code (defined in mcc_msg.h)
************    exception code in case of Common Exception or a Specialized exception.
************ The code is looked up from the data dictionary.

************ If both fields have the value 1, the poll succeeded. Otherwise the poll 
************ failed.

    (3) the peak times/dates as
    reported by the reports is still a suspect (and at times inconsistent,
    i.e. sometimes it prints just the date and other times, date/time
    combo). And last (but not least), the exporter is very, very slow (as I
    have pointed out in another note). Thanks for your time.

*********** Regarding the peak dates/times, I believe Meera spoke to you.
    
    Raja