Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024051Openbravo ERPY. DBSourceManagerpublic2013-06-12 13:002016-12-16 18:39
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q1 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024051: Audit trail triggers are exported to core
DescriptionUsing PostrgreSQL 9.x, generated triggers to manage audit trail are exported to core.
Steps To Reproduce-Set core in development
-Set any table as fully audited (i.e. C_Order)
-Generate audit infrastructure
-Export database
-Check audit trigger is exported as part of core (i.e. AU_C_Order_Trg)
Proposed SolutionProblem seems to be caused by escape characters used in SQL to exclude audit triggers:

AND upper(trg.tgname) NOT LIKE 'AU\\\\_%'
Additional Information
TagsNo tags attached.
Relationships
depends on feature request 0031685 closed AugustoMauch Allow using SQL wildcards in the dbsourmanager exclude filter 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-06-12 13:00alostaleNew Issue
2013-06-12 13:00alostaleAssigned To => marvintm
2013-06-12 13:00alostaleModules => Core
2013-06-12 13:00alostaleOBNetwork customer => No
2013-06-12 13:00alostaleTriggers an Emergency Pack => No
2015-02-24 11:29alostaleAssigned Tomarvintm => AugustoMauch
2015-02-24 11:29alostaleStatusnew => acknowledged
2015-03-11 13:56alostalePrioritynormal => high
2015-03-17 14:37alostaleAssigned ToAugustoMauch => platform
2015-11-11 11:37alostalePriorityhigh => normal
2015-12-10 18:36AugustoMauchRelationship addedrelated to 0031685
2015-12-10 18:37AugustoMauchRelationship replaceddepends on 0031685
2016-12-15 09:01alostaleAssigned Toplatform => alostale
2016-12-15 09:02alostaleReview Assigned To => caristu
2016-12-15 09:03hgbotCheckin
2016-12-15 09:03hgbotNote Added: 0092397
2016-12-15 09:03hgbotStatusacknowledged => resolved
2016-12-15 09:03hgbotResolutionopen => fixed
2016-12-15 09:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5adfc4d8a46deb99b6bb42b073bc8ab6b7cf6e07 [^]
2016-12-16 12:28caristuNote Added: 0092480
2016-12-16 12:28caristuStatusresolved => closed
2016-12-16 12:28caristuFixed in Version => 3.0PR17Q1
2016-12-16 18:39hudsonbotCheckin
2016-12-16 18:39hudsonbotNote Added: 0092716

Notes
(0092397)
hgbot   
2016-12-15 09:03   
Repository: erp/devel/pi
Changeset: 5adfc4d8a46deb99b6bb42b073bc8ab6b7cf6e07
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Dec 15 09:03:05 2016 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/5adfc4d8a46deb99b6bb42b073bc8ab6b7cf6e07 [^]

fixed bug 24051: Audit trail triggers are exported to core

  Exclude them properly using exclude filter with wildcards

---
M src-db/database/model/excludeFilter.xml
---
(0092480)
caristu   
2016-12-16 12:28   
Code review + testing OK: Audit trail triggers are not exported to core.
(0092716)
hudsonbot   
2016-12-16 18:39   
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/dc8bf00badd0 [^]
Maturity status: Test