Just tested on the alternative server (actually my dev machine) and it works (see - if it's available- WG-5569 with status "created" on order WSCO10071). There is also a note at bottom " Added item to order: WG-5569 (1.0)"
I tried the same on the demo server but got this message
<<There was an error while calculating the price (Service target threw an unexpected exception (null))>> (order WSCO10022). Not sure why (no access to log) or if it's related to yours

Jacques

From: "Hansen Wang" <[EMAIL PROTECTED]>
Hi,

The following exception happened when I try to add one item to an approved
order. It is a foreign key violation but I do not know why it would happen.
Any information about this would be appreciated. I will trace the code to
find it out later today.

Thanks
Hansen

Generic Entity Exception occured in deleteByCondition (SQL Exception while
executing the following:DELETE FROM ORDER_ADJUSTMENT WHERE (ORDER_ID =
'WS10015' AND (ORDER_ADJUSTMENT_TYPE_ID = 'PROMOTION_ADJUSTMENT' OR
ORDER_ADJUSTMENT_TYPE_ID = 'SHIPPING_CHARGES' OR ORDER_ADJUSTMENT_TYPE_ID =
'SALES_TAX')) (Cannot delete or update a parent row: a foreign key
constraint fails (`ofbiz/ORDER_ADJUSTMENT_BILLING`, CONSTRAINT
`ORDER_ADJBLNG_OA` FOREIGN KEY (`ORDER_ADJUSTMENT_ID`) REFERENCES
`ORDER_ADJUSTMENT` (`ORDER_ADJUSTMENT_ID`))))


Reply via email to