Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0012067Openbravo ERPY. DBSourceManagerpublic2010-01-26 12:122010-03-17 00:00
plujan 
marvintm 
immediatecriticalhave not tried
closedfixed 
5
2.50MP11 
2.50MP112.50MP11 
Core
No
0012067: Warnings when rebuilding the system after installing Quickstart
When 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)
Rebuild the system in MP11 after installing Quick Start Spain
No tags attached.
Issue History
2010-01-26 12:12plujanNew Issue
2010-01-26 12:12plujanAssigned To => marvintm
2010-01-26 12:12plujanStatusnew => scheduled
2010-01-26 12:12plujanfix_in_branch => pi
2010-01-26 12:43hgbotCheckin
2010-01-26 12:43hgbotNote Added: 0023803
2010-01-26 12:43hgbotStatusscheduled => resolved
2010-01-26 12:43hgbotResolutionopen => fixed
2010-01-26 12:43hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/da763d8ed8865e53e62a1978772a95a1437f819c [^]
2010-01-26 16:12plujanNote Added: 0023806
2010-01-26 16:12plujanStatusresolved => new
2010-01-26 16:12plujanResolutionfixed => open
2010-01-26 16:12plujanStatusnew => scheduled
2010-01-26 17:45hgbotCheckin
2010-01-26 17:45hgbotNote Added: 0023807
2010-01-26 17:45hgbotStatusscheduled => resolved
2010-01-26 17:45hgbotResolutionopen => fixed
2010-01-26 17:45hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/da763d8ed8865e53e62a1978772a95a1437f819c [^] => http://code.openbravo.com/erp/devel/pi/rev/06b4bc2129d391e8abc8166cc4690df6a7bc4821 [^]
2010-02-01 17:53hudsonbotCheckin
2010-02-01 17:53hudsonbotNote Added: 0023890
2010-02-01 17:53hudsonbotCheckin
2010-02-01 17:53hudsonbotNote Added: 0023891
2010-03-16 15:24marvintmNote Added: 0025539
2010-03-16 15:24marvintmStatusresolved => closed
2010-03-16 15:24marvintmFixed in Version => 2.50MP11
2010-03-17 00:00anonymoussf_bug_id0 => 2971627

Notes
(0023803)
hgbot   
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   
2010-01-26 16:12   
I still see a warning regarding C_Country table
(0023807)
hgbot   
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   
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   
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   
2010-03-16 15:24   
This problem happened during the MP11 release cycle, and was fixed and tested then.