Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0019781 | Openbravo ERP | A. Platform | public | 2012-02-15 17:37 | 2012-04-01 20:38 |
|
| Reporter | mirurita | |
| Assigned To | migueldejuana | |
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | 3.0MP7.1 | |
| Target Version | 3.0MP10 | Fixed in Version | 3.0MP10 | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 14338 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0019781: Audit trail fails with tables having CLOB type columns (i.e. ad_process_request) |
| Description | [only tested in oracle]
After you set as 'Fully Audit' a table having CLOB type column/s (for example ad_process_request).
When you run 'Update Audit Trail infrastructure' process it creates an 'invalid' trigger 'AU_AD_Process_Request_TRG' that does not compile.
the problem is with OB_CONTEXT column.
In the trigger it's trying to assign a CLOB variable to a NUMBER type.
V_OLD_NUMBER NUMBER := NULL;
V_NEW_NUMBER NUMBER := NULL;
IF (UPDATING AND COALESCE(:NEW.OB_CONTEXT, -1) != COALESCE(:OLD.OB_CONTEXT, -1))
OR DELETING OR INSERTING THEN
IF (UPDATING OR INSERTING) THEN
V_NEW_NUMBER := :NEW.OB_CONTEXT;
END IF;
IF (UPDATING OR DELETING) THEN
V_OLD_NUMBER := :OLD.OB_CONTEXT;
END IF;
|
| Steps To Reproduce | 1) Enable the instance.
2) Enable the audit trail for 'ad_process_request' table.
As system administrator go to table and turn on fully audited flag.
3) As system administrator run the 'Update Audit Trail infrastructure' process.
4) Create a new process request.
5) Modify any of the fields and when trying to save you will get an error (see attached screenshot). |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | design defect | 0019982 | | closed | alostale | Audit trail support for CLOB/Text | | related to | defect | 0020363 | 3.0MP13 | closed | alostale | If you put the table OBUIAPP_UIPersonalization as fully audited it does not work form or view personalization |
|
| Attached Files |  AuditTrail_clob.png (40,688) 2012-02-15 17:37
https://issues.openbravo.com/file_download.php?file_id=4999&type=bug
|
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2012-02-15 17:37 | mirurita | New Issue | |
| 2012-02-15 17:37 | mirurita | Assigned To | => alostale |
| 2012-02-15 17:37 | mirurita | File Added: AuditTrail_clob.png | |
| 2012-02-15 17:37 | mirurita | Modules | => Core |
| 2012-02-15 17:37 | mirurita | OBNetwork customer | => No |
| 2012-02-16 17:03 | mirurita | Severity | major => minor |
| 2012-02-16 17:13 | egoitz | OBNetwork customer | No => Yes |
| 2012-02-16 17:13 | egoitz | Support ticket | => 14338 |
| 2012-02-16 17:13 | egoitz | Resolution time | => 1333576800 |
| 2012-02-16 17:13 | egoitz | Target Version | => 3.0MP10 |
| 2012-02-21 17:28 | alostale | Assigned To | alostale => migueldejuana |
| 2012-03-08 08:05 | hgbot | Checkin | |
| 2012-03-08 08:05 | hgbot | Note Added: 0046156 | |
| 2012-03-08 08:05 | hgbot | Status | new => resolved |
| 2012-03-08 08:05 | hgbot | Resolution | open => fixed |
| 2012-03-08 08:05 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/c5bc41eed924d01965eb0fd82080d0b9600b83b5 [^] |
| 2012-03-08 08:06 | alostale | Note Added: 0046157 | |
| 2012-03-08 08:06 | alostale | Status | resolved => closed |
| 2012-03-08 08:06 | alostale | Fixed in Version | => 3.0MP10 |
| 2012-03-08 08:09 | alostale | Relationship added | related to 0019982 |
| 2012-04-01 20:38 | hudsonbot | Checkin | |
| 2012-04-01 20:38 | hudsonbot | Note Added: 0047059 | |
| 2012-06-14 15:46 | alostale | Relationship added | related to 0020363 |