ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From BJ Freeman <bjf...@free-man.net>
Subject Re: Create Order Error
Date Wed, 02 Jun 2010 08:36:51 GMT
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
> 


Mime
View raw message