Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0011608Openbravo ERP09. Financial managementpublic2009-12-02 13:382009-12-03 12:16
arunkumar 
eduardo_Argal 
immediatemajorhave not tried
closedfixed 
5
2.35 
2.35MP16 
No
Core
No
0011608: Unable to post the document - Oracle Database gets locked when accounting process is running
When We try to post any document in oracle context the posting process is waiting for request for a long time.It never ends up.The reason is Oracle Database gets locked when accounting process is running
Log in as Openbravo/openbravo and changed the role to Openbravo Admin.
Go to Sales Management -> Transactions -> Sales Invoice
Click New select Transaction Document: AR Invoice
Select the business partner
Save the record.
Go to Lines tab.
Select the product.Save it.
Move to Lines and verify:
Go back to Header and click Complete
Click Post button (Make sure the accounting period is open).

The post request never ends up.The reason is Oracle Database gets locked when accounting process is running. Please refer the screenshot.
No tags attached.
blocks defect 0011606 closed rafaroda Unable to post the document - Oracle Database gets locked when accounting process is running 
Issue History
2009-12-02 13:42psarobeTypedefect => backport
2009-12-02 13:42psarobefix_in_branchpi => 2.3x
2009-12-02 13:44psarobeAssigned Torafaroda => eduardo_Argal
2009-12-03 11:21jpabloaeNote Added: 0022392
2009-12-03 11:21jpabloaeStatusscheduled => resolved
2009-12-03 11:21jpabloaeFixed in SCM revision => http://code.openbravo.com/erp/stable/2.3x/rev/68154b7d45807078de19b21bc517584cd35b4ab1 [^]
2009-12-03 11:21jpabloaeResolutionopen => fixed
2009-12-03 12:16arunkumarNote Added: 0022400
2009-12-03 12:16arunkumarStatusresolved => closed
2009-12-03 12:16arunkumarFixed in Version => 2.35MP16

Notes
(0022392)
jpabloae   
2009-12-03 11:21   
From issue 0011606:

Repository: erp/stable/2.3x
Changeset: 68154b7d45807078de19b21bc517584cd35b4ab1
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Wed Dec 02 18:35:05 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.3x/rev/68154b7d45807078de19b21bc517584cd35b4ab1 [^] [^]

fixes bug 0011606: Unable to post the document - Oracle Database gets locked when accounting process is running

---
M src/org/openbravo/erpCommon/ad_forms/AcctServer.java
M src/org/openbravo/erpCommon/ad_forms/AcctServer_data.xsql
---
(0022400)
arunkumar   
2009-12-03 12:16   
Tested & working