qtp/quiz exec: empty run but no error on exit
Koizar Astrid (UniCredit Business Integrated Solutions Austria)
Astrid.Koizar at unicredit.at
Thu Jan 26 03:49:58 CST 2017
System: HP-UX uszcsph0 B.11.31 U ia64 0024154386 unlimited-user license,
PowerHouse(R) 4GL 8.43G - QTP
The following (part of) script runs for years now without problems.
Function run executes and function on_error checks the status of the command; both functions included below
Last Friday we executed the script and noticed that powerhouse exited without error code but did not run the the qtp at all; same happened with some quiz reports.
Script ====================================================================
# ***********************************************************
run qtp <<EOF
EXEC `get_ph_path arf780pp.qtc`
EXIT
EOF
on_error stop
# ***********************************************************
run qtp <<EOF
EXEC `get_ph_path vcy791pp.qtc` PROCESS LIMIT 1000000
EXIT
EOF
on_error stop
Output on logfile - no execution of QTPs =========================================
run qtp
PowerHouse(R) 4GL 8.43G - QTP
(C) Copyright UNICOM Systems, Inc. 1982-2014
run qtp
PowerHouse(R) 4GL 8.43G - QTP
(C) Copyright UNICOM Systems, Inc. 1982-2014
Normal output on logfile from this script ========================================
run qtp
PowerHouse(R) 4GL 8.43G - QTP
(C) Copyright UNICOM Systems, Inc. 1982-2014
> EXEC /prod/bacs/prp/abs/phbin/arf780pp.qtc
MARKET PRICES HISTORY DELETION
^L21 JAN 2017 01:04 ABS Dictionary (Y2K) as at 25/5/1998 PAGE
1
Run: arf780pp
Request: GET-SYS-DATE
Executing request GET-SYS-DATE ...
Records read:
MW-LGCL-DT-M 1
Transactions processed: 1
^L21 JAN 2017 01:04 ABS Dictionary (Y2K) as at 25/5/1998 PAGE
1
Run: arf780pp
Request: WRITE-SUBFILE
Executing request WRITE-SUBFILE ...
Records read:
SE-MKPR-D 373,224
Transactions processed: 346,151
Records processed: Added Updated Unchanged Deleted
ARF780S1 2,236 0 0 0
^L21 JAN 2017 01:04 ABS Dictionary (Y2K) as at 25/5/1998 PAGE
1
Run: arf780pp
Request: DEL-MKPR-D
Executing request DEL-MKPR-D ...
Records read:
ARF780S1 2,236
MKPR-SCTY 370,092
MKPR-KEY 1,434
Transactions processed: 7,117
Records processed: Added Updated Unchanged Deleted
MKPR-SCTY 0 0 0 7,117
Finished.
^L> EXIT
run qtp
PowerHouse(R) 4GL 8.43G - QTP
(C) Copyright UNICOM Systems, Inc. 1982-2014
> EXEC /prod/bacs/cee/abs/phbin/vcy791pp.qtc PROCESS LIMIT 1000000
SEED DELETION
^L21 JAN 2017 01:05 ABS Dictionary (Y2K) as at 25/5/1998 PAGE
1
Run: vcy791pp
Request: GET-RUN-DATE
Executing request GET-RUN-DATE ...
Records read:
MW-LGCL-DT-M 1
RD-BRANCH-M 1
Transactions processed: 1
^L21 JAN 2017 01:05 ABS Dictionary (Y2K) as at 25/5/1998 PAGE
1
Run: vcy791pp
Request: DEL-CEE-SEED
Executing request DEL-CEE-SEED ...
Records read:
RD-CEE-SEED-D 236,428
Transactions processed: 49,374
Records processed: Added Updated Unchanged Deleted
RD-CEE-SEED-D 0 0 0 49,374
^L21 JAN 2017 01:07 ABS Dictionary (Y2K) as at 25/5/1998 PAGE
1
Run: vcy791pp
Request: DEL-AUDIT-SEED
Executing request DEL-AUDIT-SEED ...
Records read:
RD-AUDIT-SEED-D 26,934
Transactions processed: 6,148
Records processed: Added Updated Unchanged Deleted
RD-AUDIT-SEED-D 0 0 0 6,148
^L21 JAN 2017 01:07 ABS Dictionary (Y2K) as at 25/5/1998 PAGE
1
Run: vcy791pp
Request: DEL-CMO-SEED
Executing request DEL-CMO-SEED ...
Records read:
RD-CMO-SEED-D 208,611
Transactions processed: 42,725
Records processed: Added Updated Unchanged Deleted
RD-CMO-SEED-D 0 0 0 42,725
^L21 JAN 2017 01:08 ABS Dictionary (Y2K) as at 25/5/1998 PAGE
1
Run: vcy791pp
Request: DEL-CORE-SEED
Executing request DEL-CORE-SEED ...
Records read:
RD-CORE-SEED-D 8,985
Transactions processed: 2,273
Records processed: Added Updated Unchanged Deleted
RD-CORE-SEED-D 0 0 0 2,273
^L21 JAN 2017 01:08 ABS Dictionary (Y2K) as at 25/5/1998 PAGE
1
Run: vcy791pp
Request: DEL-MQSOUT-SEED
Executing request DEL-MQSOUT-SEED ...
Records read:
RD-MQSOUT-SEED-D 0
Transactions processed: 0
Records processed: Added Updated Unchanged Deleted
RD-MQSOUT-SEED-D 0 0 0 0
Finished.
^L> EXIT
Functions used in the script: run/on_error ================================================
############################################################
# run
# run's a program. Program start and termination is logged in
# the common job.log.
############################################################
run() {
if [ "$DEBUG" -ge "1" ]
then
echo "DEBUG: jump into function run"
set -x
fi
write_log "RS" "run-start::$*"
echo "run $*" 1>&2
# reload jobwide environment variables
[ -r $BACS_TEMP/jobenv.sh ] && . $BACS_TEMP/jobenv.sh
eval "$*"
export STATUS=$?
write_log "RE" "run-end:status=$STATUS:$*"
# reload jobwide environment variables
[ -r $BACS_TEMP/jobenv.sh ] && . $BACS_TEMP/jobenv.sh
return $STATUS
}
############################################################
# on_error stop|continue|warnstop
#
# stop's or continues the job
############################################################
on_error() {
if [ "$DEBUG" -ge "1" ]
then
echo "DEBUG: jump into function on_error"
set -x
fi
if [ "$STATUS" -ne 0 ]; then
case "$1" in
stop | Stop | STOP)
batch_gen_msg "BA" "batch-end_with_error" "ERROR" "CRITICAL" "status=$STATUS:job $0 abort, logfile=$LOGFILE"
error
;;
warnstop | Warnstop | WARNSTOP)
batch_gen_msg "BE" "batch-end_with_warning" "ERROR" "WARNING" "status=$STATUS:job $0 abort, logfile=$LOGFILE"
error
;;
continue | Continue | CONTINUE)
batch_gen_msg "TR" "batch-continue" "OK" "WARNING" "status=$STATUS:job $0 end, logfile=$LOGFILE"
esac
fi
}
############################################################
Best regards
------------------------------------------------------------------------------------
BACS-Team
IT Analysis and Programming
04670 BACS
UniCredit Business Integrated Solutions Austria GmbH
Julius-Tandler-Platz 3
A-1090 Vienna
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20170126/3b434ce5/attachment-0001.htm>
More information about the powerh-l
mailing list