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