Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0040498Openbravo ERPA. Platformpublic2019-04-01 10:172022-02-01 07:24
vmromanos 
Triage Platform Base 
normalminoralways
newopen 
5
 
 
Core
No
0040498: Error while importing string with maximum length in Oracle only
OBUIAPP_PROCESS_TRL.NAME column has a length of 60. When the import translation process tries to import a name with length 60 ('Relacionar Nuevo Impuesto y Categoría de Producto a Servicio') y throws an error:

ERROR org.openbravo.erpCommon.ad_forms.TranslationHandler - 183:UPDATE OBUIAPP_PROCESS_Trl SET Name='Relacionar Nuevo Impuesto y Categoría de Producto a Servicio',Description='Proceso de editar las propiedades del impuesto de los servicios asociados a productos',Help='Ejecuta el proceso de editar las propiedades del impuesto de los servicios asociados a productos',Updated=now(),IsTranslated='Y' WHERE OBUIAPP_PROCESS_ID='E0870062F05F4DC88E589ABC6A45DF4C' AND AD_Language='es_ES' AND AD_Client_ID='0'java.sql.SQLException: ORA-12899: value too large for column "MOD_SIMPLE_CI2318101"."OBUIAPP_PROCESS_TRL"."NAME" (actual: 61, maximum: 60)


Important: this only happens in Oracle. In PG the record is successfully imported.
Use a recent PI (19Q2 or above) in Oracle.
Clone the es_ES translation [code.openbravo.com/erp/mods/org.openbravo.localization.spain.referencedata.translation.esES] in version 3.0.1600. No other dependencies are needed.
Run ant install.source.
Check the log and verify the above error message is shown although the length of 'Relacionar Nuevo Impuesto y Categoría de Producto a Servicio' is 60.

Repeat the same example in Postgres.
Check the record is successfully imported.
No tags attached.
Issue History
2019-04-01 10:17vmromanosNew Issue
2019-04-01 10:17vmromanosAssigned To => platform
2019-04-01 10:17vmromanosModules => Core
2019-04-01 10:17vmromanosTriggers an Emergency Pack => No
2019-04-02 14:56AugustoMauchNote Added: 0110967
2022-02-01 07:24alostaleAssigned Toplatform => Triage Platform Base

Notes
(0110967)
AugustoMauch   
2019-04-02 14:56   
Comment by Stefan:

Name column is declared as varchar where for some strange oracle annoyance should be nvarchar.

In short:
varchar 60bytes not characters
nvarchar 60 charaters

And with special characters in UTF-8 some values needs >1 byte.