Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035291Retail ModulesWeb POSpublic2017-02-16 16:152017-03-07 17:16
Reporterplujan 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionmain 
Target VersionRR17Q1Fixed in VersionRR17Q1 
Merge Request Status
Review Assigned Toguilleaer
OBNetwork customerNo
Support ticket
Regression levelPackaging and release
Regression date
Regression introduced in releasemain
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035291: [RR17Q1] Login error due a performance problem with Business Partner selector using Local Data
DescriptionThe 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)
Steps To ReproduceAfter 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0035286 closed marvintm [RR17Q1] Login error due a performance problem with Business Partner selector using Local Data 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-02-17 08:31marvintmTypedefect => backport
2017-02-17 08:31marvintmTarget Version => RR17Q1
2017-02-17 08:31marvintmAssigned ToRetail => marvintm
2017-02-20 09:22hgbotCheckin
2017-02-20 09:22hgbotNote Added: 0094456
2017-02-20 09:22hgbotStatusscheduled => resolved
2017-02-20 09:22hgbotResolutionopen => fixed
2017-02-20 09:22hgbotFixed in SCM revision => http://code.openbravo.com/retail/backports/3.0RR17Q1/org.openbravo.retail.posterminal/rev/a886fa38576ad643866fc0677e8dfabfc0f8a2a3 [^]
2017-03-07 17:16guilleaerReview Assigned To => guilleaer
2017-03-07 17:16guilleaerStatusresolved => closed
2017-03-07 17:16guilleaerFixed in Version => RR17Q1

Notes
(0094456)
hgbot   
2017-02-20 09:22   
Repository: retail/backports/3.0RR17Q1/org.openbravo.retail.posterminal
Changeset: a886fa38576ad643866fc0677e8dfabfc0f8a2a3
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Feb 20 09:22:30 2017 +0100
URL: http://code.openbravo.com/retail/backports/3.0RR17Q1/org.openbravo.retail.posterminal/rev/a886fa38576ad643866fc0677e8dfabfc0f8a2a3 [^]

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

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