Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0012067 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | critical | have not tried | 2010-01-26 12:12 | 2010-03-17 00:00 | |||
| Reporter | plujan | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 2.50MP11 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 06b4bc2129d3 | |||
| Projection | none | ETA | none | Target Version | 2.50MP11 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP11 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0012067: Warnings when rebuilding the system after installing Quickstart | |||||||
| Description | 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) | |||||||
| Steps To Reproduce | Rebuild the system in MP11 after installing Quick Start Spain | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
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 (viewer) 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 (viewer) 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 (viewer) 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 (viewer) 2010-03-16 15:24 |
This problem happened during the MP11 release cycle, and was fixed and tested then. |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |