Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0049339Openbravo ERP09. Financial managementpublic2022-05-17 10:402022-06-03 09:32
Reporteregoitz 
Assigned Toigor_trebol 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR22Q3 
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
Summary0049339: EndYear Process is slow on environment with lots of transactiions
DescriptionThe end-year process is slow and retrieves a timeout while the queries continue running for a long time.

the perforamnce is even worst when executing in business hours.
Steps To Reproduce- Execute the closure on an environment with thousands of transactions.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0038886 closed markmm82 Performance problem in End Year Close | Accounting tab 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-05-17 10:40egoitzNew Issue
2022-05-17 10:40egoitzAssigned To => Triage Omni OMS
2022-05-17 10:40egoitzModules => Core
2022-05-17 10:40egoitzTriggers an Emergency Pack => No
2022-05-23 18:24aferrazAssigned ToTriage Omni OMS => igor_trebol
2022-05-30 19:22aferrazRelationship addedrelated to 0038886
2022-06-02 16:09hgbotNote Added: 0137989
2022-06-03 09:32hgbotResolutionopen => fixed
2022-06-03 09:32hgbotStatusnew => closed
2022-06-03 09:32hgbotFixed in Version => PR22Q3
2022-06-03 09:32hgbotNote Added: 0138018
2022-06-03 09:32hgbotNote Added: 0138019

Notes
(0137989)
hgbot   
2022-06-02 16:09   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/608 [^]
(0138018)
hgbot   
2022-06-03 09:32   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/608 [^]
(0138019)
hgbot   
2022-06-03 09:32   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 27e8de889aad9eb33151b30c862c1c7810723e16
Author: Igor Trebol <igor.trebol@openbravo.com>
Date: 02-06-2022 17:11:03
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/27e8de889aad9eb33151b30c862c1c7810723e16 [^]

Fixes ISSUE-49339: Added c_period to index for table fact_acct to improve the performance of table FinancialMgmtAccountingFactEndYearHQL

---
M src-db/database/model/tables/FACT_ACCT.xml
---