Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0035636 | Openbravo ERP | 07. Sales management | public | 2017-03-28 18:38 | 2017-05-29 17:43 |
|
| Reporter | Sandrahuguet | |
| Assigned To | markmm82 | |
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 20 | OS Version | Community Appliance |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR17Q3 | |
| Merge Request Status | |
| Review Assigned To | aferraz |
| 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 | 0035636: Business partner selector get stuck in create lines from invoice in hgvol environment |
| Description | Business partner selector get stuck in create lines from invoice in hgvol environment |
| Steps To Reproduce | In a hgvol enviroment
-Login in the ERP
-Go to Sales Invoice window
-Create new record
-Select a business partner
-Click on create lines from
-Open business partner selector
Business partner selector get stuck, see screenshoot |
| Proposed Solution | |
| Additional Information | |
| Tags | Performance |
| Relationships | | related to | defect | 0009897 | | closed | shuehner | Business Partner selector is slow with many business partners | | depends on | defect | 0035210 | | closed | markmm82 | sequential scans in c_bpartner using partner selector drop down filter |
|
| Attached Files |  createlinesfrom.png (66,806) 2017-03-28 18:39
https://issues.openbravo.com/file_download.php?file_id=10614&type=bug
|
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2017-03-28 18:38 | Sandrahuguet | New Issue | |
| 2017-03-28 18:38 | Sandrahuguet | Assigned To | => Triage Finance |
| 2017-03-28 18:38 | Sandrahuguet | Modules | => Core |
| 2017-03-28 18:38 | Sandrahuguet | Triggers an Emergency Pack | => No |
| 2017-03-28 18:39 | Sandrahuguet | File Added: createlinesfrom.png | |
| 2017-03-28 18:40 | Sandrahuguet | Tag Attached: Performance | |
| 2017-03-30 13:44 | shuehner | Resolution time | => 1492639200 |
| 2017-03-30 13:44 | shuehner | Severity | minor => major |
| 2017-03-30 20:13 | markmm82 | Assigned To | Triage Finance => markmm82 |
| 2017-03-30 20:15 | markmm82 | Status | new => acknowledged |
| 2017-04-04 22:57 | markmm82 | Status | acknowledged => scheduled |
| 2017-04-12 14:06 | aferraz | Relationship added | related to 0035210 |
| 2017-04-12 14:08 | aferraz | Relationship added | related to 0009897 |
| 2017-04-12 14:50 | aferraz | Relationship replaced | depends on 0035210 |
| 2017-04-20 19:21 | markmm82 | Note Added: 0096096 | |
| 2017-04-24 18:59 | hgbot | Checkin | |
| 2017-04-24 18:59 | hgbot | Note Added: 0096141 | |
| 2017-04-24 18:59 | hgbot | Status | scheduled => resolved |
| 2017-04-24 18:59 | hgbot | Resolution | open => fixed |
| 2017-04-24 18:59 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/e833242c1051edf0af778d1621f27b44ac1bed3b [^] |
| 2017-04-24 18:59 | aferraz | Review Assigned To | => aferraz |
| 2017-04-24 18:59 | aferraz | Note Added: 0096142 | |
| 2017-04-24 18:59 | aferraz | Status | resolved => closed |
| 2017-04-24 18:59 | aferraz | Fixed in Version | => 3.0PR17Q3 |
| 2017-04-26 16:21 | aferraz | Note Added: 0096200 | |
| 2017-05-29 17:43 | hudsonbot | Checkin | |
| 2017-05-29 17:43 | hudsonbot | Note Added: 0096904 | |
|
Notes |
|
|
|
Test Plan:
In a hgvol enviroment
-Login in the ERP
-Go to Sales Invoice window
-Create new record
-Select a business partner
-Click on create lines from
-Open business partner selector
Notice that Business partner selector opens and grid is filled with filtered results. |
|
|
|
(0096141)
|
|
hgbot
|
|
2017-04-24 18:59
|
|
Repository: erp/devel/pi
Changeset: e833242c1051edf0af778d1621f27b44ac1bed3b
Author: Mark <markmm82 <at> gmail.com>
Date: Sun Apr 16 13:16:12 2017 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/e833242c1051edf0af778d1621f27b44ac1bed3b [^]
Fixes issue 35636: Business partner selector get stuck in create lines from
invoice in hgvol environment
In high volume environment, when the Business Partner selector is opened from Create
lines from process in the Invoice window, it takes too long to load results and as
consequence the browser was stocked.
To improve the performance in this selector, was changed the BusinessPartner_data.xsql
methods to use UPPER instead of C_IGNORE_ACCENT function, this way it uses the index
created in issue 35210 and improves of performance it introduces.
---
M src/org/openbravo/erpCommon/info/BusinessPartner_data.xsql
---
|
|
|
|
|
|
|
|
|
|
UPPER function will be used to filter by Business Partner name in Create Lines From process, which unlike C_IGNORE_ACCENT distinguishes between A and Á. Thus, it will behave same as normal BP selectors and will take advantage of index created in 0035210. |
|
|
|
|
|