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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010708
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupminoralways2009-09-23 10:242009-10-27 00:00
ReporternetworkbView Statuspublic 
Assigned Tomarvintm 
PriorityurgentResolutionfixedFixed in Version2.50MP8
StatusclosedFix in branchFixed in SCM revisionb73ebb8293cb
ProjectionnoneETAnoneTarget Version2.50MP7
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.50MP5SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010708: Trigger dissapear in module with dependency, in Postgre

DescriptionYou install a module base (which contains one table) and then install another module, defined as dependency of the first one (which contains a trigger for the table defined in the first module). Then you develop a new version of base module and install it.

If you go to database you can check the trigger defined in the second module has been deleted from the base module.
Steps To ReproduceContact with Support Team (meli) to provide you the modules and then:

1. install module "com.entel.virtualdoc.base-1.0.6.obx" trough General Setup || Application || Module Management window:
    That is module base, which contains table vd_account
2. install module "com.entel.virtualdoc.integrations-1.0.6.obx" trough General Setup || Application || Module Management window:
    That is the module dependent, which inserts trigger vdi_account_usedspace_trg in table vd_account
3. install module "com.entel.virtualdoc.base-1.0.7.obx" trough General Setup || Application || Module Management window:
    That is the new version of module base, after install it trigger vdi_account_usedspace_trg is not in vd_account table
Tags250MP8, main
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0010884 closedshuehner Audit all queries using LIKE with respect to _ character which is a wildcard and not a normal char 

-  Notes
(0020302)
rafaroda (developer)
2009-09-23 10:30

Description and steps to reproduce the issue are not clear enough.
(0020325)
rafaroda (developer)
2009-09-24 06:47

I'm not sure if this is a defect.

Constraint module depends on version 1.0.6 of base module. When you install version 1.0.7 of base module you can not ensure that constraint module will still work.

Ismael, can you please comment on this?

Thanks.
(0020352)
rafaroda (developer)
2009-09-25 07:20

Acknowledged as a bug.

A workaround is making an: ant update.database (which applies all the model, not only the base module changes)
(0020705)
hgbot (developer)
2009-10-05 13:04

Repository: erp/devel/pi
Changeset: b73ebb8293cb107de635d612317d41b0183465be
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Oct 05 13:03:24 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/b73ebb8293cb107de635d612317d41b0183465be [^]

Fixed issue 10708.
> This problem happens when a dbprefix is a prefix for the dbprefix of another module (for example, if module 1 has dbprefix MOD, and module 2 has dbprefix MOD1, and both are installed in the same system). This problem shouldn't happen anymore after this fix.

---
M src-db/database/lib/dbsourcemanager.jar
---

- Issue History
Date Modified Username Field Change
2009-09-23 10:24 networkb New Issue
2009-09-23 10:24 networkb Assigned To => rafaroda
2009-09-23 10:30 rafaroda Note Added: 0020302
2009-09-23 10:30 rafaroda Status new => feedback
2009-09-23 10:54 networkb Summary Trigger dissapear in module with dependency in Postgre => Trigger dissapear in module with dependency, in Postgre
2009-09-23 10:54 networkb Description Updated
2009-09-23 10:54 networkb Proposed Solution updated
2009-09-23 10:55 networkb Status feedback => new
2009-09-24 06:47 rafaroda Note Added: 0020325
2009-09-24 06:47 rafaroda Assigned To rafaroda => iciordia
2009-09-25 07:20 rafaroda Note Added: 0020352
2009-09-25 07:20 rafaroda Assigned To iciordia => marvintm
2009-09-25 07:20 rafaroda Priority immediate => high
2009-09-25 07:20 rafaroda Status new => scheduled
2009-09-30 07:51 iciordia Priority high => urgent
2009-10-05 13:04 hgbot Checkin
2009-10-05 13:04 hgbot Note Added: 0020705
2009-10-05 13:04 hgbot Status scheduled => resolved
2009-10-05 13:04 hgbot Resolution open => fixed
2009-10-05 13:04 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b73ebb8293cb107de635d612317d41b0183465be [^]
2009-10-06 17:10 shuehner Relationship added related to 0010884
2009-10-22 19:26 psarobe Tag Attached: main
2009-10-22 19:33 psarobe Tag Attached: 250MP8
2009-10-26 20:06 plujan Status resolved => closed
2009-10-26 20:06 plujan Fixed in Version => 2.50MP8
2009-10-27 00:00 anonymous sf_bug_id 0 => 2886770


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker