0047832: Problem introducing long descriptions in some tables (Retail Pack Modules)

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0047832

Retail Modules

Web POS

public

2021-10-11 10:39

2021-10-15 11:18

Reporter

fernando_merino

Assigned To

Retail

Priority

normal

Severity

major

Reproducibility

always

Status

new

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0047832: Problem introducing long descriptions in some tables (Retail Pack Modules)

Description

This problem occurs only on an Oracle database. The problem is that the DESCRIPTION field, of some retail modules tables listed below, is defined as VARCHAR2(255 BYTE). The DESCRIPTION field is limited to 255 CHARACTERS long, so if all these characters don't exceed the limit of 255 BYTES there is no problem (e.g 255 characters of 1 BYTE each). The problem comes when the description contains characters larger than 1 BYTE. If the description is a long one, for example one with 255 characters, the characters limit is not exceeded, but if it contains some characters larger than 1 BYTE, like for example the º character that occupies 2 BYTES, then the limit of 255 BYTES is exceeded (254 one-byte characters, plus one of 2 bytes make 256 bytes, which do not fit in the field defined in the database). I indicate below all the tables from retail pack modules affected:

org.openbravo.retail.config --> OBRETCO_PRODUCTLIST

org.openbravo.retail.posterminal --> OBPOS_APPROVAL_REASON
org.openbravo.retail.posterminal --> OBPOS_PAYMENTGROUP_TRL
org.openbravo.retail.posterminal --> OBPOS_PAYMENTGROUP

org.openbravo.mobile.core --> OBMOBC_ABA
org.openbravo.mobile.core --> OBMOBC_PROCESS_DEFINITION
org.openbravo.mobile.core --> OBMOBC_ACTION
org.openbravo.mobile.core --> OBMOBC_ABA_LAYVARIANT
org.openbravo.mobile.core --> OBMOBC_UICONFIGURATION
org.openbravo.mobile.core --> OBMOBC_WINDOW

Steps To Reproduce

1. Go to any window that makes use of some of the tables listed above
2. Create a new record and in the DESCRIPTION field input a long description reaching the limit of 255 characters and containing some characters larger than 1 BYTE, like for example the º characters. (Try with this description for example --> This is a description example:ººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººººº)
3. Try to save the record, you will get an error similar to this one: ERROR: Saving failed. ORA-12899: value too large for column "ERP_PI_ORACLE"."<TableName>"."DESCRIPTION" (actual: 480, maximum: 255)

Proposed Solution

1. Change column definition of the DESCRIPTION field from VARCHAR to NVARCHAR for all the tables affected

Additional Information