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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0051583
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[POS2] POSmajorhave not tried2023-02-13 14:492023-02-24 00:17
Reportermeriem_azafView Statuspublic 
Assigned Tomeriem_azaf 
PrioritynormalResolutionfixedFixed in Version23Q2
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0051583: Create several key map category with the same label in the same restaurant

DescriptionPROD PROBLEM - It is possible to create several key map category with the same label in the same restaurant.

Caused by that, an error is logged in EWI.

org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "obpos2_keymap_cat_uniq"
  Detail: Key (obpos2_keymap_version_id, name, ad_org_id)=(BCEA33C8F885468EA59A71DF67932601, TEST JIRA 3607, 8D0958A3134F47E08A4634B5F38E979F) already exists.
Steps To Reproduce1- Login in POS2.
2- Go to keymapEditor.
3- Choose one of them.
4- Click on view categories.
5- Create a first category.
6- Create a second one with the same label and save.

→ KO, after the second save an error appears in EWI as described below.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 005163723Q1.1 closedmeriem_azaf Create several key map category with the same label in the same restaurant 

-  Notes
(0146466)
hgbot (developer)
2023-02-13 14:55

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/1521 [^]
(0146947)
hgbot (developer)
2023-02-24 00:17

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/1521 [^]
(0146948)
hgbot (developer)
2023-02-24 00:17

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^]
Changeset: bcf7eea6c3b5d5c5b01b4082e12042b431f69acb
Author: Meriem Azaf <meriem.azaf@openbravo.com>
Date: 24-02-2023 00:16:20
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/bcf7eea6c3b5d5c5b01b4082e12042b431f69acb [^]

Fixes ISSUE-51583: Create several key map category with the same label in the same restaurant

PROD PROBLEM - It is possible to create several key map category with the same label in the same restaurant.

The problem was a violation of a unique constraint.

To prevent this, we added a part of the code that check if a category already exist with same label.

---
M src-db/database/sourcedata/AD_MESSAGE.xml
M web-jspack/org.openbravo.pos2/src/components/KeyMapEditor/KeymapEditorNewCategoryDialog/KeymapEditorCategoryDialog.jsx
M web-jspack/org.openbravo.pos2/src/components/KeyMapEditor/KeymapEditorNewCategoryDialog/__test__/KeymapEditorCategoryDialog.test.jsx
---

- Issue History
Date Modified Username Field Change
2023-02-13 14:49 meriem_azaf New Issue
2023-02-13 14:49 meriem_azaf Assigned To => Retail
2023-02-13 14:49 meriem_azaf Triggers an Emergency Pack => No
2023-02-13 14:50 meriem_azaf Assigned To Retail => meriem_azaf
2023-02-13 14:50 meriem_azaf Status new => scheduled
2023-02-13 14:55 hgbot Note Added: 0146466
2023-02-16 17:43 guilleaer Status scheduled => acknowledged
2023-02-16 17:43 guilleaer Status acknowledged => scheduled
2023-02-24 00:17 hgbot Resolution open => fixed
2023-02-24 00:17 hgbot Status scheduled => closed
2023-02-24 00:17 hgbot Fixed in Version => 23Q2
2023-02-24 00:17 hgbot Note Added: 0146947
2023-02-24 00:17 hgbot Note Added: 0146948


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker