Posted by
Mark-60 on
May 15, 2006; 12:22am
URL: http://ofbiz.116.s1.nabble.com/Users-PO-entry-problem-tp139112p139121.html
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