Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010708Openbravo ERP01. General setuppublic2009-09-23 10:242009-10-27 00:00
Reporternetworkb 
Assigned Tomarvintm 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP5 
Target Version2.50MP7Fixed in Version2.50MP8 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010708: 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
Proposed Solution
Additional Information
Tags250MP8, main
Relationships
related to defect 0010884 closed shuehner Audit all queries using LIKE with respect to _ character which is a wildcard and not a normal char 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-09-23 10:24networkbNew Issue
2009-09-23 10:24networkbAssigned To => rafaroda
2009-09-23 10:30rafarodaNote Added: 0020302
2009-09-23 10:30rafarodaStatusnew => feedback
2009-09-23 10:54networkbSummaryTrigger dissapear in module with dependency in Postgre => Trigger dissapear in module with dependency, in Postgre
2009-09-23 10:54networkbDescription Updated
2009-09-23 10:54networkbProposed Solution updated
2009-09-23 10:55networkbStatusfeedback => new
2009-09-24 06:47rafarodaNote Added: 0020325
2009-09-24 06:47rafarodaAssigned Torafaroda => iciordia
2009-09-25 07:20rafarodaNote Added: 0020352
2009-09-25 07:20rafarodaAssigned Toiciordia => marvintm
2009-09-25 07:20rafarodaPriorityimmediate => high
2009-09-25 07:20rafarodaStatusnew => scheduled
2009-09-30 07:51iciordiaPriorityhigh => urgent
2009-10-05 13:04hgbotCheckin
2009-10-05 13:04hgbotNote Added: 0020705
2009-10-05 13:04hgbotStatusscheduled => resolved
2009-10-05 13:04hgbotResolutionopen => fixed
2009-10-05 13:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b73ebb8293cb107de635d612317d41b0183465be [^]
2009-10-06 17:10shuehnerRelationship addedrelated to 0010884
2009-10-22 19:26psarobeTag Attached: main
2009-10-22 19:33psarobeTag Attached: 250MP8
2009-10-26 20:06plujanStatusresolved => closed
2009-10-26 20:06plujanFixed in Version => 2.50MP8
2009-10-27 00:00anonymoussf_bug_id0 => 2886770

Notes
(0020302)
rafaroda   
2009-09-23 10:30   
Description and steps to reproduce the issue are not clear enough.
(0020325)
rafaroda   
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   
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   
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
---