Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011869Openbravo ERPY. DBSourceManagerpublic2009-12-28 13:082010-01-19 01:41
Reporteriperdomo 
Assigned Toshuehner 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version2.6.30-gentoo-r5
Product Versionpi 
Target VersionpiFixed in Version2.50MP10 
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
Summary0011869: SQL Command failed with: ERROR: column "binarydata" is of type oid but expression is of type bytea
DescriptionError 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-12-28 13:08iperdomoNew Issue
2009-12-28 13:08iperdomoAssigned To => shuehner
2009-12-28 13:08iperdomoOBNetwork customer => No
2009-12-28 13:08iperdomoStatusnew => scheduled
2009-12-28 13:08iperdomofix_in_branch => pi
2009-12-28 13:10iperdomofix_in_branchpi =>
2009-12-28 13:10iperdomoDescription Updated
2009-12-28 14:19hgbotCheckin
2009-12-28 14:19hgbotNote Added: 0023111
2009-12-28 14:19hgbotStatusscheduled => resolved
2009-12-28 14:19hgbotResolutionopen => fixed
2009-12-28 14:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6cce3882983c04da48f8d2cec979bf7a74fb9565 [^]
2009-12-29 11:22sureshbabuNote Added: 0023134
2009-12-29 11:22sureshbabuStatusresolved => closed
2009-12-29 11:22sureshbabuFixed in Version => 2.50MP10
2009-12-30 00:00anonymoussf_bug_id0 => 2923124
2010-01-19 01:41hudsonbotCheckin
2010-01-19 01:41hudsonbotNote Added: 0023518

Notes
(0023111)
hgbot   
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   
2009-12-29 11:22   
Tested & working fine after doing ant update.database
(0023518)
hudsonbot   
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 [^]