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

View Revisions: Issue #32921 All Revisions ] Back to Issue ]
Summary 0032921: Constraint and trigger remain after being eliminated in a template
Revision 2017-09-25 10:25 by inigosanchez
Steps To Reproduce 1. 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.
Revision 2016-05-18 16:41 by adrianromero
Steps To Reproduce Using a template activated
Delete a constraint and trigger
Run an export.config.script
Verify in the xml the elimination of constraint and trigger.
Run a install.source
Does not remove the constraint and trigger in the database.

For example the following changes (Removing 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="OBRETCO_PROLPRODUCT_TRG"/>

+ <removeCheckChange tableName="M_PRODUCT" checkName="M_PRODUCT_DISCSTOCKED_CHK">
+ <check name="M_PRODUCT_DISCSTOCKED_CHK"><![CDATA[NOT (ISSALEDISCONTINUED = 'Y' AND (ISSTOCKED = 'N' OR PRODUCTTYPE <> 'I'))]]></check>
+ </removeCheckChange>
Revision 2016-05-18 16:40 by adrianromero
Steps To Reproduce Using a template activated
Delete a constraint and trigger
Run an export.config.script
Verify in the xml the elimination of constraint and trigger.
Run a install.source
Does not remove the constraint and trigger in the database.

For example the following changes (Removing a trigger and removing a display logic value) are not applied using the build task install.source. However the build task update.database does apply properly the template changes:

+ <removeTriggerChange triggerName="OBRETCO_PROLPRODUCT_TRG"/>

+ <columnDataChange tablename="AD_FIELD" columnname="DISPLAYLOGIC" pkRow="6E44A840893C48A8A084BE78CA430A93">
+ <oldValue><![CDATA[@DISPLAY_DISCONTINUED@='Y' | @DISPLAY_DISCONTINUED@='']]></oldValue>
+ <newValue/>
+ </columnDataChange>
Revision 2016-05-18 16:29 by adrianromero
Steps To Reproduce Using a template activated
Delete a constraint and trigger
Run an export.config.script
Verify in the xml the elimination of constraint and trigger.
Run a install.source
Does not remove the constraint and trigger in the database.


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker