Tracy:

Your program is using the DBX procedures (DBXBEGIN etc), right?

I suspect, unfortunately, you have too many DBPUT's, DBDELETE's and
DBUPDATE's going on inside a DBXBEGIN. This is what is stalling the
transaction and causing all your DB entries to be DBXUNDO(ne) automatically.


Brian Donaldson.

On Tue, 21 Dec 2004 17:00:55 -0500, Johnson, Tracy
<[log in to unmask]> wrote:

>Even the programmer don't know.
>
>:JOB TLDBLD45,MANAGER.JL,QSDB45.
>Priority = CS; Inpri = 8; Time = UNLIMITED seconds.
>Job number = #j4114.
>TUE, DEC 21, 2004,  1:08 PM.
>HP3000  Release: C.75.00   User Version: C.75.00
>MPE/iX  HP31900 C.45.05  Copyright Hewlett-Packard 1987.
>All rights reserved.
>STREAMED BY BACKUP45,MANAGER.SYS (#J3636) ON LDEV# 10
>   STREAM DATE:   TUE, DEC 21, 2004,  1:08 PM
>[snip]
>:COMMENT   STREAM FILE TLDBLD45.PUB.XACTMAN
>:COMMENT     STREAMED BY BACKUP45,MANAGER.SYS,PUB (A JOB STREAM)
>:COMMENT     RUNNING PROGRAM MAIN.PUB.VESOFT
>:COMMENT     ON TUE, DEC 21, 2004,  1:08 PM
>:COMMENT
>:COMMENT *******************************************************
>:COMMENT *  J O B S T R E A M   D O C U M E N T A T I O N      *
>:RUN UT829.PUB.XACTMAN;PARM=300
>
>
>
>Load Transaction Logs into TLDB.QSDB##
>
>Database Number?
>
>Expected a Number.
>
>Database Number?
>
>Auto Load File: TR000372.MDATAB45
>
>
>**** STALLED TRANSACTION: EXCEEDED ACCUMULATED LOG DATA THRESHOLD
>WARNING ** One or more entries on the error stack have been overwritten.
>HPE Error Management message 205
>WARNING ** Message set 185, Error number 1030 was not found in the system
catalo
>g.
>Intrinsic layer; an access violation occurred.
>File System message 3
>Intrinsic layer; an access violation occurred.
>File System message 3
>Intrinsic layer; an access violation occurred.
>File System message 3
>Intrinsic layer; an access violation occurred.
>File System message 3
>Intrinsic layer; an access violation occurred.
>File System message 3
>Intrinsic layer; an access violation occurred.
>File System message 3
>Intrinsic layer; an access violation occurred.
>File System message 3
>Specifying the LONG MAPPED OPTION (item# 21) for this file type is invalid.
>(FILE OPEN ERROR -299)
>File System message 299
>Specifying the LONG MAPPED OPTION (item# 21) for this file type is invalid.
>(FILE OPEN ERROR -299)
>File System message 299
>Intrinsic layer; an access violation occurred.
>File System message 3
>Intrinsic layer; an access violation occurred.
>File System message 3
>Intrinsic layer; an access violation occurred.
>File System message 3
>Intrinsic layer; an access violation occurred.
>File System message 3
>Intrinsic layer; the operation could not be completed because a nonexistent
>file was specified.
>File System message 38
>FLABELINFO intrinsic.
>SUBSYS_INTRIN_ID message 25
>ABORT: UT829.PUB.XACTMAN
>NM SYS   a.00ff1f70 dbg_abort_trace+$28
>NM USER  1ef.00d5dd94 PROC'EXIT000445+$78
>NM PROG  a22.0000bab4 upd_tl_rec+$71c
>
>
>
>Program terminated in an error state. (CIERR 976)
>REMAINDER OF JOB FLUSHED.
>CPU sec. = 919.  elapsed min. = 20.  TUE, DEC 21, 2004,  1:28 PM.
>
>BT
>
>
>Tracy Johnson
>MSI Schaevitz Sensors
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *