My guess would be that part of the order has already been shipped, if that's
the case then editing an order in that state probably isn't possible (not
supported) at this stage.
Regards
Scott
On 16/03/2008, Jacques Le Roux <
[hidden email]> wrote:
>
> 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" <
[hidden email]>
>
> > 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`))))
> >
>
>
Locked
