[
https://issues.apache.org/jira/browse/OFBIZ-461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12465177 ]
Jonathon Wong commented on OFBIZ-461:
-------------------------------------
Error is: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in deleteByCondition (SQL Exception while executing the following:DELETE FROM ORDER_ADJUSTMENT WHERE (ORDER_ID = 'WS10043' 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))
Yeah, after I read the issue description again, I realized I chanced upon a different variation of the error. Perhaps even a different error altogether.
> Error when cancelling line items after completing other line items, order adjustment errors - r470162
> -----------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-461
> URL:
https://issues.apache.org/jira/browse/OFBIZ-461> Project: Apache OFBiz (The Open for Business Project)
> Issue Type: Bug
> Components: order
> Affects Versions: SVN trunk
> Environment: N/A
> Reporter: Ray Barlow
> Assigned To: Si Chen
> Attachments: OFBIZ-461_1.patch.zip
>
>
> Si,
> Looks like r470162 has caused this problem.
> Create a new order and add two products GZ-1000 and GZ-1001 and then approve the new order.
> Click on "Pack Shipment For Ship Group [00001]" and ensure you only pack and complete the product GZ-1000.
> Viewing the order again you should have an invoice for the part shipment and the outstanding GZ-1001 still in the approved state.
> Click on the "Edit Items" and then "Cancel" the GZ-1001.
> This is the error message:
> Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service invocation error (Exception while deleting the following entity: [GenericEntity:OrderAdjustment][orderAdjustmentId,10003(java.lang.String)] (SQL Exception while executing the following:DELETE FROM OFBIZ.ORDER_ADJUSTMENT WHERE ORDER_ADJUSTMENT_ID=? (DELETE on table 'ORDER_ADJUSTMENT' caused a violation of foreign key constraint 'ORDER_ADJBLNG_OA' for key (10003). The statement has been rolled back.)))
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://issues.apache.org/jira/secure/Administrators.jspa-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Locked
