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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0056616
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[POS2] POSminorhave not tried2024-09-26 17:002024-10-11 14:49
ReporterifernandezView Statuspublic 
Assigned Toifernandez 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version24Q4
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

0056616: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0056560 closedifernandez Discount limit constraint violated on update database 

-  Notes
(0169891)
hgbot (developer)
2024-10-02 10:32

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/merge_requests/154 [^]
(0170097)
hgbot (developer)
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 (developer)
2024-10-08 11:48

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/merge_requests/154 [^]
(0170232)
hgbot (developer)
2024-10-10 08:37

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/merge_requests/117 [^]
(0170252)
hgbot (developer)
2024-10-10 11:35

 Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/160 [^]
(0170276)
hgbot (developer)
2024-10-11 08:56

 Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/merge_requests/114 [^]
(0170294)
hgbot (developer)
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 (developer)
2024-10-11 14:49

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/merge_requests/117 [^]
(0170296)
hgbot (developer)
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 (developer)
2024-10-11 14:49

 Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/160 [^]
(0170298)
hgbot (developer)
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 (developer)
2024-10-11 14:49

 Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/merge_requests/114 [^]

- Issue History
Date Modified Username Field Change
2024-10-02 10:20 ifernandez Type defect => backport
2024-10-02 10:20 ifernandez Target Version => 24Q4
2024-10-02 10:32 hgbot Note Added: 0169891
2024-10-08 11:48 hgbot Resolution open => fixed
2024-10-08 11:48 hgbot Status scheduled => closed
2024-10-08 11:48 hgbot Fixed in Version => RR24Q4
2024-10-08 11:48 hgbot Note Added: 0170097
2024-10-08 11:48 hgbot Note Added: 0170098
2024-10-10 08:37 hgbot Note Added: 0170232
2024-10-10 11:35 hgbot Note Added: 0170252
2024-10-11 08:56 hgbot Note Added: 0170276
2024-10-11 14:49 hgbot Note Added: 0170294
2024-10-11 14:49 hgbot Note Added: 0170295
2024-10-11 14:49 hgbot Note Added: 0170296
2024-10-11 14:49 hgbot Note Added: 0170297
2024-10-11 14:49 hgbot Note Added: 0170298
2024-10-11 14:49 hgbot Note Added: 0170299

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker