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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0058124
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[POS2] POSmajoralways2025-02-27 10:322025-03-11 12:59
ReportermalsasuaView Statuspublic 
Assigned Tocberner 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version25Q1.1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerGold
Support ticket122789
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0058124: updating to 24Q4, the invariants stock option is disabled

DescriptionUpdating 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 Reproducein 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

TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0058092 closedcberner updating to 24Q4, the invariants stock option is disabled 

-  Notes
(0176632)
hgbot (developer)
2025-03-10 18:18

 Merge Request created: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.pos2.detailedstock/-/merge_requests/17 [^]
(0176662)
hgbot (developer)
2025-03-11 12:59

 Merge request merged: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.pos2.detailedstock/-/merge_requests/17 [^]
(0176663)
hgbot (developer)
2025-03-11 12:59

 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: 9e96af5012408f1896870f5369c08ac394555fa3
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 10-03-2025 18:17:48
URL: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.pos2.detailedstock/-/commit/9e96af5012408f1896870f5369c08ac394555fa3 [^]

Fixes ISSUE-58124: 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
---

- Issue History
Date Modified Username Field Change
2025-03-03 12:34 cberner Type defect => backport
2025-03-03 12:34 cberner Target Version => 25Q1.1
2025-03-10 18:18 hgbot Merge Request Status => open
2025-03-10 18:18 hgbot Note Added: 0176632
2025-03-11 11:38 hgbot Merge Request Status open => approved
2025-03-11 12:59 hgbot Note Added: 0176662
2025-03-11 12:59 hgbot Resolution open => fixed
2025-03-11 12:59 hgbot Status scheduled => closed
2025-03-11 12:59 hgbot Note Added: 0176663

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker