Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021165Openbravo ERP09. Financial managementpublic2012-07-20 11:322012-08-01 14:17
Reporterjonalegriaesarte 
Assigned Tojonalegriaesarte 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP14Fixed in Version3.0MP14 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket15785
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021165: Unpost process takes a long time when working with high volumes
DescriptionUnpost process takes a long time when working with high volumes
Steps To Reproduce- Huge amount of data is needed in fact_acct table
- Unpost an invoice
- It takes 2 minutes
Proposed Solution
Additional Information
TagsPerformance
Relationships
duplicate of design defect 00223003.0MP19 closed eduardo_Argal Long time to unpost a sales invoice where there are too many rows on fact_acct table 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-07-20 11:32jonalegriaesarteNew Issue
2012-07-20 11:32jonalegriaesarteAssigned To => jonalegriaesarte
2012-07-20 11:32jonalegriaesarteModules => Core
2012-07-20 11:32jonalegriaesarteOBNetwork customer => Yes
2012-07-20 11:32jonalegriaesarteSupport ticket => 15785
2012-07-20 11:33jonalegriaesarteNote Added: 0050775
2012-07-20 11:50hgbotCheckin
2012-07-20 11:50hgbotNote Added: 0050776
2012-07-20 11:50hgbotStatusnew => resolved
2012-07-20 11:50hgbotResolutionopen => fixed
2012-07-20 11:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3d4a7117ba25e8a9a0aab392e3e255a9696a7240 [^]
2012-07-20 11:53jonalegriaesarteTag Attached: Performance
2012-07-26 02:42hudsonbotCheckin
2012-07-26 02:42hudsonbotNote Added: 0050865
2012-08-01 14:17egoitzNote Added: 0051063
2012-08-01 14:17egoitzStatusresolved => closed
2012-08-01 14:17egoitzFixed in Version => 3.0MP14
2012-11-14 13:37egoitzRelationship addedduplicate of 0022300

Notes
(0050775)
jonalegriaesarte   
2012-07-20 11:33   
Testing the fix, be careful with the functional implications. Be sure that the process works fine and unpost the documents correctly.
(0050776)
hgbot   
2012-07-20 11:50   
Repository: erp/devel/pi
Changeset: 3d4a7117ba25e8a9a0aab392e3e255a9696a7240
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Fri Jul 20 11:50:18 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/3d4a7117ba25e8a9a0aab392e3e255a9696a7240 [^]

Fixes issue 0021165: Unpost process takes a long time when working with high
volumes

---
M src-db/database/model/functions/FACT_ACCT_RESET.xml
---
(0050865)
hudsonbot   
2012-07-26 02:42   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/5edf203d5780 [^]

Maturity status: Test
(0051063)
egoitz   
2012-08-01 14:17   
verified