Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Retail Modules] Web POSmajoralways2021-10-11 10:392021-10-15 11:18
Reporterfernando_merinoView Statuspublic 
Assigned ToRetail 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

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

DescriptionThis 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
Steps To Reproduce1. 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 Solution1. Change column definition of the DESCRIPTION field from VARCHAR to NVARCHAR for all the tables affected
TagsNo tags attached.
Attached Filespng file icon AffectedTableRetailPack.png [^] (44,571 bytes) 2021-10-11 10:39

- Relationships Relation Graph ] Dependency Graph ]
related to design defect 0047831 newTriage Finance Openbravo ERP Problem introducing long descriptions in some tables (CORE) 
related to defect 0047765 closedfernando_merino Openbravo ERP Problem posting multiple invoices in the same collection 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2021-10-11 10:39 fernando_merino New Issue
2021-10-11 10:39 fernando_merino Assigned To => Retail
2021-10-11 10:39 fernando_merino File Added: AffectedTableRetailPack.png
2021-10-11 10:39 fernando_merino Triggers an Emergency Pack => No
2021-10-11 10:41 fernando_merino Description Updated View Revisions
2021-10-11 13:29 fernando_merino Relationship added related to 0047831
2021-10-11 13:37 aferraz Category Manual user action => Web POS
2021-10-14 09:53 aferraz Relationship added related to 0047765
2021-10-15 11:18 aferraz Type defect => design defect

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker