Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0037336 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 04. Warehouse management | major | always | 2017-11-21 04:08 | 2017-12-14 09:58 | |||
| Reporter | rbianchini | View Status | public | |||||
| Assigned To | AtulOpenbravo | |||||||
| Priority | normal | Resolution | duplicate | Fixed in Version | 3.0PR17Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | dmiguelez | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
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 | View Revisions |
| 2017-11-23 15:06 | rbianchini | Steps to Reproduce Updated | View Revisions |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |