Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0011606
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajorhave not tried2009-12-02 13:382009-12-04 00:00
ReporterarunkumarView Statuspublic 
Assigned Torafaroda 
PriorityimmediateResolutionno change requiredFixed in Version
StatusclosedFix in branchpiFixed in SCM revision68154b7d4580
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.35SCM revision 
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
Summary

0011606: 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.
TagsNo tags attached.
Attached Filesjpg file icon Accountprocesserror.JPG [^] (166,961 bytes) 2009-12-02 13:38

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0011607 closededuardo_Argal Unable to post the document - Oracle Database gets locked when accounting process is running 
depends on backport 0011608 closededuardo_Argal Unable to post the document - Oracle Database gets locked when accounting process is running 

-  Notes
(0022361)
psarobe (viewer)
2009-12-02 13:43

Working in PI
(0022375)
hgbot (developer)
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 (viewer)
2009-12-03 11:22

Reopening because the backport should have been resolved and not the defect.
(0022394)
jpabloae (viewer)
2009-12-03 11:25

Affects 2.3x and 2.40 only, closing the pi defect.

- Issue History
Date Modified Username Field Change
2009-12-02 13:38 arunkumar New Issue
2009-12-02 13:38 arunkumar Assigned To => rafaroda
2009-12-02 13:38 arunkumar File Added: Accountprocesserror.JPG
2009-12-02 13:38 arunkumar OBNetwork customer => No
2009-12-02 13:39 arunkumar Summary Unable 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:39 arunkumar Description Updated
2009-12-02 13:39 arunkumar Proposed Solution updated
2009-12-02 13:39 arunkumar Status new => scheduled
2009-12-02 13:39 arunkumar fix_in_branch => pi
2009-12-02 13:41 psarobe Status scheduled => feedback
2009-12-02 13:42 psarobe Status feedback => scheduled
2009-12-02 13:43 psarobe Note Added: 0022361
2009-12-02 13:43 psarobe Status scheduled => closed
2009-12-02 13:43 psarobe Resolution open => no change required
2009-12-02 18:37 hgbot Checkin
2009-12-02 18:37 hgbot Note Added: 0022375
2009-12-02 18:37 hgbot Status closed => resolved
2009-12-02 18:37 hgbot Resolution no change required => fixed
2009-12-02 18:37 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.3x/rev/68154b7d45807078de19b21bc517584cd35b4ab1 [^]
2009-12-03 11:22 jpabloae Note Added: 0022393
2009-12-03 11:22 jpabloae Status resolved => new
2009-12-03 11:22 jpabloae Resolution fixed => open
2009-12-03 11:25 jpabloae Note Added: 0022394
2009-12-03 11:25 jpabloae Status new => closed
2009-12-03 11:25 jpabloae Resolution open => no change required
2009-12-04 00:00 anonymous sf_bug_id 0 => 2908433


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker