Openbravo Issue Tracking System - Retail Modules
View Issue Details
0035286Retail ModulesWeb POSpublic2017-02-16 16:152017-03-06 13:42
plujan 
marvintm 
normalmajorhave not tried
closedfixed 
5
main 
RR17Q2 
guilleaer
Packaging and release
main
No
0035286: [RR17Q1] Login error due a performance problem with Business Partner selector using Local Data
The login process is not working properly in the case of having a reasonable large amount of business partners (60k) in a context using the local DB (no remote data)
After logging in, the main window will not be shown and the console will trhow a message about a timeout in Business Partner section of the data population phase.

Note this will not happen if the environment has remote data active, so it seems related with a wrong SQL planner decision that has to be taken into account.
No tags attached.
depends on backport 0035291RR17Q1 closed marvintm [RR17Q1] Login error due a performance problem with Business Partner selector using Local Data 
Issue History
2017-02-16 16:15plujanNew Issue
2017-02-16 16:15plujanAssigned To => Retail
2017-02-16 16:15plujanRegression level => Packaging and release
2017-02-16 16:15plujanRegression introduced in release => main
2017-02-16 16:15plujanTriggers an Emergency Pack => No
2017-02-16 16:21lorenzofidalgoSummary[RR17Q1] Login error due a oerformance problem with Business Partner selector using Local Data => [RR17Q1] Login error due a performance problem with Business Partner selector using Local Data
2017-02-17 08:31marvintmStatusnew => scheduled
2017-02-17 08:31marvintmAssigned ToRetail => marvintm
2017-02-20 09:21hgbotCheckin
2017-02-20 09:21hgbotNote Added: 0094455
2017-02-20 09:21hgbotStatusscheduled => resolved
2017-02-20 09:21hgbotResolutionopen => fixed
2017-02-20 09:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/796f4eab7e9381485906fbd92fe844f61e1759c1 [^]
2017-03-06 13:42guilleaerReview Assigned To => guilleaer
2017-03-06 13:42guilleaerStatusresolved => closed
2017-03-06 13:42guilleaerFixed in Version => RR17Q2

Notes
(0094455)
hgbot   
2017-02-20 09:21   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 796f4eab7e9381485906fbd92fe844f61e1759c1
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Feb 20 09:21:17 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/796f4eab7e9381485906fbd92fe844f61e1759c1 [^]

Fixed issue 35286. Modified query to get better performance when the number of contacts is high

---
M src/org/openbravo/retail/posterminal/master/BusinessPartner.java
---