Re: Create Order Error

[R. S.]

Thank you BJ.
but I can not find where I can choose a carrier or why it don't take a 
one of the existing carriers for this order?


BJ Freeman schrieb:
I agree, it seems someone got gung-ho with using _NA_, which was meant
to be used to satisfy views-entities when not all records are avialalible.

I re factored mine (in code also)to user noshipping as an ID.

=========================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation 
<http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>

Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
Linkedin
<http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>


R. S. sent the following on 6/2/2010 1:26 AM:
  
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