You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Jonathon Wong (JIRA)" <ji...@apache.org> on 2007/01/14 02:18:27 UTC
[jira] Commented: (OFBIZ-461) Error when cancelling line items
after completing other line items, order adjustment errors - r470162
[ https://issues.apache.org/jira/browse/OFBIZ-461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12464556 ]
Jonathon Wong commented on OFBIZ-461:
-------------------------------------
Has anyone checked in this patch yet? I'm still getting errors when editing items.
Put briefly, I:
1. Expired ALL promos (work around OFBIZ-431). I'm left with sales and shipping taxes.
2. Bought 5 GZ-DIG and 6 GZ-2644.
3. Edit order items to decrease GZ-DIG to say 3.
I get an SQL exception for "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'".
Checking OrderAdjustmentBilling, I find a single child row linked to OrderAdjustment entry for GZ-2644, not GZ-DIG! Deleting this child row allows adjustments. Even checking checkbox for GZ-DIG (under column "Unit Price") didn't work. I'm guessing the "Update Items" button updates all order items.
Can someone email me an explanation of how OrderAdjustmentBilling entries are created? Sorry for off-topic here. Thanks.
Oh, 1 more small off-topic. Sorry. I can't cancel order item GZ-DIG, but I can GZ-2644. Is it because I can only cancel order items that have their price adjustments billed (have related OrderAdjustmentBilling child)?
> 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