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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0032921
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagerminoralways2016-05-10 23:152017-09-25 10:30
ReporterOsmanyView Statuspublic 
Assigned Toinigosanchez 
PrioritynormalResolutionfixedFixed in Version3.0PR17Q4
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Toalostale
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0032921: Constraint and trigger remain after being eliminated in a template

DescriptionConstraint and trigger remain after being eliminated in a template.

For example the following changes (Remove a trigger and a check constraint) are not applied using the build task install.source. However the build task update.database does apply properly the template changes:

+ <removeTriggerChange triggerName="A_AMORTIZATION_TRG"/>
+ <removeCheckChange tableName="A_AMORTIZATION" checkName="A_AMORTIZATION_ISACTIVE_CHECK">
+ <check name="A_AMORTIZATION_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
+ </removeCheckChange>
Steps To Reproduce1. Login in the ERP as "System Administrator - System"
2. Go to [Module] window and set org.openbravo.v3 template in development. Logout.
3. Delete a constraint and trigger from the db.
4. Execute an export.database task.
5. Execute an export.config.script.
- VERIFY in the configScript file the elimination of constraint and trigger.
6. Execute an install.source task.
- ERROR: Does not remove the constraint and trigger in the database.
TagsSER-QA
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0036137 closedinigosanchez [SER-QA 2918] Config script removeCheckChange are not applied on install.source 

-  Notes
(0086549)
alostale (viewer)
2016-05-18 13:42

 feedback request:

1. Be more specific in the reporting: what constraint do you remove, does it also apply to update.database...
2. Review severity
(0086552)
Osmany (viewer)
2016-05-18 16:29

 You can test with any constraint and trigger. When applies update.database working fine. The problem is with install.source task.
(0099514)
inigosanchez (viewer)
2017-09-25 10:30

 Since the 0036137 was fixed, this issue is not reproduced anymore. Verified reported flow: now the constraint and the trigger are not remained in the db and the are removed properly.

- Issue History
Date Modified Username Field Change
2016-05-10 23:15 Osmany New Issue
2016-05-10 23:15 Osmany Assigned To => platform
2016-05-10 23:15 Osmany OBNetwork customer => No
2016-05-10 23:15 Osmany Modules => Core
2016-05-10 23:15 Osmany Triggers an Emergency Pack => No
2016-05-12 12:08 adrianromero OBNetwork customer No => Yes
2016-05-12 12:08 adrianromero Resolution time => 1463608800
2016-05-12 12:08 adrianromero Tag Attached: SER-QA
2016-05-18 13:42 alostale Note Added: 0086549
2016-05-18 13:42 alostale Assigned To platform => adrianromero
2016-05-18 13:42 alostale Status new => feedback
2016-05-18 16:29 Osmany Note Added: 0086552
2016-05-18 16:40 adrianromero Priority high => normal
2016-05-18 16:40 adrianromero Severity major => minor
2016-05-18 16:40 adrianromero Status feedback => new
2016-05-18 16:40 adrianromero Steps to Reproduce Updated View Revisions
2016-05-18 16:40 adrianromero Assigned To adrianromero => alostale
2016-05-18 16:41 adrianromero Steps to Reproduce Updated View Revisions
2016-05-18 17:45 alostale Assigned To alostale => platform
2016-05-18 17:45 alostale Status new => acknowledged
2016-05-23 08:35 alostale Resolution time 1463608800 =>
2017-07-26 11:24 alostale Relationship added related to 0036137
2017-09-25 10:13 inigosanchez Status acknowledged => scheduled
2017-09-25 10:13 inigosanchez Assigned To platform => inigosanchez
2017-09-25 10:25 inigosanchez Description Updated View Revisions
2017-09-25 10:25 inigosanchez Steps to Reproduce Updated View Revisions
2017-09-25 10:26 inigosanchez Description Updated View Revisions
2017-09-25 10:30 inigosanchez Review Assigned To => alostale
2017-09-25 10:30 inigosanchez Note Added: 0099514
2017-09-25 10:30 inigosanchez Status scheduled => closed
2017-09-25 10:30 inigosanchez Resolution open => fixed
2017-09-25 10:30 inigosanchez Fixed in Version => 3.0PR17Q4

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker