Openbravo Issue Tracking System - POS2
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0056560POS2POSpublic2024-09-26 17:002024-10-08 12:41
Reporterifernandez 
Assigned Toifernandez 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed 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
Summary0056560: 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
depends on backport 005661624Q4 closed ifernandez Discount limit constraint violated on update database 
depends on backport 005661724Q3.2 closed ifernandez Discount limit constraint violated on update database 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2024-09-26 17:00ifernandezNew Issue
2024-09-26 17:00ifernandezAssigned To => rafademiguel
2024-09-26 17:00ifernandezTriggers an Emergency Pack => No
2024-09-26 17:07rafademiguelAssigned Torafademiguel => ifernandez
2024-09-26 17:07rafademiguelIssue Monitored: rafademiguel
2024-10-02 09:55hgbotNote Added: 0169887
2024-10-02 10:20ifernandezStatusnew => scheduled
2024-10-02 17:10hgbotNote Added: 0169909
2024-10-03 15:28hgbotNote Added: 0169961
2024-10-04 12:17hgbotNote Added: 0170003
2024-10-04 14:45hgbotNote Added: 0170013
2024-10-08 11:44aferrazNote Deleted: 0170003
2024-10-08 11:44aferrazNote Deleted: 0170013
2024-10-08 11:47hgbotNote Added: 0170091
2024-10-08 11:47hgbotResolutionopen => fixed
2024-10-08 11:47hgbotStatusscheduled => closed
2024-10-08 11:47hgbotFixed in Version => RR25Q1
2024-10-08 11:47hgbotNote Added: 0170092
2024-10-08 11:47hgbotNote Added: 0170093
2024-10-08 11:47hgbotNote Added: 0170094
2024-10-08 11:47hgbotNote Added: 0170095
2024-10-08 11:47hgbotNote Added: 0170096
2024-10-08 12:33hgbotNote Added: 0170102
2024-10-08 12:41hgbotNote Added: 0170103
2024-10-08 12:41hgbotNote Added: 0170104

Notes
(0169887)
hgbot   
2024-10-02 09:55   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/merge_requests/152 [^]
(0169909)
hgbot   
2024-10-02 17:10   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/159 [^]
(0169961)
hgbot   
2024-10-03 15:28   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/merge_requests/116 [^]
(0170091)
hgbot   
2024-10-08 11:47   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/merge_requests/152 [^]
(0170092)
hgbot   
2024-10-08 11:47   
Directly closing issue as related merge request is already approved.

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

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

---
M src-db/database/model/modifiedTables/M_OFFER.xml
---
(0170093)
hgbot   
2024-10-08 11:47   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/merge_requests/116 [^]
(0170094)
hgbot   
2024-10-08 11:47   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata [^]
Changeset: bcab159eb1c05aa87b3d1041c9ad7b1a5f1d41e0
Author: Inigo Fernandez <i.fernandez@orisha.com>
Date: 03-10-2024 15:25:05
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/commit/bcab159eb1c05aa87b3d1041c9ad7b1a5f1d41e0 [^]

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

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

Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata [^]
Changeset: 43effdbd35f52ea6f5e6c37f0b86ea9cf3f3b257
Author: Inigo Fernandez <i.fernandez@orisha.com>
Date: 02-10-2024 17:10:35
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/commit/43effdbd35f52ea6f5e6c37f0b86ea9cf3f3b257 [^]

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

---
M referencedata/sampledata/The_White_Valley_Group/M_OFFER.xml
---
(0170096)
hgbot   
2024-10-08 11:47   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/159 [^]
(0170102)
hgbot   
2024-10-08 12:33   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/merge_requests/112 [^]
(0170103)
hgbot   
2024-10-08 12:41   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata [^]
Changeset: 3400ec00efcd61473857ee322cf532ef87425e55
Author: Inigo Fernandez <i.fernandez@orisha.com>
Date: 08-10-2024 12:34:03
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/commit/3400ec00efcd61473857ee322cf532ef87425e55 [^]

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

---
M referencedata/sampledata/Retail_Test/M_OFFER.xml
---
(0170104)
hgbot   
2024-10-08 12:41   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/merge_requests/112 [^]