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 15:13:52 GMT
try changing the visual theme I find that tomhawk sometimes does not
show all the page.


=========================
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 4:12 AM:
> I can't believe it. Is this a bug or something like that? After I have
> added the person "_NA_", shippingMethodType "NO_SHIPPING" and then
> brought it together in CarrierShipmentMethod. I could create an order.
> 
> BUT where are my shipment information in the orderview? How or where I
> must enter a carrier, so that he becomes visible by the orders.
> 
> Thank You
> 
> R. S. schrieb:
>> 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
>>>>
>>>>     
>>>
>>>   
> 


Mime
View raw message