[jira] [Closed] (OFBIZ-11010) Touch F8 in webpos does not work and generate an error

["Jacques Le Roux (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OFBIZ-11010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux closed OFBIZ-11010.
-----------------------------------
       Resolution: Fixed
    Fix Version/s: 18.12.01
                   16.11.06
                   17.12.01

Thanks Pawan,

Your patch is in

trunk r1859012
R18 r1859013
R17 r1859014
R16 r1859016

> Touch F8 in webpos does not work and generate an error
> ------------------------------------------------------
>
>                 Key: OFBIZ-11010
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-11010
>             Project: OFBiz
>          Issue Type: Bug
>          Components: webpos
>    Affects Versions: Trunk, Release Branch 16.11, Release Branch 17.12, Release Branch 18.12
>            Reporter: Jacques Le Roux
>            Assignee: Jacques Le Roux
>            Priority: Major
>             Fix For: 17.12.01, 16.11.06, 18.12.01
>
>         Attachments: OFBIZ-11010.patch
>
>
> While working on OFBIZ-9153 I could not reproduce the same error either in R16 or trunk but got:
> {noformat}
> 2019-04-30 12:20:50,272 |jsse-nio-8443-exec-2 |GenericDelegator              |E| Failure in create operation for entity [OrderHeader]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:OrderHeader][agr
> eementId,null()][billingAccountId,null()][createdBy,admin(java.lang.String)][createdStamp,2019-04-30 12:20:50.181(java.sql.Timestamp)][createdTxStamp,2019-04-30 12:20:49.945(java.sql.Timestamp)][currencyUom,USD(java.lang.String)][entryDa
> te,2019-04-30 12:20:50.04(java.sql.Timestamp)][grandTotal,2974.99000(java.math.BigDecimal)][invoicePerShipment,Y(java.lang.String)][lastUpdatedStamp,2019-04-30 12:20:50.181(java.sql.Timestamp)][lastUpdatedTxStamp,2019-04-30 12:20:49.945(
> java.sql.Timestamp)][needsInventoryIssuance,Y(java.lang.String)][orderDate,2019-04-30 12:20:50.04(java.sql.Timestamp)][orderId,RSCO10050(java.lang.String)][orderName,null()][orderTypeId,SALES_ORDER(java.lang.String)][originFacilityId,MyR
> etailStore(java.lang.String)][productStoreId,9100(java.lang.String)][salesChannelEnumId,POS_SALES_CHANNEL(java.lang.String)][statusId,ORDER_CREATED(java.lang.String)][terminalId,pos-1(java.lang.String)][transactionId,10010(java.lang.Stri
> ng)] (SQL Exception while executing the following:INSERT INTO OFBIZ.ORDER_HEADER (ORDER_ID, ORDER_TYPE_ID, ORDER_NAME, EXTERNAL_ID, SALES_CHANNEL_ENUM_ID, ORDER_DATE, PRIORITY, ENTRY_DATE, PICK_SHEET_PRINTED_DATE, VISIT_ID, STATUS_ID, CR
> EATED_BY, FIRST_ATTEMPT_ORDER_ID, CURRENCY_UOM, SYNC_STATUS_ID, BILLING_ACCOUNT_ID, ORIGIN_FACILITY_ID, WEB_SITE_ID, PRODUCT_STORE_ID, AGREEMENT_ID, TERMINAL_ID, TRANSACTION_ID, AUTO_ORDER_SHOPPING_LIST_ID, NEEDS_INVENTORY_ISSUANCE, IS_R
> USH_ORDER, INTERNAL_CODE, REMAINING_SUB_TOTAL, GRAND_TOTAL, IS_VIEWED, INVOICE_PER_SHIPMENT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'ORDER_HEADER' caused a violation of foreign key constraint 'ORDER_HDR_SCENUM' for key (POS_SALES_CHANNEL).  The statement has been rolled back.)). Rolling back transaction.
> 2019-04-30 12:20:50,272 |jsse-nio-8443-exec-2 |TransactionUtil               |I| Transaction rollback only not set, rollback only is already set.
> 2019-04-30 12:20:50,272 |jsse-nio-8443-exec-2 |OrderServices                 |E| Cannot create OrderHeader entity; problems with insert
> {noformat}
> After selecting
> # GZ-1005 '.NIT Gizmo ',
> # paying cash using the F3 button (also there it's does not work very well if you don't put the right amount from start, but that's another hair of the yak)
> # checking out using the F8 button



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)