Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007756Openbravo ERP09. Financial managementpublic2009-01-09 22:072009-03-05 12:30
Reporternetworkb 
Assigned Toshuehner 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionGentoo 2.6.24
Product Version2.35MP4 
Target VersionFixed in Version2.40MP3 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007756: Having a huge amount of records on fact_Acct (>125.000) blocks the database on deleting process.
DescriptionIf you have for than 125.000 fact_acct records and you try to delete all of them together (supouse all the periods are opened), the database gets blocked with Oracle looks.
Steps To ReproduceRegister more than 125.000 records on fact_acct (20.000 invoices, 20.000 settlements, 20.000 bankstatements, etc.).
Disable background process.
Try to erase the accounting information with the existing process Finantial management->Accounting->Transactions->Erase Accounting
Proposed Solution1-Database fine tunning.
2-Delete all the information in blocks instead of all at once.
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0006836 closed shuehner Having a huge amount of records on fact_Acct (>125.000) blocks the database on deleting process. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-23 12:52shuehnerTypedefect => backport
2009-02-23 12:52shuehnerfix_in_branchtrunk => 2.40
2009-02-23 15:31svnbotCheckin
2009-02-23 15:31svnbotNote Added: 0013947
2009-02-23 15:31svnbotStatusscheduled => resolved
2009-02-23 15:31svnbotResolutionopen => fixed
2009-02-23 15:31svnbotsvn_revision => 13533
2009-03-03 17:31psarobeFixed in Version => 2.40MP3
2009-03-05 12:30psarobeStatusresolved => closed
2009-03-05 12:30psarobeNote Added: 0014433

Notes
(0013947)
svnbot   
2009-02-23 15:31   
Repository: openbravo
Revision: 13533
Author: huehner
Date: 2009-02-23 15:31:26 +0100 (Mon, 23 Feb 2009)

Fixed 7756
Keep transaction size of the accounting reset process small by doing period commits.

---
U branches/r2.40/src-db/database/model/functions/FACT_ACCT_RESET.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=13533&sc=1 [^]
(0014433)
psarobe   
2009-03-05 12:30   
Can't able to reproduce