Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0047831Openbravo ERPZ. Otherspublic2021-10-11 10:072021-10-15 11:18
fernando_merino 
Triage Omni OMS 
normalmajoralways
newopen 
5
main 
 
Google Chrome
Core
No
0047831: Problem introducing long descriptions in some tables (CORE)
This problem occurs only on an Oracle database. The problem is that the DESCRIPTION field, of some core 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 core affected:

M_INVENTORYSTATUS_TRL
C_PERIODCONTROL_LOG
FIN_PAYMENTMETHOD
AD_APPLICATION
FIN_PAYMENT_PROPOSAL
C_TAXREGISTER_TYPE
C_DP_MANAGEMENT
FIN_PAYMENT_SCHEDULE
M_OFFER
AD_PROCESS_REQUEST
M_OFFER_TYPE
M_INVENTORYSTATUS
C_REJECT_REASON
C_SETTLEMENT
AD_ORGTYPE
FIN_DOUBTFUL_DEBT_METHOD
M_OFFER_TYPE_TRL
M_REFINVENTORY_TYPE
AD_PROCESS_GROUP
OBUIAPP_PROCESS_TRL (Module: org.openbravo.client.application)
OBUIAPP_MENU_PARAMETERS (Module: org.openbravo.client.application)
OBUIAPP_VIEW_IMPL (Module: org.openbravo.client.application)
OBUIAPP_NAVBAR_COMPONENT (Module: org.openbravo.client.application)
OBUIAPP_PROCESS (Module: org.openbravo.client.application)
1. Go to any window that makes use of some of the tables listed above (e.g Payment Method window for the FIN_PAYMENTMETHOD table)
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"."FIN_PAYMENTMETHOD"."DESCRIPTION" (actual: 480, maximum: 255)
1. Change column definition of the DESCRIPTION field from VARCHAR to NVARCHAR for all the tables affected
No tags attached.
related to defect 0047765 closed fernando_merino Openbravo ERP Problem posting multiple invoices in the same collection 
related to design defect 0047832 new Retail Retail Modules Problem introducing long descriptions in some tables (Retail Pack Modules) 
png AffectedTables.png (64,762) 2021-10-11 10:22
https://issues.openbravo.com/file_download.php?file_id=16259&type=bug
png
Issue History
2021-10-11 10:07fernando_merinoNew Issue
2021-10-11 10:07fernando_merinoAssigned To => Triage Finance
2021-10-11 10:07fernando_merinoFile Added: TablesAffected.png
2021-10-11 10:07fernando_merinoWeb browser => Google Chrome
2021-10-11 10:07fernando_merinoModules => Core
2021-10-11 10:07fernando_merinoTriggers an Emergency Pack => No
2021-10-11 10:19fernando_merinoWeb browserGoogle Chrome => Google Chrome
2021-10-11 10:19fernando_merinoDescription Updatedbug_revision_view_page.php?rev_id=23173#r23173
2021-10-11 10:20fernando_merinoFile Added: AffectedTables.png
2021-10-11 10:20fernando_merinoFile Deleted: TablesAffected.png
2021-10-11 10:21fernando_merinoWeb browserGoogle Chrome => Google Chrome
2021-10-11 10:22fernando_merinoFile Deleted: AffectedTables.png
2021-10-11 10:22fernando_merinoFile Added: AffectedTables.png
2021-10-11 13:29fernando_merinoRelationship addedrelated to 0047765
2021-10-11 13:29fernando_merinoRelationship addedrelated to 0047832
2021-10-15 11:18aferrazWeb browserGoogle Chrome => Google Chrome
2021-10-15 11:18aferrazTypedefect => design defect

There are no notes attached to this issue.