Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011607Openbravo ERP09. Financial managementpublic2009-12-02 13:382010-01-27 12:30
Reporterarunkumar 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.35 
Target VersionFixed in Version2.40MP12 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011607: Unable to post the document - Oracle Database gets locked when accounting process is running
DescriptionWhen 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
Steps To ReproduceLog 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0011606 closed rafaroda Unable to post the document - Oracle Database gets locked when accounting process is running 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-12-02 13:39arunkumarTypedefect => backport
2009-12-02 13:39arunkumarfix_in_branch => 2.40
2009-12-02 13:44psarobeAssigned Torafaroda => eduardo_Argal
2009-12-14 13:01hgbotCheckin
2009-12-14 13:01hgbotNote Added: 0022751
2009-12-14 13:01hgbotStatusscheduled => resolved
2009-12-14 13:01hgbotResolutionopen => fixed
2009-12-14 13:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/1a91cca63722d39a89e3180d224c803d219d3373 [^]
2010-01-27 12:30arunkumarNote Added: 0023820
2010-01-27 12:30arunkumarStatusresolved => closed
2010-01-27 12:30arunkumarFixed in Version => 2.40MP12

Notes
(0022751)
hgbot   
2009-12-14 13:01   
Repository: erp/stable/2.40
Changeset: 1a91cca63722d39a89e3180d224c803d219d3373
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Mon Dec 14 13:00:49 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.40/rev/1a91cca63722d39a89e3180d224c803d219d3373 [^]

Fixes bug 0011607: 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
---
(0023820)
arunkumar   
2010-01-27 12:30   
Tested & Working fine