Conference azur::mcc

1374.0. "DTR problems with reports package" by CLARID::HOFSTEE (Take a RISC, buy a VAX) Thu Aug 22 1991 04:48

I have been trying to get some reports out of the standard reports package,
but so far without any luck. I have setup DTR as explained in the manual,
and defined all procedures and record structures needed for PHASE IV reports.

After having added DEFINE CDD$DEFAULT MCC_EXPORT to my login.com (which is
btw not mentioned in the manual), I keep getting errors like:

Node4 line traffic report, last part of logfile from batch job shows:

$!
$define mcc$node1 "RTWO"
$define mcc$line1 "ALL"
$define mcc$date1  "19-AUG-1991 09:00:00.00"
$define mcc$date2  "21-AUG-1991 12:00:00.00"
$define mcc$report_file  "RTWO_TRAFFIC.RPT"
$datatrieve
VAX DATATRIEVE V5.1<CR><LF>Digital Query and Report System<CR><LF>Type HELP for
:node4_line_traffic_rpt
"MCC_NODE4_LINE" 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.
exit
$exit
  SYSTEM       job terminated at 21-AUG-1991 17:09:37.64


node4 circuit hourly graph, logfile shows:

$ 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 circt_id_tmp circt_id_tmp.00000101211811
$ define circt_graph circt_graph.00000101211811
$ create  NODE_HOLD00000101211811.grm
$!* The following line is intentionally kept blank.

$ define mcc$node1 "RTWO"
$ define mcc$CIRCUIT_ID1 "SVA-0"
$ define mcc$date1 "20-AUG-1991 14:00:00.00"
$ define mcc$date2 "21-AUG-1991 10:00:00.00"
$ define mcc$report_file "RTWO_TRAFFIC.RPT"
$ datatrieve
VAX DATATRIEVE V5.1<CR><LF>Digital Query and Report System<CR><LF>Type HELP for
 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
"MCC_NODE4_CIRCUIT" is not a readied source, collection, or list.
if CIRCUIT_ID_HOLD NE "ALL" THEN Find current with circuit_hold1 = CIRCUIT_ID_H
"CURRENT" is not a readied source, collection, or list.
 Find   current   with time_STAMP between DATE1_HOLD and DATE2_HOLD
"CURRENT" is not a readied source, collection, or list.
define file for circuit_graph
ready  circuit_graph write
circuit_graph = current
"CIRCUIT_GRAPH" is undefined or used out of context.
reduce current to circuit
REDUCE CURRENT TO CIRCUIT
               ^
Expected end of statement, encountered "TO".
define file for circuit_id_temp
ready  circuit_id_temp write
circuit_id_temp = current
"CIRCUIT_ID_TEMP" is undefined or used out of context.
EXIT
$open/read/error=file_open_error infile circt_id_tmp.00000101211811
$ read/end_of_file=normal_exit  infile circuit_id_rec
$ normal_exit:
$ rename node_hold00000101211811.grm   RTWO_TRAFFIC.RPT
$ delete/nocon circt_id_tmp.00000101211811.*
$ delete/nocon circt_graph.00000101211811.*
$ exit
  SYSTEM       job terminated at 21-AUG-1991 18:12:04.60
<CR><LF>  Accounting information:
  Buffered I/O count:             210         Peak working set size:    3659

      

Thanks for any clarification

Timo

PS: I have tried it also with node adress , wild card and all other combinations
but always with the same results.

Found the problem. Forgot to export the line data. However, it would have
been nice if the procedure would have told me. Now produced a node report,
and that finishes ok. There is only one slight problem......there is nothing
in the report.....

hmmmmm....


Timo

re .0


After having added DEFINE CDD$DEFAULT MCC_EXPORT to my login.com (which is
btw not mentioned in the manual), ....

>> This is mentioned in the PA Use Manual under the section
>> "Initializing the Reports Package".

did you clarify or find your problem with the empty report?