Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0040498 | Openbravo ERP | A. Platform | public | 2019-04-01 10:17 | 2024-11-21 11:03 |
| Reporter | vmromanos | ||||
| Assigned To | Triage Platform Base | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | out of date | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| 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. | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| 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 | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||