[U2] Invalid Lock Sequence Write Errors

[Amy Cook]

I'm getting the following error that's bailing me out of a UniData
(version 6.0.9) subroutine. Because I thought it might be corruption, I
ran guide, found no corruption, but a little undersized. I created a new
file at correct modulo, then copied all records from original file over,
then renamed new file to INVWHS. All records copied over (did a count on
both). Ran guide on the new file and everything was as it should be. But
I'm still getting the errors. So...I went in and verified I could edit
the individual record, file it, even copy to new record name and delete
original, and that's all working.





In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 UPL
error = 102 : Invalid lock sequence

In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115
Lockname (3

76257 1073807361) RX -- 13359104

PT-fid -- (376257 1073807361) IX

R(13359104)--[1 0] 703(X 1)



In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 upl
lock er

ror(102).

In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 1:
error in

U_dyn_hash for file 'INVWHS', key '46483*195', number=6522

In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115
Fatal error

: WRITE error



This is not just one record (hit about 20 so far), but here's the syntax
below:

The syntax at line 115 is WRITE ITEM.WH ON FILE.WH,WH.KEY.

The record was locked about 10 lines earlier...
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Invalid Lock Sequence Write Errors

[Wally Terhune]

re:
In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 UPL
error = 102 : Invalid lock sequence

UniData physical lock manager (eg group locks - not record locks per se).
I would work with your UniData support provider - Epicor? For this sort of
problem isolation, likely a better route than this forum.
Indexes on the file? virtual field index update sequence (Tfilename - back
to the same record in the same file?)
Triggers?
full UniData version? eg 7.1.16
platform?
udtconfig settings?
What changed?
udtdiag dump as close to the time the problem is occuring might help (lock
table dump is part of that).
small test case that demonstrates the error?

happy hunting.


 Wally Terhune   Mark your
 U2 Support Architectcalendar!
 IBM Information Management Software
 Tel: (303) 773-7969 T/L
 656-7969
 Mobile: (303) 807-6222
 Email: [EMAIL PROTECTED]
 http://www.ibm.com/software/data/u2/support

[demime 1.01d removed an attachment of type image/jpeg which had a name of 
23547588.jpg]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/