Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0029226 | Openbravo ERP | 04. Warehouse management | public | 2015-03-10 16:32 | 2015-05-07 22:16 |
| Reporter | egoitz | ||||
| Assigned To | Triage Omni WMS | ||||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | 3.0PR15Q3 | Fixed in Version | pi | ||
| Merge Request Status | |||||
| Review Assigned To | umartirena | ||||
| 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 | 0029226: The value stock reports is slow with many rows on the m_transaction_cost table and most of the them are for the same locator | ||||
| Description | The execution of the report for an environment with the folloiwng amount of that on the affected tables takes arround 20 minutes. Most of the transactions are for the same locator. 'm_transaction_cost';385315 'm_inout';26405 'm_product';3530 | ||||
| Steps To Reproduce | Execute the report without selecting product categories for a date bigger than the biggest one on the transaction cost table. After execute the information of the sequencial scans igoniring the information genrated by the ad_column_identifier table is the following: table,tot,seq_scan 'm_transaction_cost';385315;1 'm_inout';26405;1 'm_product';3530;1 'm_product_category';135;1 'c_uom';14;1 'm_locator';8;1 | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | Performance | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2015-03-10 16:32 | egoitz | New Issue | |||
| 2015-03-10 16:32 | egoitz | Assigned To | => Sandrahuguet | ||
| 2015-03-10 16:32 | egoitz | Modules | => Core | ||
| 2015-03-10 16:32 | egoitz | Resolution time | => 1396303200 | ||
| 2015-03-10 16:32 | egoitz | Triggers an Emergency Pack | => No | ||
| 2015-03-10 16:34 | egoitz | Tag Attached: Performance | |||
| 2015-03-26 11:46 | egoitz | Type | design defect => defect | ||
| 2015-03-26 11:47 | egoitz | Resolution time | 1396303200 => 1397599200 | ||
| 2015-04-14 12:48 | Triage Finance | Assigned To | Sandrahuguet => Triage Finance | ||
| 2015-04-15 10:16 | ngarcia | Issue Monitored: ngarcia | |||
| 2015-04-17 16:55 | agarcia_tegik | Issue Monitored: agarcia_tegik | |||
| 2015-04-27 14:04 | hgbot | Checkin | |||
| 2015-04-27 14:04 | hgbot | Note Added: 0076785 | |||
| 2015-04-27 14:04 | hgbot | Status | new => resolved | ||
| 2015-04-27 14:04 | hgbot | Resolution | open => fixed | ||
| 2015-04-27 14:04 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/f431237fa5b4a609157730ed5a234e7dbcc8cb60 [^] | ||
| 2015-04-27 14:05 | umartirena | Review Assigned To | => umartirena | ||
| 2015-04-27 14:05 | umartirena | Note Added: 0076786 | |||
| 2015-04-27 14:05 | umartirena | Status | resolved => closed | ||
| 2015-04-27 14:05 | umartirena | Fixed in Version | => pi | ||
| 2015-05-07 22:16 | hudsonbot | Checkin | |||
| 2015-05-07 22:16 | hudsonbot | Note Added: 0077161 | |||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||