and also today privatly... On Fri, 2011-08-12 at 02:16 -0700, BJ Freeman wrote: > I believe Hans did respond to you. > My setup code is different than trunk so I am not that familiar with the > trunk version. > > Tim Stoel sent the following on 8/11/2011 3:12 PM: > > 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 > >>>>> > >>>> > >> > >> > > > > > >
-- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates.