Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008594Openbravo ERP09. Financial managementpublic2009-04-08 10:412009-05-12 11:30
Reporternetworkb 
Assigned Todalsasua 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version2.40MP3 
Target VersionFixed in Version2.40MP4 
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
Summary0008594: The General Ledger Reports is too slow in postgres if the fact acct has more than 100.000 rows
DescriptionThe General Ledger Reports is too slow in postgres if the fact acct has more than 100.000 rows. It takes long to print the report. It happens in oracle and postgres
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0008500 closed dalsasua The General Ledger Reports is too slow in postgres if the fact acct has more than 100.000 rows 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-04-16 12:22psarobeTypedefect => backport
2009-04-16 12:22psarobefix_in_branch => 2.40
2009-04-20 18:30shuehnerAssigned Toshuehner => dalsasua
2009-04-30 18:57hgbotCheckin
2009-04-30 18:57hgbotNote Added: 0015977
2009-04-30 18:57hgbotStatusscheduled => resolved
2009-04-30 18:57hgbotResolutionopen => fixed
2009-04-30 18:57hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/947580d5ff20c594b3c4dc9554fac00291b8900a [^]
2009-05-07 13:16hgbotCheckin
2009-05-07 13:16hgbotNote Added: 0016134
2009-05-07 13:16hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/947580d5ff20c594b3c4dc9554fac00291b8900a [^] => http://code.openbravo.com/erp/stable/2.40/rev/f253a4e895cbed1785abe97f02013d0838c5f202 [^]
2009-05-08 11:00hgbotCheckin
2009-05-08 11:00hgbotNote Added: 0016169
2009-05-08 11:00hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/f253a4e895cbed1785abe97f02013d0838c5f202 [^] => http://code.openbravo.com/erp/stable/2.40/rev/9f335c8a4d1562e7ff0c7b6cbb171c8119be312d [^]
2009-05-08 12:16hgbotCheckin
2009-05-08 12:16hgbotNote Added: 0016172
2009-05-08 12:16hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/9f335c8a4d1562e7ff0c7b6cbb171c8119be312d [^] => http://code.openbravo.com/erp/stable/2.40/rev/88199bb02706394a98895c788016dbfc16bea1e8 [^]
2009-05-10 19:37psarobeFixed in Version => 2.40MP4
2009-05-11 16:43hgbotCheckin
2009-05-11 16:43hgbotNote Added: 0016268
2009-05-11 16:43hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/88199bb02706394a98895c788016dbfc16bea1e8 [^] => http://code.openbravo.com/erp/stable/2.40/rev/a6fd9ad6d5500da564975f897ea71b4d70e7d9aa [^]
2009-05-12 11:30psarobeStatusresolved => closed
2009-05-12 11:30psarobeNote Added: 0016290

Notes
(0015977)
hgbot   
2009-04-30 18:57   
Repository: erp/stable/2.40
Changeset: 947580d5ff20c594b3c4dc9554fac00291b8900a
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Thu Apr 30 18:55:07 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/947580d5ff20c594b3c4dc9554fac00291b8900a [^]

Fixes Bug 8594: The General Ledger Reports is too slow in postgres if the fact acct has more than 100.000 rows

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
---
(0016134)
hgbot   
2009-05-07 13:16   
Repository: erp/stable/2.40
Changeset: f253a4e895cbed1785abe97f02013d0838c5f202
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Thu May 07 13:15:01 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/f253a4e895cbed1785abe97f02013d0838c5f202 [^]

Fixes Bug 8594: The General Ledger Reports is too slow in postgres if the fact acct has more than 100.000 rows

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_Previous.jasper
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_Previous.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
---
(0016169)
hgbot   
2009-05-08 11:00   
Repository: erp/stable/2.40
Changeset: 9f335c8a4d1562e7ff0c7b6cbb171c8119be312d
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri May 08 11:00:34 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/9f335c8a4d1562e7ff0c7b6cbb171c8119be312d [^]

Fixes Bug 8594: The General Ledger Reports is too slow in postgres if the fact acct has more than 100.000 rows

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_Previous.jasper
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_Previous.jrxml
---
(0016172)
hgbot   
2009-05-08 12:16   
Repository: erp/stable/2.40
Changeset: 88199bb02706394a98895c788016dbfc16bea1e8
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri May 08 12:15:47 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/88199bb02706394a98895c788016dbfc16bea1e8 [^]

Fixes Bug 8594: The General Ledger Reports is too slow in postgres if the fact acct has more than 100.000 rows

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_Previous.jasper
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_Previous.jrxml
---
(0016268)
hgbot   
2009-05-11 16:43   
Repository: erp/stable/2.40
Changeset: a6fd9ad6d5500da564975f897ea71b4d70e7d9aa
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Mon May 11 14:56:36 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/a6fd9ad6d5500da564975f897ea71b4d70e7d9aa [^]

Fixes Issue 8594: The General Ledger Reports is too slow in postgres if the fact acct has more than 100.000 rows

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
---
(0016290)
psarobe   
2009-05-12 11:30   
Not able to test it with so many rows