Quote from lmk223a on 08/31/07 at 10:16:43:I searched for record lock in Sales and System Manager and could not find an answer to this issue.
When a sales invoice is partially posted due to record lock in SO-G when another user is processing releases in SO-E, what files need to be fixed in Maintain Database?
My 2nd error message stated BKARCUST is locked, so that must be one file.
Unfortunately, our systems guru is on vacation at the time, and I am trying to resolve this issue that occured today at month end.
Hopefully this sorry situation will be fixed soon. If the whole postgresql thing works then there will be two separate things that will fix this sort of problem:
1. Transactions - No more partial posting. It's either posted or it isn't. It should have been like that from the get go.
2. MVCC (multi version control) - Basically allows transactions to see their own separate version of the database and tries to reconcile them. This lessens the # of record locks that actually happen.
Pages: 1
S0_G and SO-E record lock what files to fix? (Read 260 times)
