LISTSERV - HP3000-L Archives

HP3000-L Archives

January 2005, Week 1

HP3000-L@RAVEN.UTC.EDU

	LISTSERV Archives
	HP3000-L Home
	HP3000-L January 2005, Week 1

	Log In
	Register

	Subscribe or Unsubscribe

	Search Archives
Options:	Use Monospaced Font Show Text Part by Default Show All Mail Headers
Message:	[<< First] [< Prev] [Next >] [Last >>]
Topic:	[<< First] [< Prev] [Next >] [Last >>]
Author:	[<< First] [< Prev] [Next >] [Last >>]
Subject:	Re: Odd Error Custom App
From:	Brian Donaldson <[log in to unmask]>
Reply To:	Brian Donaldson <[log in to unmask]>
Date:	Fri, 7 Jan 2005 22:46:56 -0500
Content-Type:	text/plain
Parts/Attachments:	text/plain (225 lines)
Since my last posting on this problem, it has happened again:

 Total Processed > Max Allowed=>+000010491>+000010000<
 Reset DBX Here...
  72% done
  73% done

 **** STALLED TRANSACTION: EXCEEDED ACCUMULATED TIME THRESHOLD

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

 Type manager; the storage management START WRITE failed.

 File System message 997

 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   2c5.0001ac10 addindex$001$+$24d0
 NM PROG  2e6.0000e658 _start+$1b20

 Program terminated in an error state. (CIERR 976)
 REMAINDER OF JOB FLUSHED.
 CPU sec. = 12807.  elapsed min. = 388.  FRI, JAN  7, 2005,  6:36 PM.


My data base uses Btrees, no 3rd party TPI such as Omnidex or Superdex.
Every 10,000 records I call DBXEND and then DBXBEGIN to reset the DBX stuff
so that (hopefully) the stalled transaction error won't happen.

Maybe I should DBCLOSE the base and do DBOPEN again??

Any ideas anyone?

TIA,
Brian.
On Wed, 5 Jan 2005 23:13:28 -0500, Brian Donaldson <[log in to unmask]>
wrote:

>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 *

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