I created a Shipping Estimate and then I clicked on Remove button to delete the shipping estimate, but I got the below error.
It looks it is also trying to delete the record from QuantityBreak table, which it shouldn't. The Following Errors Occurred: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service invocation error (Could not commit transaction for service [removeShipmentEstimate] call: Roll back error, could not commit transaction, was rolled back instead because of: Failure in removeByCondition operation for entity [QuantityBreak]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in deleteByCondition (SQL Exception while executing the following:DELETE FROM public.QUANTITY_BREAK WHERE (QUANTITY_BREAK_ID = 'RentalStore') (ERROR: update or delete on table "quantity_break" violates foreign key constraint "shpmnt_ce_wht_qb" on table "shipment_cost_estimate"<br/> Detail: Key (quantity_break_id)=(RentalStore) is still referenced from table "shipment_cost_estimate".)). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in deleteByCondition (SQL Exception while executing the following:DELETE FROM public.QUANTITY_BREAK WHERE (QUANTITY_BREAK_ID = 'RentalStore') (ERROR: update or delete on table "quantity_break" violates foreign key constraint "shpmnt_ce_wht_qb" on table "shipment_cost_estimate"<br/> Detail: Key (quantity_break_id)=(RentalStore) is still referenced from table "shipment_cost_estimate".)) (Generic Entity Exception occured in deleteByCondition (SQL Exception while executing the following:DELETE FROM public.QUANTITY_BREAK WHERE (QUANTITY_BREAK_ID = 'RentalStore') (ERROR: update or delete on table "quantity_break" violates foreign key constraint "shpmnt_ce_wht_qb" on table "shipment_cost_estimate"<br/> Detail: Key (quantity_break_id)=(RentalStore) is still referenced from table "shipment_cost_estimate".)))) - Abdullah
