Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011606Openbravo ERP09. Financial managementpublic2009-12-02 13:382009-12-04 00:00
Reporterarunkumar 
Assigned Torafaroda 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version2.35 
Target VersionFixed in Version 
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
Summary0011606: 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
depends on backport 0011607 closed eduardo_Argal Unable to post the document - Oracle Database gets locked when accounting process is running 
depends on backport 0011608 closed eduardo_Argal Unable to post the document - Oracle Database gets locked when accounting process is running 
Attached Filesjpg Accountprocesserror.JPG (166,961) 2009-12-02 13:38
https://issues.openbravo.com/file_download.php?file_id=2014&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2009-12-02 13:38arunkumarNew Issue
2009-12-02 13:38arunkumarAssigned To => rafaroda
2009-12-02 13:38arunkumarFile Added: Accountprocesserror.JPG
2009-12-02 13:38arunkumarOBNetwork customer => No
2009-12-02 13:39arunkumarSummaryUnable to post the document - Database gets locked when accounting process is running => Unable to post the document - Oracle Database gets locked when accounting process is running
2009-12-02 13:39arunkumarDescription Updated
2009-12-02 13:39arunkumarProposed Solution updated
2009-12-02 13:39arunkumarStatusnew => scheduled
2009-12-02 13:39arunkumarfix_in_branch => pi
2009-12-02 13:41psarobeStatusscheduled => feedback
2009-12-02 13:42psarobeStatusfeedback => scheduled
2009-12-02 13:43psarobeNote Added: 0022361
2009-12-02 13:43psarobeStatusscheduled => closed
2009-12-02 13:43psarobeResolutionopen => no change required
2009-12-02 18:37hgbotCheckin
2009-12-02 18:37hgbotNote Added: 0022375
2009-12-02 18:37hgbotStatusclosed => resolved
2009-12-02 18:37hgbotResolutionno change required => fixed
2009-12-02 18:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.3x/rev/68154b7d45807078de19b21bc517584cd35b4ab1 [^]
2009-12-03 11:22jpabloaeNote Added: 0022393
2009-12-03 11:22jpabloaeStatusresolved => new
2009-12-03 11:22jpabloaeResolutionfixed => open
2009-12-03 11:25jpabloaeNote Added: 0022394
2009-12-03 11:25jpabloaeStatusnew => closed
2009-12-03 11:25jpabloaeResolutionopen => no change required
2009-12-04 00:00anonymoussf_bug_id0 => 2908433

Notes
(0022361)
psarobe   
2009-12-02 13:43   
Working in PI
(0022375)
hgbot   
2009-12-02 18:37   
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
---
(0022393)
jpabloae   
2009-12-03 11:22   
Reopening because the backport should have been resolved and not the defect.
(0022394)
jpabloae   
2009-12-03 11:25   
Affects 2.3x and 2.40 only, closing the pi defect.