Error creating Product STore

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

Error creating Product STore

Jonas Colmsjo
Hi,

I just installed ofbiz and I'm trying to do the initial setup. I get an
error when trying to create the Product Store (tab three in the Initial
Setup):

The Following Errors Occurred:

Error: Error parsing entity xml file:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:CarrierShipmentMethod][createdStamp,2011-11-11
15:50:17.968(java.sql.Timestamp)][createdTxStamp,2011-11-11
15:50:17.866(java.sql.Timestamp)][lastUpdatedStamp,2011-11-11
15:50:17.968(java.sql.Timestamp)][lastUpdatedTxStamp,2011-11-11
15:50:17.866(java.sql.Timestamp)][partyId,10000(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.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 (?, ?, ?, ?,
?, ?, ?, ?, ?) (INSERT on table 'CARRIER_SHIPMENT_METHOD' caused a
violation of foreign key constraint 'CARR_SHMETH_TYPE' for key
(LOCAL_DELIVERY). The statement has been rolled back.))  calling service
parseEntityXmlFile in importTempDataFile

I've reinstalled the application but I'm getting the same error.

I'm running OSX Lion.
$ java -version
java version "1.6.0_29"
Java(TM) SE Runtime Environment (build 1.6.0_29-b11-402-11M3527)
Java HotSpot(TM) 64-Bit Server VM (build 20.4-b02-402, mixed mode)

What am I doing wrong?

/BR
Jonas
Reply | Threaded
Open this post in threaded view
|

Re: Error creating Product STore

BJ Freeman
do a google on
ofbiz GenericEntity:CarrierShipmentMethod
there was a email thread and jira back in aug and Sept of this year.


Jonas Colmsjo sent the following on 11/11/2011 6:57 AM:

> Hi,
>
> I just installed ofbiz and I'm trying to do the initial setup. I get an
> error when trying to create the Product Store (tab three in the Initial
> Setup):
>
> The Following Errors Occurred:
>
> Error: Error parsing entity xml file:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:CarrierShipmentMethod][createdStamp,2011-11-11
> 15:50:17.968(java.sql.Timestamp)][createdTxStamp,2011-11-11
> 15:50:17.866(java.sql.Timestamp)][lastUpdatedStamp,2011-11-11
> 15:50:17.968(java.sql.Timestamp)][lastUpdatedTxStamp,2011-11-11
> 15:50:17.866(java.sql.Timestamp)][partyId,10000(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> OFBIZ.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 (?, ?, ?, ?,
> ?, ?, ?, ?, ?) (INSERT on table 'CARRIER_SHIPMENT_METHOD' caused a
> violation of foreign key constraint 'CARR_SHMETH_TYPE' for key
> (LOCAL_DELIVERY). The statement has been rolled back.))  calling service
> parseEntityXmlFile in importTempDataFile
>
> I've reinstalled the application but I'm getting the same error.
>
> I'm running OSX Lion.
> $ java -version
> java version "1.6.0_29"
> Java(TM) SE Runtime Environment (build 1.6.0_29-b11-402-11M3527)
> Java HotSpot(TM) 64-Bit Server VM (build 20.4-b02-402, mixed mode)
>
> What am I doing wrong?
>
> /BR
> Jonas
>