OFBiz › OFBiz - Dev

[jira] Created: (OFBIZ-3429) Error on Shipping Estimate deletion

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

4 messages Options

Nicolas Malin (Jira)

[jira] Created: (OFBIZ-3429) Error on Shipping Estimate deletion

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

Nicolas Malin (Jira)

[jira] Resolved: (OFBIZ-3429) Error on Shipping Estimate deletion

[ https://issues.apache.org/jira/browse/OFBIZ-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacopo Cappellato resolved OFBIZ-3429.
--------------------------------------

Resolution: Fixed

Fixed in rev. 904020

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

Nicolas Malin (Jira)

[jira] Assigned: (OFBIZ-3429) Error on Shipping Estimate deletion

In reply to this post by Nicolas Malin (Jira)

[ 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

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Nicolas Malin (Jira)

[jira] Closed: (OFBIZ-3429) Error on Shipping Estimate deletion

In reply to this post by Nicolas Malin (Jira)

[ https://issues.apache.org/jira/browse/OFBIZ-3429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacopo Cappellato closed OFBIZ-3429.
------------------------------------

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.