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
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.
