Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039017Openbravo ERP02. Master data managementpublic2018-07-23 17:152018-08-11 09:32
ReporterJONHM 
Assigned Tocollazoandy4 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0PR18Q2 
Target VersionFixed in Version3.0PR18Q4 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket3436
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039017: Performance issue in Requisition To Order window
DescriptionPerformance issue in Requisition To Order window, it takes 43 seconds to load
Steps To ReproduceAsk environment to Support

- Open Requisition to Order window
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng Screenshot from 2018-07-23 17-14-14.png (120,688) 2018-07-23 17:15
https://issues.openbravo.com/file_download.php?file_id=11990&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2018-07-23 17:15JONHMNew Issue
2018-07-23 17:15JONHMAssigned To => Triage Finance
2018-07-23 17:15JONHMFile Added: Screenshot from 2018-07-23 17-14-14.png
2018-07-23 17:15JONHMOBNetwork customer => Yes
2018-07-23 17:15JONHMModules => Core
2018-07-23 17:15JONHMSupport ticket => 3436
2018-07-23 17:15JONHMResolution time => 1534111200
2018-07-23 17:15JONHMTriggers an Emergency Pack => No
2018-07-23 17:16JONHMversion => 3.0PR18Q2
2018-07-23 23:50collazoandy4Assigned ToTriage Finance => collazoandy4
2018-07-23 23:51collazoandy4Statusnew => scheduled
2018-07-30 16:19collazoandy4Note Added: 0106021
2018-07-30 16:21collazoandy4Note Added: 0106022
2018-08-10 14:13hgbotCheckin
2018-08-10 14:13hgbotNote Added: 0106285
2018-08-10 14:13hgbotStatusscheduled => resolved
2018-08-10 14:13hgbotResolutionopen => fixed
2018-08-10 14:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fe8d2427d8630cdccb6e3ec29b59210bf29a3908 [^]
2018-08-10 14:50hgbotCheckin
2018-08-10 14:50hgbotNote Added: 0106287
2018-08-10 15:02hgbotCheckin
2018-08-10 15:02hgbotNote Added: 0106288
2018-08-10 15:06SandrahuguetReview Assigned To => Sandrahuguet
2018-08-10 15:06SandrahuguetNote Added: 0106289
2018-08-10 15:06SandrahuguetStatusresolved => closed
2018-08-10 15:06SandrahuguetFixed in Version => 3.0PR18Q4
2018-08-11 09:32hudsonbotCheckin
2018-08-11 09:32hudsonbotNote Added: 0106299
2018-08-11 09:32hudsonbotCheckin
2018-08-11 09:32hudsonbotNote Added: 0106300
2018-08-11 09:32hudsonbotCheckin
2018-08-11 09:32hudsonbotNote Added: 0106301

Notes
(0106021)
collazoandy4   
2018-07-30 16:19   
Test Plan
  Go to Requisition window and create a new record for Region Norte org
    Create a new record in Lines Tab:
      Need by Date: Today
      Product: Cerveza Ale 0,5L
      Quantity: 10
    Complete the Requisition
  Go to Requisition to order window and chec the previous record is shown

Test Plan II
  Repeat the previous test plan with AUM preference enabled
(0106022)
collazoandy4   
2018-07-30 16:21   
With the fix proposed the query execution time was reduced from 40433.560 to 180.711 ms
(0106285)
hgbot   
2018-08-10 14:13   
Repository: erp/devel/pi
Changeset: fe8d2427d8630cdccb6e3ec29b59210bf29a3908
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Tue Jul 24 17:18:24 2018 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/fe8d2427d8630cdccb6e3ec29b59210bf29a3908 [^]

Fixes issue 39017: Performance issue in Requisition To Order window

---
M src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder.java
M src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql
---
(0106287)
hgbot   
2018-08-10 14:50   
Repository: erp/devel/pi
Changeset: 389e4c0f5e997f44fc0426ee22f7a022dcd0c2a0
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Fri Aug 10 14:45:30 2018 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/389e4c0f5e997f44fc0426ee22f7a022dcd0c2a0 [^]

related to issue 39017 code review changes

change m_pricelist_id column by name column, because is the correct one

---
M src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql
---
(0106288)
hgbot   
2018-08-10 15:02   
Repository: erp/devel/pi
Changeset: 6bc6e85153109c0448a29ffa3249836d4fcc6d7d
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Fri Aug 10 15:02:15 2018 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6bc6e85153109c0448a29ffa3249836d4fcc6d7d [^]

related to issue 39017 code review changes

fix group by clause

---
M src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql
---
(0106289)
Sandrahuguet   
2018-08-10 15:06   
Code review + testing OK
(0106299)
hudsonbot   
2018-08-11 09:32   
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/7d17883ca725 [^]
Maturity status: Test
(0106300)
hudsonbot   
2018-08-11 09:32   
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/7d17883ca725 [^]
Maturity status: Test
(0106301)
hudsonbot   
2018-08-11 09:32   
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/7d17883ca725 [^]
Maturity status: Test