Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0019781
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2012-02-15 17:372012-04-01 20:38
ReportermiruritaView Statuspublic 
Assigned Tomigueldejuana 
PrioritynormalResolutionfixedFixed in Version3.0MP10
StatusclosedFix in branchFixed in SCM revisionc5bc41eed924
ProjectionnoneETAnoneTarget Version3.0MP10
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version3.0MP7.1SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket14338
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
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 Reproduce1) 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).
TagsNo tags attached.
Attached Filespng file icon AuditTrail_clob.png [^] (40,688 bytes) 2012-02-15 17:37

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to design defect 0019982 closedalostale Audit trail support for CLOB/Text 
related to defect 00203633.0MP13 closedalostale If you put the table OBUIAPP_UIPersonalization as fully audited it does not work form or view personalization 

-  Notes
(0046156)
hgbot (developer)
2012-03-08 08:05

 Repository: erp/devel/pi
Changeset: c5bc41eed924d01965eb0fd82080d0b9600b83b5
Author: Miguel de Juana <miguel.dejuana <at> openbravo.com>
Date: Wed Mar 07 15:46:53 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/c5bc41eed924d01965eb0fd82080d0b9600b83b5 [^]

Fixed issue 19781: Fully audit table with CLOB column, launched trigger well.
Auditing a table with a CLOB column launch au_ad_process.request_trg without errors.

---
M src-db/database/model/postscript-Oracle.sql
---
(0046157)
alostale (viewer)
2012-03-08 08:06

 Code reviewed and tested on pi@c5bc41eed924
(0047059)
hudsonbot (viewer)
2012-04-01 20:38

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/640de9acc2d5 [^]

Maturity status: Test

- 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker