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)][roleTyp >>> eId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMet >>> 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 >>> >>
