Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0040498
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2019-04-01 10:172019-04-02 14:56
ReportervmromanosView Statuspublic 
Assigned Toplatform 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0040498: Error while importing string with maximum length in Oracle only

DescriptionOBUIAPP_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.
Steps To ReproduceUse 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0110967)
AugustoMauch (developer)
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.

- Issue History
Date Modified Username Field Change
2019-04-01 10:17 vmromanos New Issue
2019-04-01 10:17 vmromanos Assigned To => platform
2019-04-01 10:17 vmromanos Modules => Core
2019-04-01 10:17 vmromanos Triggers an Emergency Pack => No
2019-04-02 14:56 AugustoMauch Note Added: 0110967


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker