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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0024051
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagerminoralways2013-06-12 13:002016-12-16 18:39
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version3.0PR17Q1
StatusclosedFix in branchFixed in SCM revision5adfc4d8a46d
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase version9.xAnt version
Product VersionSCM revision 
Review Assigned Tocaristu
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0024051: 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\\\\_%'
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on feature request 0031685 closedAugustoMauch Allow using SQL wildcards in the dbsourmanager exclude filter 

-  Notes
(0092397)
hgbot (developer)
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 (developer)
2016-12-16 12:28

 Code review + testing OK: Audit trail triggers are not exported to core.
(0092716)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2013-06-12 13:00 alostale New Issue
2013-06-12 13:00 alostale Assigned To => marvintm
2013-06-12 13:00 alostale Modules => Core
2013-06-12 13:00 alostale Triggers an Emergency Pack => No
2015-02-24 11:29 alostale Assigned To marvintm => AugustoMauch
2015-02-24 11:29 alostale Status new => acknowledged
2015-03-11 13:56 alostale Priority normal => high
2015-03-17 14:37 alostale Assigned To AugustoMauch => platform
2015-11-11 11:37 alostale Priority high => normal
2015-12-10 18:36 AugustoMauch Relationship added related to 0031685
2015-12-10 18:37 AugustoMauch Relationship replaced depends on 0031685
2016-12-15 09:01 alostale Assigned To platform => alostale
2016-12-15 09:02 alostale Review Assigned To => caristu
2016-12-15 09:03 hgbot Checkin
2016-12-15 09:03 hgbot Note Added: 0092397
2016-12-15 09:03 hgbot Status acknowledged => resolved
2016-12-15 09:03 hgbot Resolution open => fixed
2016-12-15 09:03 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5adfc4d8a46deb99b6bb42b073bc8ab6b7cf6e07 [^]
2016-12-16 12:28 caristu Note Added: 0092480
2016-12-16 12:28 caristu Status resolved => closed
2016-12-16 12:28 caristu Fixed in Version => 3.0PR17Q1
2016-12-16 18:39 hudsonbot Checkin
2016-12-16 18:39 hudsonbot Note Added: 0092716

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker