Openbravo Issue Tracking System - POS2
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0056617POS2POSpublic2024-09-26 17:002024-10-11 14:51
Reporterifernandez 
Assigned Toifernandez 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version24Q3.2Fixed 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
Summary0056617: 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 => 24Q3.2
2024-10-02 10:29hgbotNote Added: 0169890
2024-10-08 11:49hgbotResolutionopen => fixed
2024-10-08 11:49hgbotStatusscheduled => closed
2024-10-08 11:49hgbotFixed in Version => RR24Q3.2
2024-10-08 11:49hgbotNote Added: 0170099
2024-10-08 11:49hgbotNote Added: 0170100
2024-10-10 08:45hgbotNote Added: 0170234
2024-10-10 11:36hgbotNote Added: 0170253
2024-10-10 11:37hgbotNote Added: 0170254
2024-10-10 11:38hgbotNote Added: 0170255
2024-10-11 08:51hgbotNote Added: 0170275
2024-10-11 14:50aferrazNote Deleted: 0170253
2024-10-11 14:50aferrazNote Deleted: 0170254
2024-10-11 14:50hgbotNote Added: 0170300
2024-10-11 14:50hgbotNote Added: 0170301
2024-10-11 14:51hgbotNote Added: 0170302
2024-10-11 14:51hgbotNote Added: 0170303
2024-10-11 14:51hgbotNote Added: 0170304
2024-10-11 14:51hgbotNote Added: 0170305

Notes
(0169890)
hgbot   
2024-10-02 10:29   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/merge_requests/153 [^]
(0170099)
hgbot   
2024-10-08 11:49   
Directly closing issue as related merge request is already approved.

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

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

---
M src-db/database/model/modifiedTables/M_OFFER.xml
---
(0170100)
hgbot   
2024-10-08 11:49   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/merge_requests/153 [^]
(0170234)
hgbot   
2024-10-10 08:45   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/merge_requests/118 [^]
(0170255)
hgbot   
2024-10-10 11:38   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/162 [^]
(0170275)
hgbot   
2024-10-11 08:51   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/merge_requests/113 [^]
(0170301)
hgbot   
2024-10-11 14:50   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/merge_requests/118 [^]
(0170300)
hgbot   
2024-10-11 14:50   
Directly closing issue as related merge request is already approved.

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

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

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

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

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

---
M referencedata/sampledata/The_White_Valley_Group/M_OFFER.xml
---
(0170304)
hgbot   
2024-10-11 14:51   
Directly closing issue as related merge request is already approved.

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

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

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