[
https://issues.apache.org/jira/browse/OFBIZ-461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12465120 ]
Ray Barlow commented on OFBIZ-461:
----------------------------------
Jonathon,
I don't think anybody has committed this patch.
You've not mentioned completing line items in your comments, which this issue was originally raised as doing, is that important? Are you part shipping, completing some line items or not? If you are not then it might suggest you have found a slightly different variation of this issue and it would be good if you could apply the patch and retest your scenarios.
By the way you listed the bit of SQL that caused an exception but you've cut out the exception, are we to assume it's the same error as the original post in this issue? Assumptions are always a little dangerous, better to be explicate if you can be.
Ray
> 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
