Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0058092 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [POS2] POS | major | always | 2025-02-27 10:32 | 2025-03-07 14:57 | |||
| Reporter | malsasua | View Status | public | |||||
| Assigned To | cberner | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| 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 | 0058092: updating to 24Q4, the invariants stock option is disabled | |||||||
| Description | Updating from 24Q2 to 24Q4, the invariants stock option is disabled in some products (see attachment1). After update, the following query should not return results: select count(1) from m_product where row_characteristic <> em_obdest_rcharacteristic or column_characteristic <> em_obdest_ccharacteristic or characteristicdimensionenabled <> em_obdest_enabled During the update, the modulescript MigrateDetailedStockColumnsToCharacteristicDimensions was executed | |||||||
| Steps To Reproduce | in 24Q2 . login in POS2 . add one line . click in the line -> Product Card -> Other Stock -> 3 points: the Product Variant Stock option is enabled update to 24Q4 . login in POS2 . add one line . click in the line -> Product Card -> Other Stock -> 3 points: the Product Variant Stock option is disabled | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  attachment1.png [^] (31,603 bytes) 2025-02-27 10:32
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0176366) cberner (developer) 2025-03-03 14:23 |
Checking the modulescript, it looks fine. The modulescript in charge of updating the columns row_characteristic, column_characteristic and characteristicdimensionenabled is executed on the proper versions. It is executed on any version of the module prior to "1.0.242900", so, any version that is afterwards updated to 24Q3 or a newer version will execute the modulescript. It is not at all clear what happened in this case, that it required to be run manually, it is not reproducible with our sampledatas(upgrading from 24Q2 to 24Q3). |
|
(0176530) hgbot (developer) 2025-03-06 14:06 |
Merge Request created: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.pos2.detailedstock/-/merge_requests/15 [^] |
|
(0176560) hgbot (developer) 2025-03-07 14:57 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.pos2.detailedstock [^] Changeset: 58b1ed467a56e4dcd757520a1d00688752cf5980 Author: Cristian Berner <cristian.berner@openbravo.com> Date: 06-03-2025 14:04:00 URL: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.pos2.detailedstock/-/commit/58b1ed467a56e4dcd757520a1d00688752cf5980 [^] Fixes ISSUE-58092: updating to 24Q4, the invariants stock option is disabled The modulescript was failing to update from 24Q2 to 24Q4 in several cases, it seems the problem comes from the column check of characteristicdimensionenabled, when it is null, the where clause returns false incorrectly. characteristicdimensionenabled <> em_obdest_enabled -> returns false when the former is NULL NULL <> 'N'/'Y' -> Returns false --- M build/classes/org/openbravo/pos2/detailedstock/modulescript/MigrateDetailedStockColumnsToCharacteristicDimensions.class M src-util/modulescript/src/org/openbravo/pos2/detailedstock/modulescript/MigrateDetailedStockColumnsToCharacteristicDimensions.java --- |
|
(0176561) hgbot (developer) 2025-03-07 14:57 |
Merge request merged: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.pos2.detailedstock/-/merge_requests/15 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2025-02-27 10:32 | malsasua | New Issue | |
| 2025-02-27 10:32 | malsasua | Assigned To | => Retail |
| 2025-02-27 10:32 | malsasua | File Added: attachment1.png | |
| 2025-02-27 10:32 | malsasua | Triggers an Emergency Pack | => No |
| 2025-02-27 11:40 | guillermogil | Assigned To | Retail => Triage Omni OMS |
| 2025-02-27 19:07 | aferraz | Relationship added | caused by 0055463 |
| 2025-02-27 19:11 | aferraz | Assigned To | Triage Omni OMS => Triage Platform Base |
| 2025-02-28 09:17 | cberner | Assigned To | Triage Platform Base => cberner |
| 2025-03-03 12:34 | cberner | Status | new => scheduled |
| 2025-03-03 14:23 | cberner | Note Added: 0176366 | |
| 2025-03-03 14:23 | cberner | Status | scheduled => feedback |
| 2025-03-06 10:10 | cberner | Status | feedback => scheduled |
| 2025-03-06 14:06 | hgbot | Note Added: 0176530 | |
| 2025-03-07 14:57 | hgbot | Resolution | open => fixed |
| 2025-03-07 14:57 | hgbot | Status | scheduled => closed |
| 2025-03-07 14:57 | hgbot | Note Added: 0176560 | |
| 2025-03-07 14:57 | hgbot | Note Added: 0176561 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |