[
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
