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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0012785
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajorhave not tried2010-03-24 09:412010-05-19 00:00
ReportermarvintmView Statuspublic 
Assigned Tomarvintm 
PriorityurgentResolutionfixedFixed in Version2.50MP17
StatusclosedFix in branchpiFixed in SCM revision37e4d8da2514
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012785: If a module adds a table to the dataset AD, constraints for that table are dropped and created twice

DescriptionIf a module adds a table to the dataset AD, constraints for that table are dropped and created twice. This produces warnings like the following:
 SQL Command failed with: ERROR: constraint "obuisel_s_ad_client" does not exist
     [java] 96000 WARN - ALTER TABLE OBUISEL_SELECTOR
     [java] DROP CONSTRAINT OBUISEL_S_AD_CLIENT
     [java] 96003 WARN - SQL Command failed with: ERROR: constraint "obuisel_s_ad_column" does not exist
     [java] 96006 WARN - -- END
     [java] ALTER TABLE OBUISEL_SELECTOR
     [java] DROP CONSTRAINT OBUISEL_S_AD_COLUMN
     [java] 96010 WARN - SQL Command failed with: ERROR: constraint "obuisel_s_ad_module" does not exist
     [java] 96014 WARN - -- END
     [java] ALTER TABLE OBUISEL_SELECTOR
     [java] DROP CONSTRAINT OBUISEL_S_AD_MODULE
     [java] 96017 WARN - SQL Command failed with: ERROR: constraint "obuisel_s_ad_org" does not exist
     [java] 96022 WARN - -- END

------

SQL Command failed with: ERROR: constraint "obuisel_s_ad_client" for relation "obuisel_selector" already exists
     [java] 155894 WARN - ALTER TABLE OBUISEL_SELECTOR
     [java] ADD CONSTRAINT OBUISEL_S_AD_CLIENT FOREIGN KEY (AD_CLIENT_ID) REFERENCES AD_CLIENT (AD_CLIENT_ID)
     [java] 155897 WARN - SQL Command failed with: ERROR: constraint "obuisel_s_ad_column" for relation "obuisel_selector" already exists
     [java] 155899 WARN - -- END
     [java] ALTER TABLE OBUISEL_SELECTOR
     [java] ADD CONSTRAINT OBUISEL_S_AD_COLUMN FOREIGN KEY (AD_COLUMN_ID) REFERENCES AD_COLUMN (AD_COLUMN_ID)
     [java] 155904 WARN - SQL Command failed with: ERROR: constraint "obuisel_s_ad_module" for relation "obuisel_selector" already exists
     [java] 155906 WARN - -- END
     [java] ALTER TABLE OBUISEL_SELECTOR
     [java] ADD CONSTRAINT OBUISEL_S_AD_MODULE FOREIGN KEY (AD_MODULE_ID) REFERENCES AD_MODULE (AD_MODULE_ID)
     [java] 155910 WARN - SQL Command failed with: ERROR: constraint "obuisel_s_ad_org" for relation "obuisel_selector" already exists
     [java] 155913 WARN - -- END
Steps To ReproduceApply the new Selectors module. Look at the log.
Proposed SolutionDBSourceManager needs to be changed to fix this.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
has duplicate defect 0013464 closedmarvintm Scary warnings after installing the new Adv payables&Receivables module 

-  Notes
(0027174)
hgbot (developer)
2010-05-12 16:44

Repository: erp/devel/dbsm-main
Changeset: 04bd4e0ce0c5916bd7a5d319347630257a348163
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed May 12 16:43:50 2010 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/04bd4e0ce0c5916bd7a5d319347630257a348163 [^]

Fixed issue 12785. Foreign key constraints will not be dropped and created twice when they belong to a table which a module adds and is part of the AD dataset.

---
M src/org/openbravo/ddlutils/task/AlterDatabaseDataMod.java
---
(0027175)
hgbot (developer)
2010-05-12 16:44

Repository: erp/devel/pi
Changeset: 37e4d8da2514a907cfa1b9c58f2825f737e04ccc
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed May 12 16:44:09 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/37e4d8da2514a907cfa1b9c58f2825f737e04ccc [^]

Fixed issue 12785. Foreign key constraints will not be dropped and created twice when they belong to a table which a module adds and is part of the AD dataset.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0027407)
mtaal (manager)
2010-05-18 11:22

Tested works fine
(0027518)
hudsonbot (developer)
2010-05-18 21:44

A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/37e4d8da2514 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/aa11838d5f80 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17380.obx [^]

- Issue History
Date Modified Username Field Change
2010-03-24 09:41 marvintm New Issue
2010-03-24 09:41 marvintm Assigned To => marvintm
2010-03-29 08:21 alostale Status new => scheduled
2010-03-29 08:21 alostale fix_in_branch => pi
2010-04-13 18:24 shuehner Issue Monitored: shuehner
2010-05-12 16:44 hgbot Checkin
2010-05-12 16:44 hgbot Note Added: 0027174
2010-05-12 16:44 hgbot Status scheduled => resolved
2010-05-12 16:44 hgbot Resolution open => fixed
2010-05-12 16:44 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/dbsm-main/rev/04bd4e0ce0c5916bd7a5d319347630257a348163 [^]
2010-05-12 16:44 hgbot Checkin
2010-05-12 16:44 hgbot Note Added: 0027175
2010-05-12 16:44 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/dbsm-main/rev/04bd4e0ce0c5916bd7a5d319347630257a348163 [^] => http://code.openbravo.com/erp/devel/pi/rev/37e4d8da2514a907cfa1b9c58f2825f737e04ccc [^]
2010-05-18 11:22 mtaal Note Added: 0027407
2010-05-18 11:22 mtaal Status resolved => closed
2010-05-18 11:22 mtaal Fixed in Version => 2.50MP17
2010-05-18 21:44 hudsonbot Checkin
2010-05-18 21:44 hudsonbot Note Added: 0027518
2010-05-19 00:00 anonymous sf_bug_id 0 => 3003671
2010-05-27 19:32 marvintm Relationship added has duplicate 0013464


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker