Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023106Localization Pack: SpainAEAT 347public2013-02-18 18:002017-05-29 15:20
Reporteregoitz 
Assigned ToTriage Finance 
PriorityhighSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket34465
OBNetwork customerOBPS
Regression introduced in release
Summary0023106: The 347 report takes more than 30 minutes to get data for a year on an environment with a big fact_act
DescriptionThe 347 report takes more than 30 minutes to get data for a year on an environment with a big fact_act.
In this case the fact_act table has 5899791 rows
Steps To Reproduce-Execute the 347 report on an environment with 5899791 ows on the fact_acct table
Proposed SolutionTest with the following index:

CREATE INDEX Fact_Acct_C_Tax_ID ON Fact_Acct(C_Tax_ID);
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-02-18 18:00egoitzNew Issue
2013-02-18 18:00egoitzAssigned To => jonalegriaesarte
2013-02-18 18:00egoitzOBNetwork customer => Yes
2013-02-18 18:17egoitzAssigned Tojonalegriaesarte => Sandrahuguet
2013-02-18 18:33egoitzProposed Solution updated
2013-02-25 10:58SandrahuguetPriorityimmediate => high
2013-03-04 17:08psanjuanNote Added: 0057014
2013-03-04 17:08psanjuanTypedefect => design defect
2015-02-26 11:10ngarciaSupport ticket => 34465
2015-03-17 09:40apalaciosIssue Monitored: apalacios
2017-05-29 15:20SandrahuguetAssigned ToSandrahuguet => Triage Finance

Notes
(0057014)
psanjuan   
2013-03-04 17:08   
Changed to design defect as this is something which requires research.