Consultor Eletrônico



Kbase P17119: Why does the client hold the Transaction State 'Begin' for more than a minute?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   12/19/2008
Status: Verified

GOAL:

Why would a transaction be in the BEGIN Transaction State for more than a minute?

GOAL:

What the BEGIN or ALLOCATED transaction state mean?

FACT(s) (Environment):

All Supported Operating Systems
OpenEdge 10.x

FIX:

When a transaction is started, Progress doesn't create any bi notes for it until that transaction actually does something. In the meantime, it is in the BEGIN or ALLOCATED state. If it never does anything, both the transaction begin note and the transaction end note will be optimized away when the transaction ends.

Creating (or updating) a record may not cause the state to change right away because the create (or update) is delayed by the client as long as possible before it tells the database about it.