http://ofbiz.116.s1.nabble.com/Users-PO-entry-problem-tp139112p139122.html
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
> 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