Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012067Openbravo ERPY. DBSourceManagerpublic2010-01-26 12:122010-03-17 00:00
Reporterplujan 
Assigned Tomarvintm 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP11 
Target Version2.50MP11Fixed in Version2.50MP11 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012067: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-01-26 12:12plujanNew Issue
2010-01-26 12:12plujanAssigned To => marvintm
2010-01-26 12:12plujanOBNetwork customer => No
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.