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 >
