ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "R. S." <r...@meinkino.com>
Subject Create Order Error
Date Wed, 02 Jun 2010 08:26:51 GMT
Hi all,
I'm getting this error after I tried to create an order. If I correctly 
interpret this error then I have to create a carrier with an "_NA_" 
name. Is this correct or not? For me this makes no sense? There already 
exist several carriers and carrier shipment methods. If you can say me 
please, how it's can be solved best?

Error:
The Following Errors Occurred:
Auftrag nicht vervollstÃĪndigt, folgender Fehler trat auf:ERROR : Could 
not create order (write error :Error while inserting: 
[GenericEntity:OrderItemShipGroup][*carrierPartyId,_NA_*(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10021(java.lang.String)][createdStamp,2010-06-02

10:01:43.54(java.sql.Timestamp)][createdTxStamp,2010-06-02 
10:01:43.385(java.sql.Timestamp)][estimatedDeliveryDate,2010-06-09 
09:52:39.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-06-02

10:01:43.54(java.sql.Timestamp)][lastUpdatedTxStamp,2010-06-02 
10:01:43.385(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,123334(java.lang.String)][shipAfterDate,2010-06-04

09:52:44.0(java.sql.Timestamp)][shipByDate,2010-06-15 
09:52:49.0(java.sql.Timestamp)][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,null()][supplierPartyId,null()][vendorPartyId,null()]

(SQL Exception while executing the following:INSERT INTO 
OFBIZ.ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID, 
SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID, 
CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID, 
TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, 
MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, 
ESTIMATED_SHIP_DATE, ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, 
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on 
table 'ORDER_ITEM_SHIP_GROUP' caused a violation of foreign key 
constraint 'ORDER_ITSG_CSHM' for key (*NO_SHIPPING,_NA_,CARRIER*). The 
statement has been rolled back.))).


Many Thanks and Best Regards
Rudolf

Mime
View raw message