Hi, When I tried doing the run-install after cleanup I got an error on the console, please advice..
Failure in create operation for entity [DataResource]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:DataResource][createdByUserLogin,admin(java.lang.String)] [createdDate,2004-01-16 01:24:06.522(java.sql.Timestamp)][createdStamp,2010-09-08 16:38:11.039(java.sql.Timestamp)][createdTxStamp,2010-09-08 16:38:11.024(java.sql.Timestamp)][dataResourceId,BLG10000(java.lang.Stri ng)][dataResourceName,Float left(java.lang.String)][dataResourceTypeId,ELECTRONIC_TEXT(java.lang.Str ing)][dataTemplateTypeId,NONE(java.lang.String)][lastModifiedByUserLogin ,bigal(java.lang.String)][lastModifiedDate,2007-01-23 16:46:38.468(java.sql.Timestamp)][lastUpdatedStamp,2010-09-08 16:38:11.039(java.sql.Timestamp)][lastUpdatedTxStamp,2010-09-08 16:38:11.024(java.sql.Timestamp)][mimeTypeId,text/html(java.lang.String) ][objectInfo,component://ecommerce/widget/blog/BlogTemplates.xml#FloatLe ft(java.lang.String)][statusId,CTNT_PUBLISHED(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.DATA_RESOURCE (DATA_RESOURCE_ID, DATA_RESOURCE_TYPE_ID, DATA_TEMPLATE_TYPE_ID, DATA_CATEGORY_ID, DATA_SOURCE_ID, STATUS_ID, DATA_RESOURCE_NAME, LOCALE_STRING, MIME_TYPE_ID, CHARACTER_SET_ID, OBJECT_INFO, SURVEY_ID, SURVEY_RESPONSE_ID, RELATED_DETAIL_ID, IS_PUBLIC, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'DATA_RESOURCE' caused a violation of foreign key constraint 'DATA_REC_LMB_ULGN' for key (bigal). The statement has been rolled back.)). Rolling back transaction. Exception: org.ofbiz.entity.GenericEntityException Message: Error while inserting: [GenericEntity:DataResource][createdByUserLogin,admin(java.lang.String)] [createdDate,2004-01-16 01:24:06.522(java.sql.Timestamp)][createdStamp,2010-09-08 16:38:11.039(java.sql.Timestamp)][createdTxStamp,2010-09-08 16:38:11.024(java.sql.Timestamp)][dataResourceId,BLG10000(java.lang.Stri ng)][dataResourceName,Float left(java.lang.String)][dataResourceTypeId,ELECTRONIC_TEXT(java.lang.Str ing)][dataTemplateTypeId,NONE(java.lang.String)][lastModifiedByUserLogin ,bigal(java.lang.String)][lastModifiedDate,2007-01-23 16:46:38.468(java.sql.Timestamp)][lastUpdatedStamp,2010-09-08 16:38:11.039(java.sql.Timestamp)][lastUpdatedTxStamp,2010-09-08 16:38:11.024(java.sql.Timestamp)][mimeTypeId,text/html(java.lang.String) ][objectInfo,component://ecommerce/widget/blog/BlogTemplates.xml#FloatLe ft(java.lang.String)][statusId,CTNT_PUBLISHED(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.DATA_RESOURCE (DATA_RESOURCE_ID, DATA_RESOURCE_TYPE_ID, DATA_TEMPLATE_TYPE_ID, DATA_CATEGORY_ID, DATA_SOURCE_ID, STATUS_ID, DATA_RESOURCE_NAME, LOCALE_STRING, MIME_TYPE_ID, CHARACTER_SET_ID, OBJECT_INFO, SURVEY_ID, SURVEY_RESPONSE_ID, RELATED_DETAIL_ID, IS_PUBLIC, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'DATA_RESOURCE' caused a violation of foreign key constraint 'DATA_REC_LMB_ULGN' for key (bigal). The statement has been rolled back.)) ---- cause --------------------------------------------------------------------- Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception while executing the following:INSERT INTO OFBIZ.DATA_RESOURCE (DATA_RESOURCE_ID, DATA_RESOURCE_TYPE_ID, DATA_TEMPLATE_TYPE_ID, DATA_CATEGORY_ID, DATA_SOURCE_ID, STATUS_ID, DATA_RESOURCE_NAME, LOCALE_STRING, MIME_TYPE_ID, CHARACTER_SET_ID, OBJECT_INFO, SURVEY_ID, SURVEY_RESPONSE_ID, RELATED_DETAIL_ID, IS_PUBLIC, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'DATA_RESOURCE' caused a violation of foreign key constraint 'DATA_REC_LMB_ULGN' for key (bigal). The statement has been rolled back.) ---- cause --------------------------------------------------------------------- Exception: org.apache.derby.impl.jdbc.EmbedSQLException Message: INSERT on table 'DATA_RESOURCE' caused a violation of foreign key constraint 'DATA_REC_LMB_ULGN' for key (bigal). The statement has been rolled back. ---- cause --------------------------------------------------------------------- Exception: org.apache.derby.iapi.error.StandardException Message: INSERT on table 'DATA_RESOURCE' caused a violation of foreign key constraint 'DATA_REC_LMB_ULGN' for key (bigal). The statement has been rolled back. ---- stack trace --------------------------------------------------------------- ERROR 23503: INSERT on table 'DATA_RESOURCE' caused a violation of foreign key constraint 'DATA_REC_LMB_ULGN' for key (bigal). The statement has been rolled back. -----Original Message----- From: BJ Freeman [mailto:[email protected]] Sent: Wednesday, September 08, 2010 3:25 PM To: [email protected] Subject: Re: Issue with the ecommerce Catalog only suggestion is to ./ant clean-all ./ant run-install ========================= BJ Freeman <http://bjfreeman.elance.com> Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52> Specialtymarket.com <http://www.specialtymarket.com/> Systems Integrator-- Glad to Assist Chat Y! messenger: bjfr33man Deepa Priolkar sent the following on 9/8/2010 2:17 AM: > Hi, > > I Checked all the logs but nowhere its suggesting any issue with the > installation.. > > > -----Original Message----- > From: BJ Freeman [mailto:[email protected]] > Sent: Wednesday, September 08, 2010 2:30 PM > To: [email protected] > Subject: Re: Issue with the ecommerce Catalog > > also check for compile errors > ========================= > > BJ Freeman > Strategic Power Office with Supplier Automation > <http://www.businessesnetwork.com/automation/viewforum.php?f=52> > Specialtymarket.com<http://www.specialtymarket.com/> > Systems Integrator-- Glad to Assist > > Chat Y! messenger: bjfr33man > > > BJ Freeman sent the following on 9/8/2010 1:54 AM: >> sounds like a problem related to the machine. >> 1)did not get a full download of ofbiz >> 2)database configuration >> >> check the runtime/logs >> >> ========================= >> BJ Freeman<http://bjfreeman.elance.com> >> Strategic Power Office with Supplier Automation >> <http://www.businessesnetwork.com/automation/viewforum.php?f=52> >> Specialtymarket.com<http://www.specialtymarket.com/> >> Systems Integrator-- Glad to Assist >> >> Chat Y! messenger: bjfr33man >> >> >> Deepa Priolkar sent the following on 9/8/2010 1:47 AM: >>> Hi, >>> >>> >>> >>> I have recently installed the ofbiz on my machine, I wanted to debug > the >>> ecommerce application of Ofbiz. >>> >>> For some reason I am not able to see the catalog (the feature catalog > is >>> coming null) >>> >>> >>> >>> I have done the ant run-install, which creates the dummy data for > us.. >>> but even after that I am not getting proper catalog. >>> >>> I tried installing on another machine, there I was able to see the >>> catalog. Please advice. >>> >>> >>> >>> Thanks, >>> >>> Deepa >>> >>> >>> > ======================================================================== > ====================================================Disclaimer: >>> This message and the information contained herein is proprietary and >>> confidential and subject to the Tech Mahindra policy statement, you >>> may review the policy at<a >>> > href="http://www.techmahindra.com/Disclaimer.html";>http://www.techmahind > ra.com/Disclaimer.html</a> >>> externally and<a >>> > href="http://tim.techmahindra.com/Disclaimer.html";>http://tim.techmahind > ra.com/Disclaimer.html</a> >>> internally within Tech >>> > Mahindra.=============================================================== > ============================================================= >>> >>> >> >> > > > ======================================================================== ====================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at<a href="http://www.techmahindra.com/Disclaimer.html";>http://www.techmahind ra.com/Disclaimer.html</a> externally and<a href="http://tim.techmahindra.com/Disclaimer.html";>http://tim.techmahind ra.com/Disclaimer.html</a> internally within Tech Mahindra.=============================================================== ============================================================= > ============================================================================================================================Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html";>http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html";>http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.============================================================================================================================
