Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0037336 | Openbravo ERP | 04. Warehouse management | public | 2017-11-21 04:08 | 2017-12-14 09:58 |
|
| Reporter | rbianchini | |
| Assigned To | AtulOpenbravo | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | duplicate | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR17Q2 | |
| 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 | 0037336: Performance of Warehouse Control Report |
| Description | When the m_transaction is too large, there is a performance problem with this report, when the window is opened, there is a delay of a few minutes, even sometimes, it locks the system, depending on the server load at that moment. We discovered that when the report is opened, it executes the query and it is not necessary. |
| Steps To Reproduce | 1 - Open the Warehouse Control Report, on an environment with more than a half million of records on the m_transaction. |
| Proposed Solution | Avoid executing the query when the report is opening. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | duplicate of | design defect | 0034620 | | closed | rqueralta | The ReportWarehouseControl report collapse the system |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2017-11-21 04:08 | rbianchini | New Issue | |
| 2017-11-21 04:08 | rbianchini | Assigned To | => Triage Finance |
| 2017-11-21 04:08 | rbianchini | Modules | => Core |
| 2017-11-21 04:08 | rbianchini | Triggers an Emergency Pack | => No |
| 2017-11-23 14:46 | rbianchini | Issue Monitored: rbianchini | |
| 2017-11-23 14:49 | rbianchini | Note Added: 0100690 | |
| 2017-11-23 15:00 | rbianchini | Note Deleted: 0100690 | |
| 2017-11-23 15:06 | rbianchini | Description Updated | bug_revision_view_page.php?rev_id=16361#r16361 |
| 2017-11-23 15:06 | rbianchini | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=16363#r16363 |
| 2017-11-23 15:06 | rbianchini | Proposed Solution updated | |
| 2017-11-28 02:33 | rbianchini | Resolution time | => 1513047600 |
| 2017-11-28 16:39 | dmiguelez | Assigned To | Triage Finance => AtulOpenbravo |
| 2017-12-01 12:58 | AtulOpenbravo | Status | new => feedback |
| 2017-12-13 18:04 | AtulOpenbravo | Status | feedback => scheduled |
| 2017-12-13 18:05 | AtulOpenbravo | Relationship added | related to 0034620 |
| 2017-12-14 09:58 | dmiguelez | Review Assigned To | => dmiguelez |
| 2017-12-14 09:58 | dmiguelez | Relationship replaced | duplicate of 0034620 |
| 2017-12-14 09:58 | dmiguelez | Note Added: 0101031 | |
| 2017-12-14 09:58 | dmiguelez | Status | scheduled => closed |
| 2017-12-14 09:58 | dmiguelez | Resolution | open => duplicate |
| 2017-12-14 09:58 | dmiguelez | Fixed in Version | => 3.0PR17Q2 |