[ http://issues.apache.org/jira/browse/OFBIZ-461?page=comments#action_12451101 ] Si Chen commented on OFBIZ-461: -------------------------------
This version seems to fix the problem. Let me know if you still have problems. > Error when cancelling line items after completing other line items, order > adjustment errors - r470162 > ----------------------------------------------------------------------------------------------------- > > Key: OFBIZ-461 > URL: http://issues.apache.org/jira/browse/OFBIZ-461 > Project: 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: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
