Ofbizsetup problem

[Pierce Wetter]

It's all good until I try to save a product store:

The Following Errors Occurred:
Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2010-07-30 15:51:45.987(java.sql.Timestamp)][createdTxStamp,2010-07-30 15:51:45.554(java.sql.Timestamp)][lastUpdatedStamp,2010-07-30 15:51:45.987(java.sql.Timestamp)][lastUpdatedTxStamp,2010-07-30 15:51:45.554(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

[BJ Freeman]

are you an end user or developer.

what steps did you perform.

violation of foreign key constraint 'CARR_SHMETH_TYPE' says that
there is not ship method type LOCAL_DELIVERY


Pierce Wetter sent the following on 7/30/2010 3:53 PM:
> It's all good until I try to save a product store:
>
> The Following Errors Occurred:
> Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2010-07-30 15:51:45.987(java.sql.Timestamp)][createdTxStamp,2010-07-30 15:51:45.554(java.sql.Timestamp)][lastUpdatedStamp,2010-07-30 15:51:45.987(java.sql.Timestamp)][lastUpdatedTxStamp,2010-07-30 15:51:45.554(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

[Pierce Wetter]

On Jul 30, 2010, at 4:13 PM, BJ Freeman wrote:

> are you an end user or developer.

 I'm a developer, fairly new to OFBiz. I've looked at the demo store before, but it's overkill, so I decided to start with ofbizsetup instead.
>
> what steps did you perform.

1. Checkout ofbiz from svn
2. ant run-install-extseed
3. ant create-admin-user-login
4. ./startofbiz.sh
5. Go to http://localhost:8080/ofbizsetup

I setup an organization, I setup a facility, then I started to setup a Product Store and boom.

>
> violation of foreign key constraint 'CARR_SHMETH_TYPE' says that
> there is not ship method type LOCAL_DELIVERY

   Yep. I'm guessing that the ofbizsetup assumes there is in either the ext or seed data, but its not for some reason, so when you make a new store, it tries to include that as one of the options and boom. I see it in applications/commonext/data/ though, but I don't know enough about ofbiz to know if that means anything. Poking around...webtools/xmldataexport is saying that there's nothing in ShipmentMethodType.

  So perhaps the real problem is that the ext data isn't loading.

 Pierce

[BJ Freeman]

I think Shipping method should be part of seed data.
create a Jira and a patch if you have time.
https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Contributors+Best+Practices

Pierce Wetter sent the following on 7/30/2010 4:53 PM:

>
> On Jul 30, 2010, at 4:13 PM, BJ Freeman wrote:
>
>> are you an end user or developer.
>
>   I'm a developer, fairly new to OFBiz. I've looked at the demo store before, but it's overkill, so I decided to start with ofbizsetup instead.
>>
>> what steps did you perform.
>
> 1. Checkout ofbiz from svn
> 2. ant run-install-extseed
> 3. ant create-admin-user-login
> 4. ./startofbiz.sh
> 5. Go to http://localhost:8080/ofbizsetup
>
> I setup an organization, I setup a facility, then I started to setup a Product Store and boom.
>
>>
>> violation of foreign key constraint 'CARR_SHMETH_TYPE' says that
>> there is not ship method type LOCAL_DELIVERY
>
>     Yep. I'm guessing that the ofbizsetup assumes there is in either the ext or seed data, but its not for some reason, so when you make a new store, it tries to include that as one of the options and boom. I see it in applications/commonext/data/ though, but I don't know enough about ofbiz to know if that means anything. Poking around...webtools/xmldataexport is saying that there's nothing in ShipmentMethodType.
>
>    So perhaps the real problem is that the ext data isn't loading.
>
>   Pierce

[Pierce Wetter]

On Jul 30, 2010, at 5:01 PM, BJ Freeman wrote:

> I think Shipping method should be part of seed data.

 I'm assuming its in ext, because its in applications/commonext/data.

> create a Jira and a patch if you have time.
> https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Contributors+Best+Practices

  To make a patch, I'd have to know more about ofbiz then I do at this point. :-)

  If I do:

  java -jar ofbiz.jar -install -readers=ext

  I get "No data load files" found.

 Pierce

[BJ Freeman]

you have two choices,
1) find the data and import through webtools
2) use the ./ant -p to see a target for importing a file.


Pierce Wetter sent the following on 7/30/2010 5:13 PM:

>
> On Jul 30, 2010, at 5:01 PM, BJ Freeman wrote:
>
>> I think Shipping method should be part of seed data.
>
>   I'm assuming its in ext, because its in applications/commonext/data.
>
>> create a Jira and a patch if you have time.
>> https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Contributors+Best+Practices
>
>    To make a patch, I'd have to know more about ofbiz then I do at this point. :-)
>
>    If I do:
>
>    java -jar ofbiz.jar -install -readers=ext
>
>    I get "No data load files" found.
>
>   Pierce

[Pierce Wetter]

On Jul 30, 2010, at 8:10 PM, BJ Freeman wrote:

> you have two choices,
> 1) find the data and import through webtools
> 2) use the ./ant -p to see a target for importing a file.

 Oh, never would have thought of those. Thanks!