Re: Cannot complete OfBiz setup wizard
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,10(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 (10). 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
Re: Cannot complete OfBiz setup wizard
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,10(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 (10). 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.
Re: Cannot complete OfBiz setup wizard
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,10(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 (10). 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
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,10(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 (10). 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
Re: Cannot complete OfBiz setup wizard
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 mailingl...@antwebsystems.com Reply-To: user@ofbiz.apache.org Date: Thu, 21 Jul 2011 08:12:33 +0700 To: user@ofbiz.apache.org 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.
Re: Cannot complete OfBiz setup wizard
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
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
Re: Cannot complete OfBiz setup wizard
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 mailingl...@antwebsystems.com Reply-To: user@ofbiz.apache.org Date: Thu, 21 Jul 2011 08:12:33 +0700 To: user@ofbiz.apache.org 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.
Re: Cannot complete OfBiz setup wizard
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://.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 mailingl...@antwebsystems.com Reply-To: user@ofbiz.apache.org Date: Thu, 21 Jul 2011 08:12:33 +0700 To: user@ofbiz.apache.org 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.
Cannot complete OfBiz setup wizard
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
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-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.
