Bump.... Any insight on this issue? Tim
> From: Tim Stoel <t...@paserv.com> > Reply-To: <user@ofbiz.apache.org> > Date: Sat, 23 Jul 2011 16:13:44 -0700 > To: <user@ofbiz.apache.org> > Subject: Re: Cannot complete OfBiz setup wizard > > Thanks BJ, that got me much further down the road. I have successfully > gotten through the setup wizard steps except "Set to Complete". Before > running the setup wizard I imported ShippingData.xml and > EntityDiagramGroupData.xml (not sure I needed this file) using WebTools XML > Import Data. When I got through the wizard I clicked "Set to complete" and > I got this error: > > Error: Error parsing entity xml file: > org.ofbiz.entity.GenericEntityException: Error while inserting: > [GenericEntity:GlAccountOrganization][createdStamp,2011-07-23 > 16:10:00.043(java.sql.Timestamp)][createdTxStamp,2011-07-23 > 16:09:59.889(java.sql.Timestamp)][fromDate,2011-07-23 > 16:09:59.986(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][last > UpdatedStamp,2011-07-23 > 16:10:00.043(java.sql.Timestamp)][lastUpdatedTxStamp,2011-07-23 > 16:09:59.889(java.sql.Timestamp)][organizationPartyId,Company(java.lang.Stri > ng)] (SQL Exception while executing the following:INSERT INTO > OFBIZ.GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, > ROLE_TYPE_ID, FROM_DATE, THRU_DATE, POSTED_BALANCE, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, > ?, ?, ?, ?, ?, ?) (INSERT on table 'GL_ACCOUNT_ORGANIZATION' caused a > violation of foreign key constraint 'GLACCT_ORG_GLA' for key (100000). The > statement has been rolled back.)) calling service parseEntityXmlFile in > importTempDataFile > > Is there more data I need to be importing manually? > > Thanks, > Tim > > >> From: BJ Freeman <bjf...@free-man.net> >> Reply-To: <user@ofbiz.apache.org> >> Date: Wed, 20 Jul 2011 23:57:16 -0700 >> To: <user@ofbiz.apache.org> >> Subject: Re: Cannot complete OfBiz setup wizard >> >> sorry >> Import Default ProductStore & Shipment data >> >> BJ Freeman sent the following on 7/20/2011 11:53 PM: >>> information needs to be added into the process to import the General ledger >>> look at Setupevents.xml >>> create General Ledger Setup >>> >>> >>> Tim Stoel sent the following on 7/20/2011 5:04 PM: >>>> I have installed OfBiz 10.04 on Centos 5.6 with MySQL, and no demo data is >>>> installed. I just deleted the databases, recreated them, and ran ./ant >>>> run-install-seed and ./ant create-admin-user-login, and then started the >>>> setup wizard. I filled out ³Organization² ³Facility² and I am unable to >>>> complete ³Product Store². I am getting this error: >>>> >>>> Error: Error parsing entity xml file: >>>> org.ofbiz.entity.GenericEntityException: Error while inserting: >>>> [GenericEntity:CarrierShipmentMethod][createdStamp,2011-07-20 >>>> 16:58:15.373(java.sql.Timestamp)][createdTxStamp,2011-07-20 >>>> 16:58:15.286(java.sql.Timestamp)][lastUpdatedStamp,2011-07-20 >>>> 16:58:15.373(java.sql.Timestamp)][lastUpdatedTxStamp,2011-07-20 >>>> 16:58:15.286(java.sql.Timestamp)][partyId,Company(java.lang.String)][roleTy>>>> p >>>> eId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMe>>>> t >>>> hodTypeId,LOCAL_DELIVERY(java.lang.String)] (SQL Exception while executing >>>> the following:INSERT INTO CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, >>>> PARTY_ID, ROLE_TYPE_ID, SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, >>>> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) >>>> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a >>>> foreign key constraint fails (`ofbiz/CARRIER_SHIPMENT_METHOD`, CONSTRAINT >>>> `CARR_SHMETH_TYPE` FOREIGN KEY (`SHIPMENT_METHOD_TYPE_ID`) REFERENCES >>>> `SHIPMENT_METHOD_TYPE` (`SHIPMENT_METHOD_TYPE_ID`)))) calling service >>>> parseEntityXmlFile in importTempDataFile >>>> >>>> Should I even be using this wizard to set up OfBiz? Or should I just do it >>>> all manually? >>>> >>>> Thanks in advance! >>>> Tim Stoel >>>> >>> > >