[ https://issues.apache.org/jira/browse/OFBIZ-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacopo Cappellato reassigned OFBIZ-3429: ---------------------------------------- Assignee: Jacopo Cappellato > Error on Shipping Estimate deletion > ----------------------------------- > > Key: OFBIZ-3429 > URL: https://issues.apache.org/jira/browse/OFBIZ-3429 > Project: OFBiz > Issue Type: Bug > Reporter: Abdullah Shaikh > Assignee: Jacopo Cappellato > > Create a Shipping Estimate and then try to delete it using the Remove button, > it will throw below mentioned error. > 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".)))) > This is because along with Shipping Estimate it also tries to delete the > QuantityBreak related record which it shouldn't. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.