Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0035291
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Retail Modules] Web POSmajorhave not tried2017-02-16 16:152017-03-07 17:16
ReporterplujanView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionfixedFixed in VersionRR17Q1
StatusclosedFix in branchFixed in SCM revisiona886fa38576a
ProjectionnoneETAnoneTarget VersionRR17Q1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionmainSCM revision 
Review Assigned Toguilleaer
Regression levelPackaging and release
Regression date
Regression introduced in releasemain
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035291: [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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0035286 closedmarvintm [RR17Q1] Login error due a performance problem with Business Partner selector using Local Data 

-  Notes
(0094456)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2017-02-17 08:31 marvintm Type defect => backport
2017-02-17 08:31 marvintm Target Version => RR17Q1
2017-02-17 08:31 marvintm Assigned To Retail => marvintm
2017-02-20 09:22 hgbot Checkin
2017-02-20 09:22 hgbot Note Added: 0094456
2017-02-20 09:22 hgbot Status scheduled => resolved
2017-02-20 09:22 hgbot Resolution open => fixed
2017-02-20 09:22 hgbot Fixed in SCM revision => http://code.openbravo.com/retail/backports/3.0RR17Q1/org.openbravo.retail.posterminal/rev/a886fa38576ad643866fc0677e8dfabfc0f8a2a3 [^]
2017-03-07 17:16 guilleaer Review Assigned To => guilleaer
2017-03-07 17:16 guilleaer Status resolved => closed
2017-03-07 17:16 guilleaer Fixed in Version => RR17Q1


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker