The stalled transaction error continues:

 **** STALLED TRANSACTION: EXCEEDED ACCUMULATED TIME THRESHOLD

 WARNING ** Message set 185, Error number 1030 was not found in the syste
 m catalog.

 A key value was not found in the KSAM file.

 File System message 1055
 ABORT: INDEXLOD.xxxxxxxx.yyyyyyyy
 NM SYS   a.010061ec dbg_abort_trace+$28
 NM USER  ba.00ed04cc PROC'EXIT000443+$78
 NM PUB   325.000903c4 addindex$001$+$b24
(1613/1618) Continue?
 NM PROG  32b.0000e61c _start+$1ae4

 Program terminated in an error state. (CIERR 976)
 REMAINDER OF JOB FLUSHED.
 CPU sec. = 12884.  elapsed min. = 343.  WED, JAN  5, 2005,  7:42 PM.

KSAM file? What KSAM file? My app is DBPUTing entries to a TurboIMAGE
data base and isn't doing anything with KSAM(XL) files at all.

Anyone got any ideas?

TIA,
Brian.

On Mon, 3 Jan 2005 21:28:28 -0500, Brian Donaldson <[log in to unmask]>
wrote:

>Tracy:
>
>A program I have been developing has encountered the same problem as yours.
>
>All because I had too many DBDELETE's and DBPUT's inside a single DBXBEGIN.
>
>Displays here:
>
> Indices Deleted=>+000000228<
> Indices Added  =>+000000228<
> Will delete indices for catalog id=>83061-2             <
> Indices Deleted=>+000000161<
> Indices Added  =>+000000161<
> Will delete indices for catalog id=>83092-2             <
>
> **** 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 1025 was not found in the syste
> m catalog.
>
>
> ABORT: INDEXLOD.xxxxxxxx.yyyyyyyy
> NM SYS   a.010061ec dbg_abort_trace+$28
> NM USER  bb.00ee77c8 PROC'EXIT000546+$70
> NM PUB   d6.000ad250 index_delete+$78c
> NM PROG  dc.0000d55c _start+$a94
>
>
>So, it's back to the drawing board (slightly)
>
>
>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 *

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