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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035286
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorhave not tried2017-02-16 16:152017-03-06 13:42
ReporterplujanView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionfixedFixed in VersionRR17Q2
StatusclosedFix in branchFixed in SCM revision796f4eab7e93
ProjectionnoneETAnoneTarget Version
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

0035286: [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 ]
depends on backport 0035291RR17Q1 closedmarvintm [RR17Q1] Login error due a performance problem with Business Partner selector using Local Data 

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

- Issue History
Date Modified Username Field Change
2017-02-16 16:15 plujan New Issue
2017-02-16 16:15 plujan Assigned To => Retail
2017-02-16 16:15 plujan Regression level => Packaging and release
2017-02-16 16:15 plujan Regression introduced in release => main
2017-02-16 16:15 plujan Triggers an Emergency Pack => No
2017-02-16 16:21 lorenzofidalgo Summary [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:31 marvintm Status new => scheduled
2017-02-17 08:31 marvintm Assigned To Retail => marvintm
2017-02-20 09:21 hgbot Checkin
2017-02-20 09:21 hgbot Note Added: 0094455
2017-02-20 09:21 hgbot Status scheduled => resolved
2017-02-20 09:21 hgbot Resolution open => fixed
2017-02-20 09:21 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/796f4eab7e9381485906fbd92fe844f61e1759c1 [^]
2017-03-06 13:42 guilleaer Review Assigned To => guilleaer
2017-03-06 13:42 guilleaer Status resolved => closed
2017-03-06 13:42 guilleaer Fixed in Version => RR17Q2

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker