Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013652Openbravo ERP09. Financial managementpublic2010-06-14 18:492010-12-16 22:15
Reporternetworkb 
Assigned Toeduardo_Argal 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP18 
Target Version2.50MP20Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0013652: The General Ledger Report does not work with 3.400.000 entries on the fact_act
DescriptionThe General Ledger Report does not work with 3.400.000 entries on the fact_act.
It starts executing process but the process does not finish, so the report is not shown.
It happens without using filters.

Adding some filters to show only 67000 registers it works.
Steps To ReproduceIn a database with 3.400.000 entries on the fact_acct execute the report without filters.

See that the report starts executing a process but it does not finish so the report is not shown. The application seems locked.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00133612.50MP18 closed sivaraman The General Ledger Report does not work well using the group by option with a big amount of data 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-06-14 18:49networkbNew Issue
2010-06-14 18:49networkbAssigned To => dalsasua
2010-06-14 18:49networkbOBNetwork customer => Yes
2010-07-02 12:18dmitry_mezentsevRelationship addedrelated to 0013361
2010-07-02 12:19dmitry_mezentsevAssigned Todalsasua => eduardo_Argal
2010-07-02 12:20dmitry_mezentsevNote Added: 0028978
2010-07-21 10:13dmitry_mezentsevNote Added: 0029427
2010-07-26 12:12eduardo_ArgalStatusnew => scheduled
2010-07-26 12:12eduardo_Argalfix_in_branch => pi
2010-07-26 12:12eduardo_ArgalNote Added: 0029555
2010-07-26 12:12eduardo_ArgalStatusscheduled => resolved
2010-07-26 12:12eduardo_ArgalFixed in SCM revision => *
2010-07-26 12:12eduardo_ArgalResolutionopen => fixed
2010-12-14 18:27psarobeStatusresolved => closed
2010-12-16 22:15anonymoussf_bug_id0 => 3138773

Notes
(0028978)
dmitry_mezentsev   
2010-07-02 12:20   
I reassigned to Eduardo course related issue was just fixed.
(0029427)
dmitry_mezentsev   
2010-07-21 10:13   
Hi Eduardo,

This ticket is expiring in 5 days, could you please have a look at it?


Thanks.
(0029555)
eduardo_Argal   
2010-07-26 12:12   
Diff sent to customer. Once it is validated on their side changes will be applied to pi