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-04-19 09:47 | |||||||
| Reporter | alostale | View Status | public | |||||||||
| Assigned To | cberner | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| 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 |
|
| There are no notes attached to this issue. |
|
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 | 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |