Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0055223 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [POS2] Core | major | have not tried | 2024-04-17 14:35 | 2024-06-03 17:17 | |||
| Reporter | alostale | View Status | public | |||||
| Assigned To | cberner | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 24Q3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | 24Q2 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | approved | |||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Support ticket | ||||||||
| Regression level | Production - Confirmed Stable | |||||||
| Regression date | 2022-03-10 | |||||||
| Regression introduced in release | 22Q3 | |||||||
| Regression introduced by commit | https://gitlab.com/openbravo/product/pmods/org.openbravo.core2/-/commit/2f9085eac2a9c579fbf9fdaa0958fbbca06ad4cc [^] | |||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0055223: duplicated data fetched as part of offline user masterdata models | |||||||
| Description | When 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 Reproduce | 1. 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 Solution | Inner joins in the queries should be replaced by exists clauses. | |||||||
| Tags | Performance | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
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 --- |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 | Merge Request Status | => open |
| 2024-05-23 10:43 | hgbot | Note Added: 0165009 | |
| 2024-05-23 17:46 | AugustoMauch | Status | new => scheduled |
| 2024-06-03 17:16 | hgbot | Merge Request Status | open => approved |
| 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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |