Need help using /ofbizsetup!

[charleslcso]

Just installed ofbiz 10.04.02, and following the guide

http://demo-trunk.ofbiz.apache.org/cmssite/cms/APACHE_OFBIZ_HTML

to set it up.

At Product Store section, and upon clicking button "Update" the following error occurred:

Error: Error parsing entity xml file: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CarrierShipmentMethod][createdStamp,2012-06-02 11:52:49.89(java.sql.Timestamp)][createdTxStamp,2012-06-02 11:52:49.701(java.sql.Timestamp)][lastUpdatedStamp,2012-06-02 11:52:49.89(java.sql.Timestamp)][lastUpdatedTxStamp,2012-06-02 11:52:49.701(java.sql.Timestamp)][partyId,Company(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 public.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 (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "carrier_shipment_method" violates foreign key constraint "carr_shmeth_type"<br/> Detail: Key (shipment_method_type_id)=(LOCAL_DELIVERY) is not present in table "shipment_method_type".))  calling service parseEntityXmlFile in importTempDataFile

Checked the table "shipment_method_type" and it's empty.

How do I manually load all the shipment related tables into the database using ant?

BTW, I only executed ./ant  run-install-extseed before trying to run /ofbizsetup.

Please help!

[Jacques Le Roux]

Can you reproduce with trunk?

Jacques

From: "charleslcso" <[hidden email]>

> Just installed ofbiz 10.04.02, and following the guide
>
> http://demo-trunk.ofbiz.apache.org/cmssite/cms/APACHE_OFBIZ_HTML
>
> to set it up.
>
> At Product Store section, and upon clicking button "Update" the following
> error occurred:
>
> Error: Error parsing entity xml file:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:CarrierShipmentMethod][createdStamp,2012-06-02
> 11:52:49.89(java.sql.Timestamp)][createdTxStamp,2012-06-02
> 11:52:49.701(java.sql.Timestamp)][lastUpdatedStamp,2012-06-02
> 11:52:49.89(java.sql.Timestamp)][lastUpdatedTxStamp,2012-06-02
> 11:52:49.701(java.sql.Timestamp)][partyId,Company(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
> public.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 (?, ?, ?, ?,
> ?, ?, ?, ?, ?) (ERROR: insert or update on table "carrier_shipment_method"
> violates foreign key constraint "carr_shmeth_type"<br/> Detail: Key
> (shipment_method_type_id)=(LOCAL_DELIVERY) is not present in table
> "shipment_method_type".))  calling service parseEntityXmlFile in
> importTempDataFile
>
> Checked the table "shipment_method_type" and it's empty.
>
> How do I manually load all the shipment related tables into the database
> using ant?
>
> BTW, I only executed ./ant  run-install-extseed before trying to run
> /ofbizsetup.
>
> Please help!
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Need-help-using-ofbizsetup-tp4632997.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

[charleslcso]

OK, no error in trunk.

[BJ Freeman]

The seed data does not include some data the demo does, so it will work
on the Demo trunk but not on an install.
I believe there is a Jira about this and a thread some time back.

Jacques Le Roux sent the following on 6/2/2012 3:08 AM:

> Can you reproduce with trunk?
>
> Jacques
>
> From: "charleslcso" <[hidden email]>
>> Just installed ofbiz 10.04.02, and following the guide
>>
>> http://demo-trunk.ofbiz.apache.org/cmssite/cms/APACHE_OFBIZ_HTML
>>
>> to set it up.
>>
>> At Product Store section, and upon clicking button "Update" the following
>> error occurred:
>>
>> Error: Error parsing entity xml file:
>> org.ofbiz.entity.GenericEntityException: Error while inserting:
>> [GenericEntity:CarrierShipmentMethod][createdStamp,2012-06-02
>> 11:52:49.89(java.sql.Timestamp)][createdTxStamp,2012-06-02
>> 11:52:49.701(java.sql.Timestamp)][lastUpdatedStamp,2012-06-02
>> 11:52:49.89(java.sql.Timestamp)][lastUpdatedTxStamp,2012-06-02
>> 11:52:49.701(java.sql.Timestamp)][partyId,Company(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
>> public.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 (?, ?,
>> ?, ?,
>> ?, ?, ?, ?, ?) (ERROR: insert or update on table
>> "carrier_shipment_method"
>> violates foreign key constraint "carr_shmeth_type"<br/> Detail: Key
>> (shipment_method_type_id)=(LOCAL_DELIVERY) is not present in table
>> "shipment_method_type".)) calling service parseEntityXmlFile in
>> importTempDataFile
>>
>> Checked the table "shipment_method_type" and it's empty.
>>
>> How do I manually load all the shipment related tables into the database
>> using ant?
>>
>> BTW, I only executed ./ant run-install-extseed before trying to run
>> /ofbizsetup.
>>
>> Please help!
>>
>> --
>> View this message in context:
>> http://ofbiz.135035.n4.nabble.com/Need-help-using-ofbizsetup-tp4632997.html
>>
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[charleslcso]

For both trunk n the 10.04.02 release, I only ran install-extseed. Do you mean running this command will load the demo data in the Trunk version?

[Jacques Le Roux-3]

Nope, BJ confused the trunk demo and making it locally with a trunk WC

But he is right, I confusely remember a Jira about that... A good moment to train you Jira ability ;o)

Jacques

From: "charleslcso" <[hidden email]>
> For both trunk n the 10.04.02 release, I only ran install-extseed. Do you
> mean running this command will load the demo data in the Trunk version?
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Need-help-using-ofbizsetup-tp4632997p4633067.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.