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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0056560
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[POS2] POSminorhave not tried2024-09-26 17:002024-10-08 12:41
ReporterifernandezView Statuspublic 
Assigned Toifernandez 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
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

0056560: 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 ]
depends on backport 005661624Q4 closedifernandez Discount limit constraint violated on update database 
depends on backport 005661724Q3.2 closedifernandez Discount limit constraint violated on update database 

-  Notes
(0169887)
hgbot (developer)
2024-10-02 09:55

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/merge_requests/152 [^]
(0169909)
hgbot (developer)
2024-10-02 17:10

Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/159 [^]
(0169961)
hgbot (developer)
2024-10-03 15:28

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/merge_requests/116 [^]
(0170091)
hgbot (developer)
2024-10-08 11:47

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/merge_requests/152 [^]
(0170092)
hgbot (developer)
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 (developer)
2024-10-08 11:47

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

Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/159 [^]
(0170102)
hgbot (developer)
2024-10-08 12:33

Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/merge_requests/112 [^]
(0170103)
hgbot (developer)
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 (developer)
2024-10-08 12:41

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

- Issue History
Date Modified Username Field Change
2024-09-26 17:00 ifernandez New Issue
2024-09-26 17:00 ifernandez Assigned To => rafademiguel
2024-09-26 17:00 ifernandez Triggers an Emergency Pack => No
2024-09-26 17:07 rafademiguel Assigned To rafademiguel => ifernandez
2024-09-26 17:07 rafademiguel Issue Monitored: rafademiguel
2024-10-02 09:55 hgbot Note Added: 0169887
2024-10-02 10:20 ifernandez Status new => scheduled
2024-10-02 17:10 hgbot Note Added: 0169909
2024-10-03 15:28 hgbot Note Added: 0169961
2024-10-04 12:17 hgbot Note Added: 0170003
2024-10-04 14:45 hgbot Note Added: 0170013
2024-10-08 11:44 aferraz Note Deleted: 0170003
2024-10-08 11:44 aferraz Note Deleted: 0170013
2024-10-08 11:47 hgbot Note Added: 0170091
2024-10-08 11:47 hgbot Resolution open => fixed
2024-10-08 11:47 hgbot Status scheduled => closed
2024-10-08 11:47 hgbot Fixed in Version => RR25Q1
2024-10-08 11:47 hgbot Note Added: 0170092
2024-10-08 11:47 hgbot Note Added: 0170093
2024-10-08 11:47 hgbot Note Added: 0170094
2024-10-08 11:47 hgbot Note Added: 0170095
2024-10-08 11:47 hgbot Note Added: 0170096
2024-10-08 12:33 hgbot Note Added: 0170102
2024-10-08 12:41 hgbot Note Added: 0170103
2024-10-08 12:41 hgbot Note Added: 0170104


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker