Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0011869 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | major | always | 2009-12-28 13:08 | 2010-01-19 01:41 | |||
| Reporter | iperdomo | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 2.50MP10 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 6cce3882983c | ||||
| Projection | none | ETA | none | Target Version | pi | |||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_15 | |||
| OS Version | 2.6.30-gentoo-r5 | Database version | 8.3.8 | Ant version | 1.7.1 | |||
| Product Version | pi | SCM revision | f805f5189bbc | |||||
| 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 | 0011869: SQL Command failed with: ERROR: column "binarydata" is of type oid but expression is of type bytea | |||||||
| Description | Error in binary data. ... [java] Processing Column BINARYDATA of table AD_ATTACHMENT (changed because of the type) [java] Processing Column BINARYDATA of table AD_IMAGE (changed because of the type) [java] Processing View View [name=C_INVOICE_CANDIDATE_V; ] (created for the database PostgreSql server) [java] SQL Command failed with: ERROR: column "binarydata" is of type oid but expression is of type bytea [java] -- END [java] INSERT INTO AD_ATTACHMENT_ (AD_ATTACHMENT_ID,AD_CLIENT_ID,AD_ORG_ID,ISACTIVE,CREATED,CREATEDBY,UPDATED,UPDATEDBY,AD_TABLE_ID,RECORD_ID,TITLE,TEXT,BINARYDATA,AD_DATATYPE_ID) SELECT AD_ATTACHMENT_ID,AD_CLIENT_ID,AD_ORG_ID,ISACTIVE,CREATED,CREATEDBY,UPDATED,UPDATEDBY,AD_TABLE_ID,RECORD_ID,TITLE,TEXT,BINARYDATA,AD_DATATYPE_ID FROM AD_ATTACHMENT [java] SQL Command failed with: ERROR: column "binarydata" is of type oid but expression is of type bytea [java] -- END [java] INSERT INTO AD_IMAGE_ (AD_IMAGE_ID,AD_CLIENT_ID,AD_ORG_ID,ISACTIVE,CREATED,CREATEDBY,UPDATED,UPDATEDBY,NAME,IMAGEURL,BINARYDATA) SELECT AD_IMAGE_ID,AD_CLIENT_ID,AD_ORG_ID,ISACTIVE,CREATED,CREATEDBY,UPDATED,UPDATEDBY,NAME,IMAGEURL,BINARYDATA FROM AD_IMAGE [java] Executed 37 SQL command(s) with 2 error(s) [java] Model update complete. [java] Disabling foreign keys [.....] [java] Executing update final script (NOT NULLs and dropping temporary tables [java] SQL Command failed with: ERROR: insert or update on table "ad_clientinfo" violates foreign key constraint "ad_clientinfo_imagebigcomp" [java] Detail: Key (your_company_big_image)=(FF8080812596F2DF01259708E90F0002) is not present in table "ad_image". [java] -- END [java] ALTER TABLE AD_CLIENTINFO [java] ADD CONSTRAINT AD_CLIENTINFO_IMAGEBIGCOMP FOREIGN KEY (YOUR_COMPANY_BIG_IMAGE) REFERENCES AD_IMAGE (AD_IMAGE_ID) [java] SQL Command failed with: ERROR: insert or update on table "ad_clientinfo" violates foreign key constraint "ad_clientinfo_imagedocum" [java] Detail: Key (your_company_document_image)=(FF8080812596F2DF01259708E9180003) is not present in table "ad_image". [java] -- END [java] ALTER TABLE AD_CLIENTINFO [java] ADD CONSTRAINT AD_CLIENTINFO_IMAGEDOCUM FOREIGN KEY (YOUR_COMPANY_DOCUMENT_IMAGE) REFERENCES AD_IMAGE (AD_IMAGE_ID) [java] SQL Command failed with: ERROR: insert or update on table "ad_clientinfo" violates foreign key constraint "ad_clientinfo_imagemenucomp" [java] Detail: Key (your_company_menu_image)=(FF8080812596F2DF01259708E9180004) is not present in table "ad_image". [java] -- END [java] ALTER TABLE AD_CLIENTINFO [java] ADD CONSTRAINT AD_CLIENTINFO_IMAGEMENUCOMP FOREIGN KEY (YOUR_COMPANY_MENU_IMAGE) REFERENCES AD_IMAGE (AD_IMAGE_ID) [java] SQL Command failed with: ERROR: insert or update on table "ad_system_info" violates foreign key constraint "ad_system_info_imagebigcomp" [java] Detail: Key (your_company_big_image)=(FF8080812574DBFE012574DC5DDB0005) is not present in table "ad_image". [java] -- END [java] ALTER TABLE AD_SYSTEM_INFO [java] ADD CONSTRAINT AD_SYSTEM_INFO_IMAGEBIGCOMP FOREIGN KEY (YOUR_COMPANY_BIG_IMAGE) REFERENCES AD_IMAGE (AD_IMAGE_ID) [java] SQL Command failed with: ERROR: insert or update on table "ad_system_info" violates foreign key constraint "ad_system_info_imagedocum" [java] Detail: Key (your_company_document_image)=(FF8080812574DBFE012574DC5DE20006) is not present in table "ad_image". [java] -- END [java] ALTER TABLE AD_SYSTEM_INFO [java] ADD CONSTRAINT AD_SYSTEM_INFO_IMAGEDOCUM FOREIGN KEY (YOUR_COMPANY_DOCUMENT_IMAGE) REFERENCES AD_IMAGE (AD_IMAGE_ID) [java] SQL Command failed with: ERROR: insert or update on table "ad_system_info" violates foreign key constraint "ad_system_info_imagelogincomp" [java] Detail: Key (your_company_login_image)=(FF8080812574DBFE012574DC5D090002) is not present in table "ad_image". [java] -- END [java] ALTER TABLE AD_SYSTEM_INFO [java] ADD CONSTRAINT AD_SYSTEM_INFO_IMAGELOGINCOMP FOREIGN KEY (YOUR_COMPANY_LOGIN_IMAGE) REFERENCES AD_IMAGE (AD_IMAGE_ID) [java] SQL Command failed with: ERROR: insert or update on table "ad_system_info" violates foreign key constraint "ad_system_info_imageloginserv" [java] Detail: Key (your_it_service_login_image)=(FF8080812574DBFE012574DC5DC60003) is not present in table "ad_image". [java] -- END [java] ALTER TABLE AD_SYSTEM_INFO [java] ADD CONSTRAINT AD_SYSTEM_INFO_IMAGELOGINSERV FOREIGN KEY (YOUR_IT_SERVICE_LOGIN_IMAGE) REFERENCES AD_IMAGE (AD_IMAGE_ID) [java] SQL Command failed with: ERROR: insert or update on table "ad_system_info" violates foreign key constraint "ad_system_info_imagemenucomp" [java] Detail: Key (your_company_menu_image)=(FF8080812574DBFE012574DC5DCC0004) is not present in table "ad_image". [java] -- END [java] ALTER TABLE AD_SYSTEM_INFO [java] ADD CONSTRAINT AD_SYSTEM_INFO_IMAGEMENUCOMP FOREIGN KEY (YOUR_COMPANY_MENU_IMAGE) REFERENCES AD_IMAGE (AD_IMAGE_ID) [java] Executed 104 SQL command(s) with 8 error(s) [java] Executed 132 SQL command(s) with 0 error(s) [java] Executed 5198 SQL command(s) with 0 error(s) [java] Enabling Foreign Keys and Triggers [java] Executed 2309 SQL command(s) with 0 error(s) [java] Executed 426 SQL command(s) with 0 error(s) [java] Executing default postscript [java] Executed 17 SQL command(s) with 0 error(s) [.....] ----------- It seems that the issue is caused by this changeset: https://code.openbravo.com/erp/devel/dbsm-main/rev/dc0260fdc95f [^] | |||||||
| Steps To Reproduce | * Update your wc to revision: f805f5189bbc * Execute: ant update.database | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0023111) hgbot (developer) 2009-12-28 14:19 |
Repository: erp/devel/pi Changeset: 6cce3882983c04da48f8d2cec979bf7a74fb9565 Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Mon Dec 28 14:19:18 2009 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/6cce3882983c04da48f8d2cec979bf7a74fb9565 [^] Fixed 11869: backout faulty changeset to fix build --- M src-db/database/lib/dbsourcemanager.jar --- |
|
(0023134) sureshbabu (viewer) 2009-12-29 11:22 |
Tested & working fine after doing ant update.database |
|
(0023518) hudsonbot (viewer) 2010-01-19 01:41 |
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/6cce3882983c [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/7f3a35240cf9 [^] Tests: http://builds.openbravo.com/view/devel-int/ [^] OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15846.obx [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-12-28 13:08 | iperdomo | New Issue | |
| 2009-12-28 13:08 | iperdomo | Assigned To | => shuehner |
| 2009-12-28 13:08 | iperdomo | OBNetwork customer | => No |
| 2009-12-28 13:08 | iperdomo | Status | new => scheduled |
| 2009-12-28 13:08 | iperdomo | fix_in_branch | => pi |
| 2009-12-28 13:10 | iperdomo | fix_in_branch | pi => |
| 2009-12-28 13:10 | iperdomo | Description Updated | |
| 2009-12-28 14:19 | hgbot | Checkin | |
| 2009-12-28 14:19 | hgbot | Note Added: 0023111 | |
| 2009-12-28 14:19 | hgbot | Status | scheduled => resolved |
| 2009-12-28 14:19 | hgbot | Resolution | open => fixed |
| 2009-12-28 14:19 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/6cce3882983c04da48f8d2cec979bf7a74fb9565 [^] |
| 2009-12-29 11:22 | sureshbabu | Note Added: 0023134 | |
| 2009-12-29 11:22 | sureshbabu | Status | resolved => closed |
| 2009-12-29 11:22 | sureshbabu | Fixed in Version | => 2.50MP10 |
| 2009-12-30 00:00 | anonymous | sf_bug_id | 0 => 2923124 |
| 2010-01-19 01:41 | hudsonbot | Checkin | |
| 2010-01-19 01:41 | hudsonbot | Note Added: 0023518 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |