ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> S0_G and SO-E record lock what files to fix?
http://www.istechforum.com/YaBB.pl?num=1188580603

Message started by lmk223a on 08/31/07 at 10:16:43

Title: S0_G and SO-E record lock what files to fix?
Post by 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.

:-X Unfortunately, our systems guru is on vacation at the time, and I am trying to resolve this issue that occured today at month end.

Title: Re: S0_G and SO-E record lock what files to fix?
Post by kkmfg on 08/31/07 at 11:26:35

lmk223a wrote:

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.