http://ofbiz.116.s1.nabble.com/Users-PO-entry-problem-tp139112p139123.html
That file isn't really necessary, but a properly setup shipping method is. It looks like the shipping method used (from the error message the shipmentMethodTypeId is NO_SHIPPING) is not valid, and the carrier information is also missing. From the data model perspective the shipmentMethodTypeId must be null for no shipment method, hence the error. Actually, to work with every else it is best to create a no shipping shipment method that is explicitly defined with the _NA_ partyId and roleTypeId.
> Its possible that you need to import "ecommerce/data/DemoShipping.xml"
> or set them up yourself. ofbiz may require this info for the order but
> you may be able to just ignore it. still a relative newbie myself so
> just taking a guess on this one.
>
> note that you may have to change the values of partyId="Company" and
> productStoreId="9000" to match what you used when you set it up manually
>
>
>
> Fred
>
>
>
> Mark wrote:
>> OK, now I get to step through all the PO screens up to the last "Create Order" step.
>> That causes this error:
>>
>> Did not complete the order, the following occurred:ERROR : Could not create
>> order (write error :Exception while inserting the following entity:
>> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10011(java.lang.String)][createdStamp,2006-05-14
>> 16:19:08.875(java.sql.Timestamp)][createdTxStamp,2006-05-14
>> 16:19:08.718(java.sql.Timestamp)][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2006-05-14
>> 16:19:08.875(java.sql.Timestamp)][lastUpdatedTxStamp,2006-05-14
>> 16:19:08.718(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10022(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)]
>> (while inserting:
>> [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10011(java.lang.String)][createdStamp,2006-05-14
>> 16:19:08.875(java.sql.Timestamp)][createdTxStamp,2006-05-14
>> 16:19:08.718(java.sql.Timestamp)][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2006-05-14
>> 16:19:08.875(java.sql.Timestamp)][lastUpdatedTxStamp,2006-05-14
>> 16:19:08.718(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10022(java.lang.String)][shipAfterDate,null()][shipByDate,null()][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,(java.lang.String)]
>> (SQL Exception while executing the following:INSERT INTO ORDER_ITEM_SHIP_GROUP
>> (ORDER_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_METHOD_TYPE_ID, CARRIER_PARTY_ID,
>> CARRIER_ROLE_TYPE_ID, CONTACT_MECH_ID, TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER,
>> SHIPPING_INSTRUCTIONS, MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE,
>> SHIP_BY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
>> CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
>> (Duplicate key or integrity constraint violation message from server: "Cannot
>> add or update a child row: a foreign key constraint fails
>> (`ofbiz5/order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN KEY
>> (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, `CARRIER_ROLE_TYPE_ID`)
>> REFERENCES `carrier_shipment_method` (`SHIPMENT)")))).
>>
>>
>> What causes this one? How can I get rid of it?
>> I don't really need shipment, since the Items are picked up at a local supplier
>> (retail store)...
>>
>> Thanks,
>>
>> MARK
>>
>>
>> Hans Bakker wrote:
>>
>>> Sorry, the websiteId is defined here which should specify the productStoreId
>>>
>>> On Monday 15 May 2006 05:27, Hans Bakker wrote:
>>>
>>>
>>>> On Monday 15 May 2006 05:18, Mark wrote:
>>>>
>>>>
>>>>> ....
>>>>> I don't know where that ID comes from, it must be some relation
>>>>> somewhere, but I haven't figured it out yet...<br>
>>>>>
>>>>>
>>>> Please have a look in the file WEB-INF/web.xml, there is the productStoreId
>>>> defined.
>>>>
>>>> hope this helps...
>>>>
>>>>
>>>
>>>
>>> --------------------------------------------------------------------------------
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>>
[hidden email]
>>>
http://lists.ofbiz.org/mailman/listinfo/users>>>
>>
>> ------------------------------------------------------------------------
>>
>>
>> _______________________________________________
>> Users mailing list
>>
[hidden email]
>>
http://lists.ofbiz.org/mailman/listinfo/users>
> _______________________________________________
> Users mailing list
>
[hidden email]
>
http://lists.ofbiz.org/mailman/listinfo/users