Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0037188 | Openbravo ERP | 02. Master data management | public | 2017-10-30 16:44 | 2017-11-09 11:27 |
|
| Reporter | JONHM | |
| Assigned To | AtulOpenbravo | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR17Q3 | |
| Merge Request Status | |
| Review Assigned To | dmiguelez |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0037188: Performance problems in General Ledger Report |
| Description | Performance problems in General Ledger Report.
In an environment with the following data, the report takes time to show the records.
The "records range parameter" value in Session Preferences is set as 20.
fact_acct = 16585583 records |
| Steps To Reproduce | Open General Ledger Report:
-From date: 09-01-2017
-To date: 10-01-2017
-Organization: Metal Supermarkets GTA
-General Ledger: CAD Ledger
-Rest of parameters by default
It takes long time to show data
|
| Proposed Solution | Could be nice to add an index in fact_acct table |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0036738 | | closed | AtulOpenbravo | Performance problems in General Ledger Report when grouping it by Business Partner |
|
| Attached Files |  generalLedgerReport.sql (2,078) 2017-10-30 16:44
https://issues.openbravo.com/file_download.php?file_id=11250&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2017-10-30 16:44 | JONHM | New Issue | |
| 2017-10-30 16:44 | JONHM | Assigned To | => Triage Finance |
| 2017-10-30 16:44 | JONHM | File Added: generalLedgerReport.sql | |
| 2017-10-30 16:44 | JONHM | Modules | => Core |
| 2017-10-30 16:44 | JONHM | Resolution time | => 1511132400 |
| 2017-10-30 16:44 | JONHM | Triggers an Emergency Pack | => No |
| 2017-10-30 17:07 | JONHM | Relationship added | related to 0036738 |
| 2017-10-30 17:48 | dmiguelez | Assigned To | Triage Finance => AtulOpenbravo |
| 2017-11-02 10:16 | AtulOpenbravo | Status | new => scheduled |
| 2017-11-09 11:27 | dmiguelez | Review Assigned To | => dmiguelez |
| 2017-11-09 11:27 | dmiguelez | Note Added: 0100377 | |
| 2017-11-09 11:27 | dmiguelez | Status | scheduled => closed |
| 2017-11-09 11:27 | dmiguelez | Resolution | open => fixed |
| 2017-11-09 11:27 | dmiguelez | Fixed in Version | => 3.0PR17Q3 |