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

Pawan Verma reassigned OFBIZ-11010:
-----------------------------------

    Assignee: Pawan Verma

> 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: Pawan Verma
>            Priority: Major
>
> 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)

Reply via email to