Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0032921 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | minor | always | 2016-05-10 23:15 | 2017-09-25 10:30 | |||
| Reporter | Osmany | View Status | public | |||||
| Assigned To | inigosanchez | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 3.0PR17Q4 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | alostale | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0032921: Constraint and trigger remain after being eliminated in a template | |||||||
| Description | Constraint 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 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. | |||||||
| Tags | SER-QA | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0086549) alostale (manager) 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 (developer) 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 (developer) 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. |
|
Notes |
|
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 | Modules | => Core |
| 2016-05-10 23:15 | Osmany | Triggers an Emergency Pack | => No |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |