Reserved transaction - P4205

[Guest]

Whilst trying to access a Sales Order record a user is getting the following
error:
CAUSE
The transaction is reserved for update by in application P4205 using key
58SO00100
RESOLUTION
To update, you must inquire again after has released the transaction


Same functionality works for other Sales Orders. The problem has been
attributed to PC hanging during use of system.

Message details supplied seem a little garbled to me, BUT has anyone seen
this and know how to resolve it. It has been suggested that there is some
lock on a table(s) in the database. I've had a look and can't find any
locks on tables F4201 or F4211. Not sure if these are correct tables in any
case. The database gets shutdown for COLD backup each night, but this
problem is still lurking!

Hope I'm not being too vague about above as this is new to me so any
pointers/help would be much appreciated

Sean O' Neill - [Digest Mode]
Organon (Ireland) Ltd.
B7333 - SP15.1 - NT W2K SP1 (NTFS) - Oracle 8.1.7
SANDBOX: None to date

 

[Donald_Mattes]

The lock is kept in File F00095. Clear out the record in question and it
will be available to others again. This happens when a PC locks up while in
a record and the lock doesn't get removed.


Don Mattes
JDE Financial Functional Analyst
McCook Metals LLC

 

 

[lessardj]

We ran across this during Xe implementation and our consultants used P00095
job (off G1753 menu) to unlock the reserved records. In our case, we were
sure there was no good reason for the reservation.



Xe, ES=AS/400 V4R5, CO=AS/400, Deployment=AS/400 INS Card, Thick & Citrix Clients