You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Tim Stoel <ti...@paserv.com> on 2011/08/12 00:12:41 UTC
Re: Cannot complete OfBiz setup wizard
Bump.... Any insight on this issue?
Tim
> From: Tim Stoel <ti...@paserv.com>
> Reply-To: <us...@ofbiz.apache.org>
> Date: Sat, 23 Jul 2011 16:13:44 -0700
> To: <us...@ofbiz.apache.org>
> Subject: Re: Cannot complete OfBiz setup wizard
>
> Thanks BJ, that got me much further down the road. I have successfully
> gotten through the setup wizard steps except "Set to Complete". Before
> running the setup wizard I imported ShippingData.xml and
> EntityDiagramGroupData.xml (not sure I needed this file) using WebTools XML
> Import Data. When I got through the wizard I clicked "Set to complete" and
> I got this error:
>
> Error: Error parsing entity xml file:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:GlAccountOrganization][createdStamp,2011-07-23
> 16:10:00.043(java.sql.Timestamp)][createdTxStamp,2011-07-23
> 16:09:59.889(java.sql.Timestamp)][fromDate,2011-07-23
> 16:09:59.986(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][last
> UpdatedStamp,2011-07-23
> 16:10:00.043(java.sql.Timestamp)][lastUpdatedTxStamp,2011-07-23
> 16:09:59.889(java.sql.Timestamp)][organizationPartyId,Company(java.lang.Stri
> ng)] (SQL Exception while executing the following:INSERT INTO
> OFBIZ.GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID,
> ROLE_TYPE_ID, FROM_DATE, THRU_DATE, POSTED_BALANCE, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?) (INSERT on table 'GL_ACCOUNT_ORGANIZATION' caused a
> violation of foreign key constraint 'GLACCT_ORG_GLA' for key (100000). The
> statement has been rolled back.)) calling service parseEntityXmlFile in
> importTempDataFile
>
> Is there more data I need to be importing manually?
>
> Thanks,
> Tim
>
>
>> From: BJ Freeman <bj...@free-man.net>
>> Reply-To: <us...@ofbiz.apache.org>
>> Date: Wed, 20 Jul 2011 23:57:16 -0700
>> To: <us...@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
Posted by Hans Bakker <ma...@antwebsystems.com>.
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 <ti...@paserv.com>
> >> Reply-To: <us...@ofbiz.apache.org>
> >> Date: Sat, 23 Jul 2011 16:13:44 -0700
> >> To: <us...@ofbiz.apache.org>
> >> Subject: Re: Cannot complete OfBiz setup wizard
> >>
> >> Thanks BJ, that got me much further down the road. I have successfully
> >> gotten through the setup wizard steps except "Set to Complete". Before
> >> running the setup wizard I imported ShippingData.xml and
> >> EntityDiagramGroupData.xml (not sure I needed this file) using WebTools XML
> >> Import Data. When I got through the wizard I clicked "Set to complete" and
> >> I got this error:
> >>
> >> Error: Error parsing entity xml file:
> >> org.ofbiz.entity.GenericEntityException: Error while inserting:
> >> [GenericEntity:GlAccountOrganization][createdStamp,2011-07-23
> >> 16:10:00.043(java.sql.Timestamp)][createdTxStamp,2011-07-23
> >> 16:09:59.889(java.sql.Timestamp)][fromDate,2011-07-23
> >> 16:09:59.986(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][last
> >> UpdatedStamp,2011-07-23
> >> 16:10:00.043(java.sql.Timestamp)][lastUpdatedTxStamp,2011-07-23
> >> 16:09:59.889(java.sql.Timestamp)][organizationPartyId,Company(java.lang.Stri
> >> ng)] (SQL Exception while executing the following:INSERT INTO
> >> OFBIZ.GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID,
> >> ROLE_TYPE_ID, FROM_DATE, THRU_DATE, POSTED_BALANCE, LAST_UPDATED_STAMP,
> >> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> >> ?, ?, ?, ?, ?, ?) (INSERT on table 'GL_ACCOUNT_ORGANIZATION' caused a
> >> violation of foreign key constraint 'GLACCT_ORG_GLA' for key (100000). The
> >> statement has been rolled back.)) calling service parseEntityXmlFile in
> >> importTempDataFile
> >>
> >> Is there more data I need to be importing manually?
> >>
> >> Thanks,
> >> Tim
> >>
> >>
> >>> From: BJ Freeman <bj...@free-man.net>
> >>> Reply-To: <us...@ofbiz.apache.org>
> >>> Date: Wed, 20 Jul 2011 23:57:16 -0700
> >>> To: <us...@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
Posted by BJ Freeman <bj...@free-man.net>.
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 <ti...@paserv.com>
>> Reply-To: <us...@ofbiz.apache.org>
>> Date: Sat, 23 Jul 2011 16:13:44 -0700
>> To: <us...@ofbiz.apache.org>
>> Subject: Re: Cannot complete OfBiz setup wizard
>>
>> Thanks BJ, that got me much further down the road. I have successfully
>> gotten through the setup wizard steps except "Set to Complete". Before
>> running the setup wizard I imported ShippingData.xml and
>> EntityDiagramGroupData.xml (not sure I needed this file) using WebTools XML
>> Import Data. When I got through the wizard I clicked "Set to complete" and
>> I got this error:
>>
>> Error: Error parsing entity xml file:
>> org.ofbiz.entity.GenericEntityException: Error while inserting:
>> [GenericEntity:GlAccountOrganization][createdStamp,2011-07-23
>> 16:10:00.043(java.sql.Timestamp)][createdTxStamp,2011-07-23
>> 16:09:59.889(java.sql.Timestamp)][fromDate,2011-07-23
>> 16:09:59.986(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][last
>> UpdatedStamp,2011-07-23
>> 16:10:00.043(java.sql.Timestamp)][lastUpdatedTxStamp,2011-07-23
>> 16:09:59.889(java.sql.Timestamp)][organizationPartyId,Company(java.lang.Stri
>> ng)] (SQL Exception while executing the following:INSERT INTO
>> OFBIZ.GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID,
>> ROLE_TYPE_ID, FROM_DATE, THRU_DATE, POSTED_BALANCE, LAST_UPDATED_STAMP,
>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
>> ?, ?, ?, ?, ?, ?) (INSERT on table 'GL_ACCOUNT_ORGANIZATION' caused a
>> violation of foreign key constraint 'GLACCT_ORG_GLA' for key (100000). The
>> statement has been rolled back.)) calling service parseEntityXmlFile in
>> importTempDataFile
>>
>> Is there more data I need to be importing manually?
>>
>> Thanks,
>> Tim
>>
>>
>>> From: BJ Freeman <bj...@free-man.net>
>>> Reply-To: <us...@ofbiz.apache.org>
>>> Date: Wed, 20 Jul 2011 23:57:16 -0700
>>> To: <us...@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
>>>>>
>>>>
>>
>>
>
>
>