Cannot complete OfBiz setup wizard

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
12 messages Options
Reply | Threaded
Open this post in threaded view
|

Cannot complete OfBiz setup wizard

Tim Stoel
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
Reply | Threaded
Open this post in threaded view
|

Re: Cannot complete OfBiz setup wizard

hans_bakker
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.

Reply | Threaded
Open this post in threaded view
|

Re: Cannot complete OfBiz setup wizard

BJ Freeman
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
>
Reply | Threaded
Open this post in threaded view
|

Re: Cannot complete OfBiz setup wizard

BJ Freeman
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
>>
>
Reply | Threaded
Open this post in threaded view
|

Re: Cannot complete OfBiz setup wizard

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.
>


Reply | Threaded
Open this post in threaded view
|

Re: Cannot complete OfBiz setup wizard

BJ Freeman
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.
>>
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Cannot complete OfBiz setup wizard

hans_bakker
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.

Reply | Threaded
Open this post in threaded view
|

Re: Cannot complete OfBiz setup wizard

BJ Freeman
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.
>>>
>>
>>
>
Reply | Threaded
Open this post in threaded view
|

Re: Cannot complete OfBiz setup wizard

Tim Stoel
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
>>>
>>


Reply | Threaded
Open this post in threaded view
|

Re: Cannot complete OfBiz setup wizard

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
>>>>
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
>>>>
>>>
>
>


Reply | Threaded
Open this post in threaded view
|

Re: Cannot complete OfBiz setup wizard

BJ Freeman
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
>>>>>
>>>>
>>
>>
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Cannot complete OfBiz setup wizard

hans_bakker
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.