[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| 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 |
5400.0. "Exporting SCRIPT AM data problems" by NEWOA::EVANS_M () Wed Jul 28 1993 10:52
MCC 1.3 SSB
V4000-60
I am experiencing problems with exporting of data from the SCRIPT access
module.
I have generated a script whick polls a LANbridge 100,150 and works out the
increase in the error counters since the last poll. I need to export this data
to RDB to produse a regular graph for a customer.
The script run fine interactivly from the Iconic Map and the FCL but when I
export the data I get Zeros in the database.
The script takes about 20 seconds to run and I have tries various timeouts up
to 10 minutes.
To prove if any data can be exported I have produced the output text to a
separate file and run a test script to type the data out. This runs
interactivly in seconds. Exporting this data is sometimes sucessful but mostly
returns nulls in the database.
Has anyone seen this ?, exported scripts ok ?
Any help would be gratefully accepted.
Thanks Mat Evans
PS.
Below is the output I get. !!
< The script I need to run that exports zeros >
MCC> show script .LANBRIDGE BRIDGE NMSLB1 all char
Script SCOOBY_NS:.LANBRIDGE bridge NMSLB1
AT 28-JUL-1993 14:40:26 Characteristics
Examination of attributes show:
Description = "Works out the LANbridge statistics
since last poll"
Command = "@mcc_scripts:mcc_bridge nmslb1"
Timeout = 0 00:10:00.00
MCC> show script .LANBRIDGE BRIDGE NMSLB1 all status
Script SCOOBY_NS:.LANBRIDGE bridge NMSLB1
AT 28-JUL-1993 14:21:41 Status
Examination of attributes show:
Command Executed = "@mcc_scripts:mcc_bridge nmslb1"
LAN Traffic Line 1 = 60377
LAN Traffic Line 2 = 15250
Bad Frames Line 1 = 0
Transmit Frames Lost Line 1 = 0
Lifetime Exceeded Frames Line 1 = 0
Receice Frames Lost Line 1 = 0
Bad Frames Line 2 = 0
Transmit Frames Lost Line 2 = 0
Lifetime Exceeded Frames Line 2 = 0
Receice Frames Lost Line 2 = 0
Result in RDB
$ mcr sql$
declare database file mcc_export;
select time_stamp,LAN_TRAFFIC_LINE_1,LAN_TRAFFIC_LIne_2,-
RECEICE_FRAMES_LOST_LINE_1,RECEICE_FRAMES_LOST_LINE_2, -
LIFETIME_EXCEEDED_FRAMES_LINE_1,LIFETIME_EXCEEDED_FRAMES_LINE_2, -
TRANSMIT_FRAMES_LOST_LINE_1,TRANSMIT_FRAMES_LOST_LINE_2, -
BAD_FRAMES_LINE_1,BAD_FRAMES_LINE_2, -
from mcc_script_bridge;
TIME_STAMP LAN_TRAFFIC_LINE_1 LAN_TRAFFIC_LINE_2
RECEICE_FRAMES_LOST_LINE_1 RECEICE_FRAMES_LOST_LINE_2
LIFETIME_EXCEEDED_FRAMES_LINE_1 LIFETIME_EXCEEDED_FRAMES_LINE_2
TRANSMIT_FRAMES_LOST_LINE_1 TRANSMIT_FRAMES_LOST_LINE_2
BAD_FRAMES_LINE_1 BAD_FRAMES_LINE_2
28-JUL-1993 14:26:51.15 0 0
0 0
0 0
0 0
0 0
28-JUL-1993 14:31:51.67 0 0
0 0
0 0
0 0
0 0
< Here is the test script that runs faster >
$ type test.com
NMSLB1 2100 2200 1 2 3 4 5 6 7 8
MCC> show script test bridge test all char
Script SCOOBY_NS:.test bridge test
AT 28-JUL-1993 14:41:35 Characteristics
Examination of attributes show:
Command = "type
$2$DKA100:[MCC.MCC_SCRIPTS]TEST.COM"
Timeout = 0 00:05:00.00
MCC> show script test bridge test all status
Script SCOOBY_NS:.test bridge NMSLB1
AT 28-JUL-1993 14:04:27 Status
Examination of attributes show:
Command Executed = "type
$2$DKA100:[MCC.MCC_SCRIPTS]TEST.COM"
LAN Traffic Line 1 = 2100
LAN Traffic Line 2 = 2200
Bad Frames Line 1 = 1
Transmit Frames Lost Line 1 = 2
Lifetime Exceeded Frames Line 1 = 3
Receice Frames Lost Line 1 = 4
Bad Frames Line 2 = 5
Transmit Frames Lost Line 2 = 6
Lifetime Exceeded Frames Line 2 = 7
Receice Frames Lost Line 2 = 8
$ mcr sql$
declare database file mcc_export;
select time_stamp,LAN_TRAFFIC_LINE_1,LAN_TRAFFIC_LIne_2,-
RECEICE_FRAMES_LOST_LINE_1,RECEICE_FRAMES_LOST_LINE_2, -
LIFETIME_EXCEEDED_FRAMES_LINE_1,LIFETIME_EXCEEDED_FRAMES_LINE_2, -
TRANSMIT_FRAMES_LOST_LINE_1,TRANSMIT_FRAMES_LOST_LINE_2, -
BAD_FRAMES_LINE_1,BAD_FRAMES_LINE_2, -
from mcc_script_bridge;
TIME_STAMP LAN_TRAFFIC_LINE_1 LAN_TRAFFIC_LINE_2
RECEICE_FRAMES_LOST_LINE_1 RECEICE_FRAMES_LOST_LINE_2
LIFETIME_EXCEEDED_FRAMES_LINE_1 LIFETIME_EXCEEDED_FRAMES_LINE_2
TRANSMIT_FRAMES_LOST_LINE_1 TRANSMIT_FRAMES_LOST_LINE_2
BAD_FRAMES_LINE_1 BAD_FRAMES_LINE_2
28-JUL-1993 13:26:51.15 0 0
NULL NULL
NULL NULL
NULL NULL
0 NULL
28-JUL-1993 13:31:51.67 0 0
NULL NULL
NULL NULL
NULL NULL
NULL NULL
28-JUL-1993 13:36:51.67 2100 2200
4 8
3 7
2 6
1 5
28-JUL-1993 13:41:51.68 0 NULL
NULL NULL
NULL NULL
NULL NULL
NULL NULL
28-JUL-1993 13:46:51.71 0 0
NULL NULL
NULL NULL
NULL NULL
0 NULL
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 5400.1 | You experience perhaps similar problems | KETJE::PACCO | Gallia divisa est in partes tres | Wed Jul 28 1993 14:14 | 3 |
| Have a look at note 5327. You problem could be related.
Dominique.
|
| 5400.2 | HELP........please....... | KERNEL::DAVIES | | Wed Aug 11 1993 09:59 | 14 |
| Hi,
My name is Phil Davies and work in the Comms TSC supporting MCC,
amongst other things. Mathew has logged a call here with the TSC and
I'm the owner of the above call.
Is there anyone in engineering who supports the Script am that can
offer any assistance on this call. If not, I'm going to have to CLD it
as the problem needs fixing.
Thanks.
Phil.
|