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 | 2024-11-21 11:03 | |||
| Reporter | vmromanos | View Status | public | |||||
| Assigned To | Triage Platform Base | |||||||
| Priority | normal | Resolution | out of date | Fixed in Version | ||||
| Status | closed | 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 | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| 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 (administrator) 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. |
|
(0172385) shuehner (administrator) 2024-11-21 11:03 |
Oracle database is no longer supported |
|
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 | OBNetwork customer | => No |
| 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 |
| 2024-11-21 11:03 | shuehner | Note Added: 0172385 | |
| 2024-11-21 11:03 | shuehner | Status | new => closed |
| 2024-11-21 11:03 | shuehner | Resolution | open => out of date |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |