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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0012067
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagercriticalhave not tried2010-01-26 12:122010-03-17 00:00
ReporterplujanView Statuspublic 
Assigned Tomarvintm 
PriorityimmediateResolutionfixedFixed in Version2.50MP11
StatusclosedFix in branchpiFixed in SCM revision06b4bc2129d3
ProjectionnoneETAnoneTarget Version2.50MP11
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP11SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012067: Warnings when rebuilding the system after installing Quickstart

DescriptionWhen rebuilding the system after installing Quick Start Spain, I get several warning messages:
Warning: SQL Command failed with: ORA-02270: no matching unique or primary key for this column-list

Warning: -- END ALTER TABLE C_BP_WITHHOLDING ADD CONSTRAINT C_BP_WITHHOLDING_C_TAX FOREIGN KEY (C_TAX_ID) REFERENCES C_TAX (C_TAX_ID)

Warning: SQL Command failed with: ORA-02270: no matching unique or primary key for this column-list

Warning: -- END ALTER TABLE C_COMMISSIONRUN ADD CONSTRAINT C_INVOICE_CCOMMISSIONRUN FOREIGN KEY (C_INVOICE_ID) REFERENCES C_INVOICE (C_INVOICE_ID)

Warning: SQL Command failed with: ORA-02270: no matching unique or primary key for this column-list

Warning: -- END ALTER TABLE C_DEBT_PAYMENT ADD CONSTRAINT C_DEBT_PAYMENT_C_INVOICE FOREIGN KEY (C_INVOICE_ID) REFERENCES C_INVOICE (C_INVOICE_ID)

Warning: SQL Command failed with: ORA-02270: no matching unique or primary key for this column-list

Warning: -- END ALTER TABLE C_GLITEM ADD CONSTRAINT C_GLITEM_C_TAX FOREIGN KEY (C_TAX_ID) REFERENCES C_TAX (C_TAX_ID)

Warning: SQL Command failed with: ORA-02270: no matching unique or primary key for this column-list

Warning: -- END ALTER TABLE C_INVOICELINE ADD CONSTRAINT C_INVOICELINE_C_INVOICE FOREIGN KEY (C_INVOICE_ID) REFERENCES C_INVOICE (C_INVOICE_ID)

Warning: SQL Command failed with: ORA-02270: no matching unique or primary key for this column-list

Warning: -- END ALTER TABLE C_INVOICELINE ADD CONSTRAINT C_INVOICELINE_C_TAX FOREIGN KEY (C_TAX_ID) REFERENCES C_TAX (C_TAX_ID)
Steps To ReproduceRebuild the system in MP11 after installing Quick Start Spain
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0023803)
hgbot (developer)
2010-01-26 12:43

Repository: erp/devel/pi
Changeset: da763d8ed8865e53e62a1978772a95a1437f819c
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Jan 26 12:43:02 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/da763d8ed8865e53e62a1978772a95a1437f819c [^]

Fixed issue 12067. Fks will no longer fail in Oracle because PKs were not (yet) created.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0023806)
plujan (manager)
2010-01-26 16:12

I still see a warning regarding C_Country table
(0023807)
hgbot (developer)
2010-01-26 17:45

Repository: erp/devel/pi
Changeset: 06b4bc2129d391e8abc8166cc4690df6a7bc4821
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Jan 26 17:45:15 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/06b4bc2129d391e8abc8166cc4690df6a7bc4821 [^]

Fixed issue 12067. Fks will no longer fail in Oracle because PKs were not (yet) created, and also will no longer fail because the primary keys were created twice

---
M src-db/database/lib/dbsourcemanager.jar
---
(0023890)
hudsonbot (developer)
2010-02-01 17:53

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/da763d8ed886 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/3d5bd712a24b [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16007.obx [^]
(0023891)
hudsonbot (developer)
2010-02-01 17:53

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/06b4bc2129d3 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/3d5bd712a24b [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16007.obx [^]
(0025539)
marvintm (developer)
2010-03-16 15:24

This problem happened during the MP11 release cycle, and was fixed and tested then.

- Issue History
Date Modified Username Field Change
2010-01-26 12:12 plujan New Issue
2010-01-26 12:12 plujan Assigned To => marvintm
2010-01-26 12:12 plujan Status new => scheduled
2010-01-26 12:12 plujan fix_in_branch => pi
2010-01-26 12:43 hgbot Checkin
2010-01-26 12:43 hgbot Note Added: 0023803
2010-01-26 12:43 hgbot Status scheduled => resolved
2010-01-26 12:43 hgbot Resolution open => fixed
2010-01-26 12:43 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/da763d8ed8865e53e62a1978772a95a1437f819c [^]
2010-01-26 16:12 plujan Note Added: 0023806
2010-01-26 16:12 plujan Status resolved => new
2010-01-26 16:12 plujan Resolution fixed => open
2010-01-26 16:12 plujan Status new => scheduled
2010-01-26 17:45 hgbot Checkin
2010-01-26 17:45 hgbot Note Added: 0023807
2010-01-26 17:45 hgbot Status scheduled => resolved
2010-01-26 17:45 hgbot Resolution open => fixed
2010-01-26 17:45 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/da763d8ed8865e53e62a1978772a95a1437f819c [^] => http://code.openbravo.com/erp/devel/pi/rev/06b4bc2129d391e8abc8166cc4690df6a7bc4821 [^]
2010-02-01 17:53 hudsonbot Checkin
2010-02-01 17:53 hudsonbot Note Added: 0023890
2010-02-01 17:53 hudsonbot Checkin
2010-02-01 17:53 hudsonbot Note Added: 0023891
2010-03-16 15:24 marvintm Note Added: 0025539
2010-03-16 15:24 marvintm Status resolved => closed
2010-03-16 15:24 marvintm Fixed in Version => 2.50MP11
2010-03-17 00:00 anonymous sf_bug_id 0 => 2971627


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker