Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0031208 | Retail Modules | Approval process - online | public | 2015-10-21 16:52 | 2016-01-22 15:32 |
|
| Reporter | aaroncalero | |
| Assigned To | mario_castello | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | RR16Q1 | |
| Merge Request Status | |
| Review Assigned To | guilleaer |
| OBNetwork customer | OBPS |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0031208: The CheckApproval process fails when there are preferences with long values |
| Description | When the CheckApproval process is executed, a query is performed against the ad_preference table, and the searchKey field is converted via a call to to_char.
If there is any preference with a searchKey/value longer than 4000 characters, the query fails (at least in oracle) with the following error:
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 10627, maximum: 4000)
|
| Steps To Reproduce | Create a preference with a value longer than 4000 characters.
Configure some preference for web pos in a way that approval is requested for certain user, and a different user approves it (e.g. deny the Delete Line approval for vallblanca and allow it for Openbravo).
Login in web pos, create a ticket, and follow steps to show the approval popup.
Try to approve the action.
Verify in backend that the CheckApproval process has failed with the error copied above. |
| Proposed Solution | Attached proposed solution. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  Issue31208.diff (747) 2015-10-21 16:52
https://issues.openbravo.com/file_download.php?file_id=8615&type=bug
new_Issue31208.diff (749) 2015-11-04 09:21
https://issues.openbravo.com/file_download.php?file_id=8686&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2015-10-21 16:52 | aaroncalero | New Issue | |
| 2015-10-21 16:52 | aaroncalero | Assigned To | => Retail |
| 2015-10-21 16:52 | aaroncalero | OBNetwork customer | => Yes |
| 2015-10-21 16:52 | aaroncalero | Resolution time | => 1446591600 |
| 2015-10-21 16:52 | aaroncalero | Triggers an Emergency Pack | => No |
| 2015-10-21 16:52 | aaroncalero | File Added: Issue31208.diff | |
| 2015-10-21 16:55 | Orekaria | Status | new => acknowledged |
| 2015-11-03 15:59 | mario_castello | Assigned To | Retail => mario_castello |
| 2015-11-03 15:59 | mario_castello | Status | acknowledged => scheduled |
| 2015-11-04 09:21 | aaroncalero | File Added: new_Issue31208.diff | |
| 2015-11-04 09:22 | aaroncalero | Note Added: 0081464 | |
| 2015-11-11 15:35 | hgbot | Checkin | |
| 2015-11-11 15:35 | hgbot | Note Added: 0081717 | |
| 2015-11-11 15:35 | hgbot | Status | scheduled => resolved |
| 2015-11-11 15:35 | hgbot | Resolution | open => fixed |
| 2015-11-11 15:35 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/e606c76a9a7f35e2b25ac48f686c71651ef466e2 [^] |
| 2015-11-13 13:42 | guilleaer | Review Assigned To | => guilleaer |
| 2015-11-13 13:42 | guilleaer | Status | resolved => closed |
| 2015-11-13 13:42 | guilleaer | Fixed in Version | => RR16Q1 |
| 2016-01-22 11:57 | hgbot | Checkin | |
| 2016-01-22 11:57 | hgbot | Note Added: 0083563 | |
| 2016-01-22 11:57 | hgbot | Status | closed => resolved |
| 2016-01-22 11:57 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/e606c76a9a7f35e2b25ac48f686c71651ef466e2 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/2a3b31384b42c2f7cbe420d2f496e49af8a5c6c3 [^] |
| 2016-01-22 15:32 | marvintm | Status | resolved => closed |