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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0051637
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[POS2] POSmajorhave not tried2023-02-13 14:492023-02-24 14:01
Reportermeriem_azafView Statuspublic 
Assigned Tomeriem_azaf 
PrioritynormalResolutionfixedFixed in Version23Q1
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version23Q1.1
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

0051637: 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 ]
blocks defect 0051583 closedmeriem_azaf Create several key map category with the same label in the same restaurant 

-  Notes
(0146956)
hgbot (developer)
2023-02-24 08:51

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/1546 [^]
(0146985)
hgbot (developer)
2023-02-24 14:01

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/1546 [^]
(0146986)
hgbot (developer)
2023-02-24 14:01

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^]
Changeset: d1f188bffbee9b950e2adc631b3b8a222af54b4a
Author: Meriem Azaf <meriem.azaf@openbravo.com>
Date: 24-02-2023 13:51:01
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/d1f188bffbee9b950e2adc631b3b8a222af54b4a [^]

Fixes ISSUE-51637: 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-16 17:43 guilleaer Type defect => backport
2023-02-16 17:43 guilleaer Target Version => 23Q1
2023-02-22 11:41 marvintm Target Version 23Q1 => 23Q1.1
2023-02-24 08:51 hgbot Note Added: 0146956
2023-02-24 14:01 hgbot Note Added: 0146985
2023-02-24 14:01 hgbot Resolution open => fixed
2023-02-24 14:01 hgbot Status scheduled => closed
2023-02-24 14:01 hgbot Fixed in Version => 23Q1
2023-02-24 14:01 hgbot Note Added: 0146986


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker