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 | 2019-04-02 14:56 | |||||||
| Reporter | vmromanos | View Status | public | |||||||||
| Assigned To | platform | |||||||||||
| 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 ]
|
|
 Relationships |
|
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. |
|
Notes |
|
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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |