Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0050243Openbravo ERP02. Master data managementpublic2022-09-13 17:412022-11-08 17:41
Reporterdmiguelez 
Assigned Toaferraz 
PriorityhighSeveritytrivialReproducibilityalways
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
Summary0050243: Increase the Column size for Product Characteristics Description
DescriptionAs of today, the Product Characteristics Description size is 2000:
https://gitlab.com/openbravo/product/openbravo/-/blob/master/src-db/database/model/tables/M_PRODUCT.xml#L336 [^]

However, in several clients, we've had to increase the size.
It can be done as a customization, but since it seems to be a general requirement from the market, it is better to increase it in the Product itself

A suggestion is to increase it to 5000

Note. This customization creates some problems in the CI of the custom projects
Steps To Reproducehttps://gitlab.com/openbravo/product/openbravo/-/blob/master/src-db/database/model/tables/M_PRODUCT.xml#L336 [^]

Size is defined as 2000
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0044901 closed Triage Platform Base PostgreSQL fails applying changes to columns used in views (during install.source) 
depends on feature request 0050517 closed aferraz API Change: Increase the Column size for Product Characteristics Description 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-09-13 17:41dmiguelezNew Issue
2022-09-13 17:41dmiguelezAssigned To => Triage Omni OMS
2022-09-13 17:41dmiguelezOBNetwork customer => No
2022-09-13 17:41dmiguelezModules => Core
2022-09-13 17:41dmiguelezTriggers an Emergency Pack => No
2022-09-19 11:28hgbotMerge Request Status => open
2022-09-19 11:28hgbotNote Added: 0141219
2022-10-13 14:22aferrazAssigned ToTriage Omni OMS => aferraz
2022-10-13 14:29aferrazIssue cloned0050517
2022-10-13 14:30aferrazRelationship addeddepends on 0050517
2022-10-19 08:30hgbotMerge Request Statusopen => approved
2022-10-19 10:00hgbotResolutionopen => fixed
2022-10-19 10:00hgbotStatusnew => closed
2022-10-19 10:00hgbotNote Added: 0142269
2022-10-19 10:00hgbotFixed in Version => PR23Q1
2022-10-19 10:00hgbotNote Added: 0142270
2022-11-08 17:33hgbotNote Added: 0143259
2022-11-08 17:33aferrazStatusclosed => new
2022-11-08 17:33aferrazResolutionfixed => open
2022-11-08 17:33aferrazFixed in VersionPR23Q1 =>
2022-11-08 17:38aferrazNote Added: 0143260
2022-11-08 17:39aferrazReview Assigned To => aferraz
2022-11-08 17:39aferrazStatusnew => closed
2022-11-08 17:39aferrazResolutionopen => suspended
2022-11-08 17:41aferrazRelationship addedrelated to 0044901

Notes
(0141219)
hgbot   
2022-09-19 11:28   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/716 [^]
(0142269)
hgbot   
2022-10-19 10:00   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/716 [^]
(0142270)
hgbot   
2022-10-19 10:00   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 4b761627228c1e790721847f6f55fe1360118168
Author: Álvaro Ferraz <alvaro.ferraz@openbravo.com>
Date: 19-10-2022 08:00:24
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/4b761627228c1e790721847f6f55fe1360118168 [^]

Fixes ISSUE-50243: Increase the Column size for Product Characteristics Description

---
M src-db/database/model/tables/M_PRODUCT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0143259)
hgbot   
2022-11-08 17:33   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 9ace852007632783694b4c2c07bfe47709340135
Author: Álvaro Ferraz <alvaro.ferraz@openbravo.com>
Date: 08-11-2022 16:32:59
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/9ace852007632783694b4c2c07bfe47709340135 [^]

Revert "Fixes ISSUE-50243: Increase the Column size for Product Characteristics Description"

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