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 |
You can find an explanation how to do this.
at http://www.antwebsystems.com/Setup-OFBiz-with-your-data-in-15-minutes-16907-content if the problem persists, you may enter a jira issue for this. Depending on the urgency we can help you solve this problem. Regards, Hans. On Wed, 2011-07-20 at 17:04 -0700, Tim Stoel wrote: > 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 -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates. |
In reply to this post by Tim Stoel
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 > |
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 >> > |
In reply to this post by hans_bakker
Thanks for the link Hans, but this page doesn't load for me, I tried the
Google cache and a search with no luck either. Tim > From: Hans Bakker <[hidden email]> > Reply-To: <[hidden email]> > Date: Thu, 21 Jul 2011 08:12:33 +0700 > To: <[hidden email]> > Subject: Re: Cannot complete OfBiz setup wizard > > You can find an explanation how to do this. > at > http://www.antwebsystems.com/Setup-OFBiz-with-your-data-in-15-minutes-16907-co > ntent > > if the problem persists, you may enter a jira issue for this. > > Depending on the urgency we can help you solve this problem. > > Regards, > Hans. > > On Wed, 2011-07-20 at 17:04 -0700, Tim Stoel wrote: >> 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 > > -- > Ofbiz on twitter: http://twitter.com/apache_ofbiz > Myself on twitter: http://twitter.com/hansbak > Antwebsystems.com: Quality services for competitive rates. > |
it took about a minute to be load. The final URL was
http://www.antwebsystems.com/control/mainSetup-OFBiz-with-your-data-in-15-minutes-16907-content did a traceroute to www.antwebsystems.com once left US backbone ttl jump to 176ms min and either timed out or was about 400ms the closer to the server. you can use http://wwww.traceroute.org to view from different places in the world back to your server. Tim Stoel sent the following on 7/21/2011 9:08 AM: > Thanks for the link Hans, but this page doesn't load for me, I tried the > Google cache and a search with no luck either. > > Tim > > >> From: Hans Bakker <[hidden email]> >> Reply-To: <[hidden email]> >> Date: Thu, 21 Jul 2011 08:12:33 +0700 >> To: <[hidden email]> >> Subject: Re: Cannot complete OfBiz setup wizard >> >> You can find an explanation how to do this. >> at >> http://www.antwebsystems.com/Setup-OFBiz-with-your-data-in-15-minutes-16907-co >> ntent >> >> if the problem persists, you may enter a jira issue for this. >> >> Depending on the urgency we can help you solve this problem. >> >> Regards, >> Hans. >> >> On Wed, 2011-07-20 at 17:04 -0700, Tim Stoel wrote: >>> 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 >> >> -- >> Ofbiz on twitter: http://twitter.com/apache_ofbiz >> Myself on twitter: http://twitter.com/hansbak >> Antwebsystems.com: Quality services for competitive rates. >> > > > |
In reply to this post by Tim Stoel
It looks like we are still struggeling with the content seo friendly
url's.... here is the short one: http://www.antwebsystems.com/control/ViewBlogArticle?contentId=16907 Regards, Hans On Thu, 2011-07-21 at 09:08 -0700, Tim Stoel wrote: > Thanks for the link Hans, but this page doesn't load for me, I tried the > Google cache and a search with no luck either. > > Tim > > > > From: Hans Bakker <[hidden email]> > > Reply-To: <[hidden email]> > > Date: Thu, 21 Jul 2011 08:12:33 +0700 > > To: <[hidden email]> > > Subject: Re: Cannot complete OfBiz setup wizard > > > > You can find an explanation how to do this. > > at > > http://www.antwebsystems.com/Setup-OFBiz-with-your-data-in-15-minutes-16907-co > > ntent > > > > if the problem persists, you may enter a jira issue for this. > > > > Depending on the urgency we can help you solve this problem. > > > > Regards, > > Hans. > > > > On Wed, 2011-07-20 at 17:04 -0700, Tim Stoel wrote: > >> 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 > > > > -- > > Ofbiz on twitter: http://twitter.com/apache_ofbiz > > Myself on twitter: http://twitter.com/hansbak > > Antwebsystems.com: Quality services for competitive rates. > > > > -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates. |
step one is confusing, since it refers to the Derby(internal) which
someone that is doing this for real will have or should configured a external DB, which step will not effect. Hans Bakker sent the following on 7/22/2011 3:07 AM: > It looks like we are still struggeling with the content seo friendly > url's.... > > here is the short one: > http://www.antwebsystems.com/control/ViewBlogArticle?contentId=16907 > > Regards, > Hans > > > On Thu, 2011-07-21 at 09:08 -0700, Tim Stoel wrote: >> Thanks for the link Hans, but this page doesn't load for me, I tried the >> Google cache and a search with no luck either. >> >> Tim >> >> >>> From: Hans Bakker <[hidden email]> >>> Reply-To: <[hidden email]> >>> Date: Thu, 21 Jul 2011 08:12:33 +0700 >>> To: <[hidden email]> >>> Subject: Re: Cannot complete OfBiz setup wizard >>> >>> You can find an explanation how to do this. >>> at >>> http://www.antwebsystems.com/Setup-OFBiz-with-your-data-in-15-minutes-16907-co >>> ntent >>> >>> if the problem persists, you may enter a jira issue for this. >>> >>> Depending on the urgency we can help you solve this problem. >>> >>> Regards, >>> Hans. >>> >>> On Wed, 2011-07-20 at 17:04 -0700, Tim Stoel wrote: >>>> 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 >>> >>> -- >>> Ofbiz on twitter: http://twitter.com/apache_ofbiz >>> Myself on twitter: http://twitter.com/hansbak >>> Antwebsystems.com: Quality services for competitive rates. >>> >> >> > |
In reply to this post by BJ Freeman
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 <[hidden email]> > Reply-To: <[hidden email]> > Date: Wed, 20 Jul 2011 23:57:16 -0700 > To: <[hidden email]> > 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 >>> >> |
Bump.... Any insight on this issue?
Tim > From: Tim Stoel <[hidden email]> > Reply-To: <[hidden email]> > Date: Sat, 23 Jul 2011 16:13:44 -0700 > To: <[hidden email]> > 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 <[hidden email]> >> Reply-To: <[hidden email]> >> Date: Wed, 20 Jul 2011 23:57:16 -0700 >> To: <[hidden email]> >> 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 >>>> 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 >>>> >>> > > |
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 <[hidden email]> >> Reply-To: <[hidden email]> >> Date: Sat, 23 Jul 2011 16:13:44 -0700 >> To: <[hidden email]> >> 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 <[hidden email]> >>> Reply-To: <[hidden email]> >>> Date: Wed, 20 Jul 2011 23:57:16 -0700 >>> To: <[hidden email]> >>> 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 >>>>> >>>> >> >> > > > |
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 <[hidden email]> > >> Reply-To: <[hidden email]> > >> Date: Sat, 23 Jul 2011 16:13:44 -0700 > >> To: <[hidden email]> > >> 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 <[hidden email]> > >>> Reply-To: <[hidden email]> > >>> Date: Wed, 20 Jul 2011 23:57:16 -0700 > >>> To: <[hidden email]> > >>> 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. |
Free forum by Nabble | Edit this page |