[ http://issues.apache.org/jira/browse/OFBIZ-461?page=comments#action_12450136 ] Jacopo Cappellato commented on OFBIZ-461: -----------------------------------------
Si, it makes sense. The code that handles the editing of an existing order has always frighten me too... soonel or later we'll have to consider some serious refactoring or at least heavy testing the whole stuff; the (upcoming?) automated testing framework could probably help a lot in this area... > 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 > > 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
