Openbravo Issue Tracking System - POS2
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0056616POS2POSpublic2024-09-26 17:002024-10-11 14:49
Reporterifernandez 
Assigned Toifernandez 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version24Q4Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0056616: Discount limit constraint violated on update database
DescriptionThe constraint EM_OBDISC_LIMIT_CHK, is used to check in case there's an active limit for the discount, that the limit value has been set to a number higher than 0. When updating an environement, some discounts doesn't pass the check because the the limit is active, but the limit number remains as null.
Steps To ReproduceN/A.
Proposed SolutionCheck the onCreateDefault for EM_OBDISC_LIMITPERORDER in the table M_OFFER and verify that the CASE works fine and sets a 1 in case EM_OBDISC_APPLYONCE is set to true.
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0056560 closed ifernandez Discount limit constraint violated on update database 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2024-10-02 10:20ifernandezTypedefect => backport
2024-10-02 10:20ifernandezTarget Version => 24Q4
2024-10-02 10:32hgbotNote Added: 0169891
2024-10-08 11:48hgbotResolutionopen => fixed
2024-10-08 11:48hgbotStatusscheduled => closed
2024-10-08 11:48hgbotFixed in Version => RR24Q4
2024-10-08 11:48hgbotNote Added: 0170097
2024-10-08 11:48hgbotNote Added: 0170098
2024-10-10 08:37hgbotNote Added: 0170232
2024-10-10 11:35hgbotNote Added: 0170252
2024-10-11 08:56hgbotNote Added: 0170276
2024-10-11 14:49hgbotNote Added: 0170294
2024-10-11 14:49hgbotNote Added: 0170295
2024-10-11 14:49hgbotNote Added: 0170296
2024-10-11 14:49hgbotNote Added: 0170297
2024-10-11 14:49hgbotNote Added: 0170298
2024-10-11 14:49hgbotNote Added: 0170299

Notes
(0169891)
hgbot   
2024-10-02 10:32   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/merge_requests/154 [^]
(0170097)
hgbot   
2024-10-08 11:48   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts [^]
Changeset: 31031e9c78c5b1a780a44c2afaeef4b92f397e0a
Author: Inigo Fernandez <i.fernandez@orisha.com>
Date: 02-10-2024 10:32:54
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/commit/31031e9c78c5b1a780a44c2afaeef4b92f397e0a [^]

Fixes ISSUE-56616: Discount limit constraint violated on update database

---
M src-db/database/model/modifiedTables/M_OFFER.xml
---
(0170098)
hgbot   
2024-10-08 11:48   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/merge_requests/154 [^]
(0170232)
hgbot   
2024-10-10 08:37   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/merge_requests/117 [^]
(0170252)
hgbot   
2024-10-10 11:35   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/160 [^]
(0170276)
hgbot   
2024-10-11 08:56   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/merge_requests/114 [^]
(0170294)
hgbot   
2024-10-11 14:49   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata [^]
Changeset: 2ab2ff3dfdf66c833b4b5ab24b405722af70bad5
Author: Inigo Fernandez <i.fernandez@orisha.com>
Date: 10-10-2024 08:38:18
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/commit/2ab2ff3dfdf66c833b4b5ab24b405722af70bad5 [^]

Fixes ISSUE-56616: Discount limit constraint violated on update database

---
M referencedata/sampledata/The_White_Valley_Group/M_OFFER.xml
---
(0170295)
hgbot   
2024-10-11 14:49   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/merge_requests/117 [^]
(0170296)
hgbot   
2024-10-11 14:49   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata [^]
Changeset: 7ab697667821bf877409a2a222afc8970fb2d03f
Author: Inigo Fernandez <i.fernandez@orisha.com>
Date: 10-10-2024 11:34:23
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/commit/7ab697667821bf877409a2a222afc8970fb2d03f [^]

Fixes ISSUE-56616: Discount limit constraint violated on update database

---
M referencedata/sampledata/The_White_Valley_Group/M_OFFER.xml
---
(0170297)
hgbot   
2024-10-11 14:49   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/160 [^]
(0170298)
hgbot   
2024-10-11 14:49   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata [^]
Changeset: 14d32e80f1eb67ea001683878c16b2771a400066
Author: Inigo Fernandez <i.fernandez@orisha.com>
Date: 11-10-2024 08:58:14
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/commit/14d32e80f1eb67ea001683878c16b2771a400066 [^]

Fixes ISSUE-56616: Discount limit constraint violated on update database

---
M referencedata/sampledata/Retail_Test/M_OFFER.xml
---
(0170299)
hgbot   
2024-10-11 14:49   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/merge_requests/114 [^]