Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0056617 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [POS2] POS | minor | have not tried | 2024-09-26 17:00 | 2024-10-11 14:51 | |||
| Reporter | ifernandez | View Status | public | |||||
| Assigned To | ifernandez | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | 24Q3.2 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0056617: Discount limit constraint violated on update database | |||||||
| Description | The 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 Reproduce | N/A. | |||||||
| Proposed Solution | Check 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0169890) hgbot (developer) 2024-10-02 10:29 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/merge_requests/153 [^] |
|
(0170099) hgbot (developer) 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 (developer) 2024-10-08 11:49 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/merge_requests/153 [^] |
|
(0170234) hgbot (developer) 2024-10-10 08:45 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/merge_requests/118 [^] |
|
(0170255) hgbot (developer) 2024-10-10 11:38 |
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/162 [^] |
|
(0170275) hgbot (developer) 2024-10-11 08:51 |
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/merge_requests/113 [^] |
|
(0170300) hgbot (developer) 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 --- |
|
(0170301) hgbot (developer) 2024-10-11 14:50 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/merge_requests/118 [^] |
|
(0170302) hgbot (developer) 2024-10-11 14:51 |
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/162 [^] |
|
(0170303) hgbot (developer) 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 (developer) 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 (developer) 2024-10-11 14:51 |
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/merge_requests/113 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2024-10-02 10:20 | ifernandez | Type | defect => backport |
| 2024-10-02 10:20 | ifernandez | Target Version | => 24Q3.2 |
| 2024-10-02 10:29 | hgbot | Note Added: 0169890 | |
| 2024-10-08 11:49 | hgbot | Resolution | open => fixed |
| 2024-10-08 11:49 | hgbot | Status | scheduled => closed |
| 2024-10-08 11:49 | hgbot | Fixed in Version | => RR24Q3.2 |
| 2024-10-08 11:49 | hgbot | Note Added: 0170099 | |
| 2024-10-08 11:49 | hgbot | Note Added: 0170100 | |
| 2024-10-10 08:45 | hgbot | Note Added: 0170234 | |
| 2024-10-10 11:36 | hgbot | Note Added: 0170253 | |
| 2024-10-10 11:37 | hgbot | Note Added: 0170254 | |
| 2024-10-10 11:38 | hgbot | Note Added: 0170255 | |
| 2024-10-11 08:51 | hgbot | Note Added: 0170275 | |
| 2024-10-11 14:50 | aferraz | Note Deleted: 0170253 | |
| 2024-10-11 14:50 | aferraz | Note Deleted: 0170254 | |
| 2024-10-11 14:50 | hgbot | Note Added: 0170300 | |
| 2024-10-11 14:50 | hgbot | Note Added: 0170301 | |
| 2024-10-11 14:51 | hgbot | Note Added: 0170302 | |
| 2024-10-11 14:51 | hgbot | Note Added: 0170303 | |
| 2024-10-11 14:51 | hgbot | Note Added: 0170304 | |
| 2024-10-11 14:51 | hgbot | Note Added: 0170305 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |