Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
ID | ||||||||||||
0040498 | ||||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
defect | [Openbravo ERP] A. Platform | minor | always | 2019-04-01 10:17 | 2022-02-01 07:24 | |||||||
Reporter | vmromanos | View Status | public | |||||||||
Assigned To | Triage Platform Base | |||||||||||
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 | ||||||||||||
Web browser | ||||||||||||
Modules | Core | |||||||||||
Regression level | ||||||||||||
Regression date | ||||||||||||
Regression introduced in release | ||||||||||||
Regression introduced by commit | ||||||||||||
Triggers an Emergency Pack | No | |||||||||||
Summary | 0040498: Error while importing string with maximum length in Oracle only | |||||||||||
Description | 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. | |||||||||||
Steps To Reproduce | 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. | |||||||||||
Tags | No tags attached. | |||||||||||
Attached Files | ||||||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0110967) AugustoMauch (manager) 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 | |
2022-02-01 07:24 | alostale | Assigned To | platform => Triage Platform Base |
Copyright © 2000 - 2009 MantisBT Group |