The reason for the bug was that the request was called with an additional orderId get parameter. But the orderId was still in the parameter map so the request handler created with these two orderIds a orderId List. These list couldn't be interpreted from the groovy script(because a string was expected). The result was the error message.
> Error when "Add All to Cart" or "Add Checked to Cart" viewing an order in ecommerce
> -----------------------------------------------------------------------------------
>
> Key: OFBIZ-3881
> URL:
https://issues.apache.org/jira/browse/OFBIZ-3881> Project: OFBiz
> Issue Type: Bug
> Components: specialpurpose/ecommerce
> Affects Versions: Release Branch 10.04, SVN trunk
> Environment: ALL
> Reporter: David - DiSiD Technologies
> Attachments: OFBIZ-3881_FixTheAddAllFunctionInOrderHistory.patch
>
>
> When you click the button "Add all to Cart" or "Add Checked to Cart" viewing an order in ecommerce application an error is shown.
> The error is:
> {panel:title=:ERROR MESSAGE:| borderStyle=solid| borderColor=#000| titleBGColor=#cc6666| bgColor=#fff}org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://ecommerce/widget/OrderScreens.xml#orderstatus]: org.ofbiz.base.util.GeneralException: Error running Groovy script at location [component://ecommerce/webapp/ecommerce/WEB-INF/actions/order/OrderStatus.groovy] (SQL Exception while executing the following:SELECT ORDER_TYPE_ID, ORDER_NAME, EXTERNAL_ID, SALES_CHANNEL_ENUM_ID, ORDER_DATE, PRIORITY, ENTRY_DATE, PICK_SHEET_PRINTED_DATE, VISIT_ID, STATUS_ID, CREATED_BY, FIRST_ATTEMPT_ORDER_ID, CURRENCY_UOM, SYNC_STATUS_ID, BILLING_ACCOUNT_ID, ORIGIN_FACILITY_ID, WEB_SITE_ID, PRODUCT_STORE_ID, TERMINAL_ID, TRANSACTION_ID, AUTO_ORDER_SHOPPING_LIST_ID, NEEDS_INVENTORY_ISSUANCE, IS_RUSH_ORDER, INTERNAL_CODE, REMAINING_SUB_TOTAL, GRAND_TOTAL, IS_VIEWED, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.ORDER_HEADER WHERE ORDER_ID=(?, ?) (Syntax error: Encountered "," at line 1, column 563.)) (Error running Groovy script at location [component://ecommerce/webapp/ecommerce/WEB-INF/actions/order/OrderStatus.groovy] (SQL Exception while executing the following:SELECT ORDER_TYPE_ID, ORDER_NAME, EXTERNAL_ID, SALES_CHANNEL_ENUM_ID, ORDER_DATE, PRIORITY, ENTRY_DATE, PICK_SHEET_PRINTED_DATE, VISIT_ID, STATUS_ID, CREATED_BY, FIRST_ATTEMPT_ORDER_ID, CURRENCY_UOM, SYNC_STATUS_ID, BILLING_ACCOUNT_ID, ORIGIN_FACILITY_ID, WEB_SITE_ID, PRODUCT_STORE_ID, TERMINAL_ID, TRANSACTION_ID, AUTO_ORDER_SHOPPING_LIST_ID, NEEDS_INVENTORY_ISSUANCE, IS_RUSH_ORDER, INTERNAL_CODE, REMAINING_SUB_TOTAL, GRAND_TOTAL, IS_VIEWED, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ.ORDER_HEADER WHERE ORDER_ID=(?, ?) (Syntax error: Encountered "," at line 1, column 563.))){panel}
> To repeat the bug:
> In ecommerce application > Order History (
https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/orderhistory) > Login as demo customer (DemoCustomer / ofbiz) > Select an order > Click "Add All to Cart" or "Add Checked to Cart"
Locked
