You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ofbiz.apache.org by Jonas Colmsjo <jo...@gizur.com> on 2011/11/11 15:57:39 UTC

Error creating Product STore

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

Re: Error creating Product STore

Posted by BJ Freeman <bj...@free-man.net>.

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
>