Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0050517Openbravo ERP02. Master data managementpublic2022-10-13 14:292022-11-08 17:39
Reporteraferraz 
Assigned Toaferraz 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionsuspended 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Statusapproved
Review Assigned Toaferraz
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0050517: API Change: Increase the Column size for Product Characteristics Description
DescriptionIncrease M_PRODUCT.CHARACTERISTIC_DESC column size from 2000 to 4000.

The risk is low as it only could affect to columns where characteristic_desc value is copied to.

a.) where does this column data get copied into => May need to be increased as well.
pl-variables (if not type with type%)
other columns of nvarchar 2k
=> That is general thing to check for any column size change
=> Annoying => runtime error if we miss anything
Steps To Reproduce*
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks feature request 0050243 closed aferraz Increase the Column size for Product Characteristics Description 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-10-13 14:29aferrazNew Issue
2022-10-13 14:29aferrazAssigned To => aferraz
2022-10-13 14:29aferrazOBNetwork customer => No
2022-10-13 14:29aferrazModules => Core
2022-10-13 14:29aferrazTriggers an Emergency Pack => No
2022-10-13 14:29aferrazIssue generated from0050243
2022-10-13 14:30aferrazRelationship addedblocks 0050243
2022-10-13 15:01hgbotMerge Request Status => open
2022-10-13 15:01hgbotNote Added: 0142025
2022-10-19 09:51hgbotMerge Request Statusopen => approved
2022-10-19 10:00hgbotResolutionopen => fixed
2022-10-19 10:00hgbotStatusnew => closed
2022-10-19 10:00hgbotNote Added: 0142267
2022-10-19 10:00hgbotNote Added: 0142268
2022-11-08 17:31hgbotNote Added: 0143258
2022-11-08 17:32aferrazStatusclosed => new
2022-11-08 17:32aferrazResolutionfixed => open
2022-11-08 17:39aferrazReview Assigned To => aferraz
2022-11-08 17:39aferrazNote Added: 0143261
2022-11-08 17:39aferrazStatusnew => closed
2022-11-08 17:39aferrazResolutionopen => suspended

Notes
(0142025)
hgbot   
2022-10-13 15:01   
Merge Request created: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/37 [^]
(0142267)
hgbot   
2022-10-19 10:00   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/ci/backoffice-api [^]
Changeset: 077cfe7f620fdd6731c3c6ec6391ac02840370cc
Author: Álvaro Ferraz <alvaro.ferraz@openbravo.com>
Date: 19-10-2022 07:58:07
URL: https://gitlab.com/openbravo/ci/backoffice-api/-/commit/077cfe7f620fdd6731c3c6ec6391ac02840370cc [^]

Fixes ISSUE-50517: API Change: Increase the Column size for Product Characteristics Description

---
M model/src-db/database/model/tables/M_PRODUCT.xml
M model/src-db/database/sourcedata/AD_COLUMN.xml
---
(0142268)
hgbot   
2022-10-19 10:00   
Merge request merged: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/37 [^]
(0143258)
hgbot   
2022-11-08 17:31   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/ci/backoffice-api [^]
Changeset: 214525fdb226f7857b59bc3de1b9c028f01db5f3
Author: Álvaro Ferraz <alvaro.ferraz@openbravo.com>
Date: 08-11-2022 16:31:55
URL: https://gitlab.com/openbravo/ci/backoffice-api/-/commit/214525fdb226f7857b59bc3de1b9c028f01db5f3 [^]

Revert "Fixes ISSUE-50517: API Change: Increase the Column size for Product Characteristics Description"

This reverts commit 077cfe7f620fdd6731c3c6ec6391ac02840370cc
---
M model/src-db/database/model/tables/M_PRODUCT.xml
M model/src-db/database/sourcedata/AD_COLUMN.xml
---
(0143261)
aferraz   
2022-11-08 17:39   
Reverted as 4000 NVARCHAR is not allowed in Oracle using a valid OB configuration.
It will be changed in needed customer templates.