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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0055223
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[POS2] Coremajorhave not tried2024-04-17 14:352024-06-03 17:17
ReporteralostaleView Statuspublic 
Assigned Tocberner 
PrioritynormalResolutionfixedFixed in Version24Q3
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version24Q2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression levelProduction - Confirmed Stable
Regression date2022-03-10
Regression introduced in release22Q3
Regression introduced by commithttps://gitlab.com/openbravo/product/pmods/org.openbravo.core2/-/commit/2f9085eac2a9c579fbf9fdaa0958fbbca06ad4cc [^]
Triggers an Emergency PackNo
Summary

0055223: duplicated data fetched as part of offline user masterdata models

DescriptionWhen requesting data for offline user master data model, lots of duplicated records are fetched. Although they are cleaned up while inserting, it is suboptimal.

Steps To Reproduce1. Log in POS and refresh master data to ensure there is no additional records to fetch
2. Log in BO
3. Check Group - Admin role can approve at least one user action
4. Open User window and select Demouser
5. Update some field (ie. email)
6. Log in POS
7. Refresh masterdata and check the request for OfflineUser model in the network panel
    EXPECTED: 1 row should have been fetched as only one user was modified
    GOT: 28 identical rows, all with the same information for demouser

Proposed SolutionInner joins in the queries should be replaced by exists clauses.
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
caused by feature request 0048528 closedAugustoMauch Offline Approval Improvements 

-  Notes
(0165009)
hgbot (developer)
2024-05-23 10:43

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.core2/-/merge_requests/1496 [^]
(0165488)
hgbot (developer)
2024-06-03 17:17

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.core2/-/merge_requests/1496 [^]
(0165489)
hgbot (developer)
2024-06-03 17:17

 Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.core2 [^]
Changeset: 2dfd17467cdfd2c9215945a389cde1285668f331
Author: adrian.blasco <adrian.blasco@openbravo.com>
Date: 03-06-2024 17:16:28
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.core2/-/commit/2dfd17467cdfd2c9215945a389cde1285668f331 [^]

Fixes ISSUE-55223: In order to provide unique results, inner Joins have been replaced by exists clauses in hql query

---
M src/org/openbravo/core2/master/OfflineUser.java
---

- Issue History
Date Modified Username Field Change
2024-04-17 14:35 alostale New Issue
2024-04-17 14:35 alostale Assigned To => Triage Platform Base
2024-04-17 14:35 alostale Triggers an Emergency Pack => No
2024-04-17 14:37 alostale Regression date => 2022-03-10
2024-04-17 14:37 alostale Regression introduced in release => 22Q3
2024-04-17 14:37 alostale Regression introduced by commit => https://gitlab.com/openbravo/product/pmods/org.openbravo.core2/-/commit/2f9085eac2a9c579fbf9fdaa0958fbbca06ad4cc [^]
2024-04-17 14:38 alostale Tag Attached: Performance
2024-04-17 14:38 alostale Relationship added caused by 0048528
2024-04-17 14:38 alostale Regression level => Production - Confirmed Stable
2024-04-19 09:47 AugustoMauch Assigned To Triage Platform Base => cberner
2024-05-07 16:24 lorenzofidalgo Target Version => 24Q2
2024-05-23 10:43 hgbot Note Added: 0165009
2024-05-23 17:46 AugustoMauch Status new => scheduled
2024-06-03 17:17 hgbot Note Added: 0165488
2024-06-03 17:17 hgbot Resolution open => fixed
2024-06-03 17:17 hgbot Status scheduled => closed
2024-06-03 17:17 hgbot Fixed in Version => 24Q3
2024-06-03 17:17 hgbot Note Added: 0165489

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker