Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0043392 | Openbravo ERP | 00. Application dictionary | public | 2020-03-02 21:50 | 2021-10-29 10:16 |
|
| Reporter | agonzalez | |
| Assigned To | cberner | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | 3.0PR19Q3.3 | |
| Target Version | | Fixed in Version | PR22Q1 | |
| Merge Request Status | approved |
| 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 | 0043392: Change column type of body column for table C_POC_EMAILDEFINITION to CLOB |
| Description | The column body of the table C_POC_EMAILDEFINITION is currently restricted to 4000 characters at database level, and it's not currently possible to introduce HTML templates of more than 4000 characters. |
| Steps To Reproduce | 1. Go to Document Type -> Report Templates -> Email Definition
2. Try to add a E-mail template with a body that contains a length of more than 4000 characters
3. An error will be raised |
| Proposed Solution | Change the column type of body to CLOB (text in database)
Please check the provided diff file |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | causes | defect | 0047945 | | closed | cberner | API Change: Changed C_POC_EMAIL* body column types from varchar to CLOB |
|
| Attached Files |  c_poc_emaildefinition_columntype.patch (654) 2020-03-02 21:50
https://issues.openbravo.com/file_download.php?file_id=14120&type=bug
c_poc_email_columntype.patch (614) 2020-03-03 16:37
https://issues.openbravo.com/file_download.php?file_id=14127&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2020-03-02 21:50 | agonzalez | New Issue | |
| 2020-03-02 21:50 | agonzalez | Assigned To | => platform |
| 2020-03-02 21:50 | agonzalez | File Added: c_poc_emaildefinition_columntype.patch | |
| 2020-03-02 21:50 | agonzalez | Modules | => Core |
| 2020-03-02 21:50 | agonzalez | Triggers an Emergency Pack | => No |
| 2020-03-03 16:37 | agonzalez | File Added: c_poc_email_columntype.patch | |
| 2020-03-03 17:59 | ucarrion | Note Added: 0118305 | |
| 2021-10-26 14:03 | cberner | Status | new => acknowledged |
| 2021-10-26 14:03 | cberner | Assigned To | platform => cberner |
| 2021-10-26 16:52 | guilleaer | Status | acknowledged => scheduled |
| 2021-10-27 10:21 | hgbot | Merge Request Status | => open |
| 2021-10-27 10:21 | hgbot | Note Added: 0132670 | |
| 2021-10-27 10:28 | cberner | Status | scheduled => acknowledged |
| 2021-10-27 10:37 | cberner | Status | acknowledged => scheduled |
| 2021-10-27 15:44 | AugustoMauch | Note Deleted: 0118305 | |
| 2021-10-28 09:38 | cberner | Relationship added | causes 0047945 |
| 2021-10-28 15:33 | hgbot | Merge Request Status | open => approved |
| 2021-10-29 09:22 | hgbot | Note Added: 0132731 | |
| 2021-10-29 09:22 | hgbot | Resolution | open => fixed |
| 2021-10-29 09:22 | hgbot | Status | scheduled => closed |
| 2021-10-29 09:22 | hgbot | Fixed in Version | => PR22Q1 |
| 2021-10-29 09:22 | hgbot | Note Added: 0132732 | |
| 2021-10-29 09:48 | hgbot | Note Added: 0132735 | |
| 2021-10-29 10:12 | hgbot | Note Added: 0132750 | |
| 2021-10-29 10:16 | hgbot | Note Added: 0132751 | |
| 2021-10-29 10:16 | hgbot | Note Added: 0132752 | |
|
Notes |
|
|
(0132670)
|
|
hgbot
|
|
2021-10-27 10:21
|
|
|
|
|
(0132731)
|
|
hgbot
|
|
2021-10-29 09:22
|
|
|
|
|
(0132732)
|
|
hgbot
|
|
2021-10-29 09:22
|
|
Directly closing issue as related merge request is already approved.
Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 3294ebe59ef4f17f1ddcfdf7974481602df09aab
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 2021-10-29T07:21:50+00:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/3294ebe59ef4f17f1ddcfdf7974481602df09aab [^]
Fixes ISSUE-43392: Change column type of body column for table C_POC_EMAIL* to CLOB
C_POC_EMAIL and C_POC_EMAILDEFINITION column body is updated from
varchar to CLOB. This allows not being limited by the 4000 characters
varchar supported. It also has a side-effect though:
- Oracle requires a table recreation on update.database due to the type
being changed from varchar to clob. Tables will not be recreated in
postgres though, because it changes from varchar to text.
---
M src-db/database/model/tables/C_POC_EMAIL.xml
M src-db/database/model/tables/C_POC_EMAILDEFINITION.xml
M src-db/database/sourcedata/AD_COLUMN.xml
---
|
|
|
|
(0132735)
|
|
hgbot
|
|
2021-10-29 09:48
|
|
|
|
|
(0132750)
|
|
hgbot
|
|
2021-10-29 10:12
|
|
|
|
|
(0132751)
|
|
hgbot
|
|
2021-10-29 10:16
|
|
|
|
|
(0132752)
|
|
hgbot
|
|
2021-10-29 10:16
|
|
Directly closing issue as related merge request is already approved.
Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 6c9dd745e8f8781fccb5883ef97c7132a9d8dcd4
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 2021-10-29T10:10:14+02:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/6c9dd745e8f8781fccb5883ef97c7132a9d8dcd4 [^]
Fixes ISSUE-43392: Change column type of body column for table C_POC_EMAIL* to CLOB
C_POC_EMAIL and C_POC_EMAILDEFINITION column body is updated from
varchar to CLOB. This allows not being limited by the 4000 characters
varchar supported. It also has a side-effect though:
- Oracle requires a table recreation on update.database due to the type
being changed from varchar to clob. Tables will not be recreated in
postgres though, because it changes from varchar to text.
---
M src-db/database/model/tables/C_POC_EMAIL.xml
M src-db/database/model/tables/C_POC_EMAILDEFINITION.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
|
|