Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0029226 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 04. Warehouse management | major | always | 2015-03-10 16:32 | 2015-05-07 22:16 | |||
| Reporter | egoitz | View Status | public | |||||
| Assigned To | Triage Omni WMS | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | pi | |||
| Status | closed | Fix in branch | Fixed in SCM revision | f431237fa5b4 | ||||
| Projection | none | ETA | none | Target Version | 3.0PR15Q3 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | umartirena | |||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | 34589 | |||||||
| 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 | |||||||
| Tags | Performance | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0076785) hgbot (developer) 2015-04-27 14:04 |
Repository: erp/devel/pi Changeset: f431237fa5b4a609157730ed5a234e7dbcc8cb60 Author: Jorge Garcia <jorge.garcia <at> openbravo.com> Date: Thu Apr 16 10:17:04 2015 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/f431237fa5b4a609157730ed5a234e7dbcc8cb60 [^] Fixed issue 29226: Value stock report is slow with many rows on m_transaction 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. The problem was in the sql query from the report. This query needed an improvement. The sql query from ReportValuationStockData has changed and now the report is faster and the return values are the same as before. --- M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql --- |
|
(0076786) umartirena (viewer) 2015-04-27 14:05 |
Code Review + Testing OK |
|
(0077161) hudsonbot (viewer) 2015-05-07 22:16 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/a1817f84bd8b [^] Maturity status: Test |
|
Notes |
|
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 | OBNetwork customer | => Yes |
| 2015-03-10 16:32 | egoitz | Modules | => Core |
| 2015-03-10 16:32 | egoitz | Support ticket | => 34589 |
| 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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |