Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0047832 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| design defect | [Retail Modules] Web POS | major | always | 2021-10-11 10:39 | 2021-10-15 11:18 | |||||||
| Reporter | fernando_merino | View Status | public | |||||||||
| Assigned To | Retail | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Oracle | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| 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 | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files |  AffectedTableRetailPack.png [^] (44,571 bytes) 2021-10-11 10:39
| |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||||
|
|||||||||||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |