[ https://issues.apache.org/jira/browse/OFBIZ-11010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16836346#comment-16836346 ]
Jacques Le Roux commented on OFBIZ-11010: ----------------------------------------- Thanks Pawan, Missed that indeed :) I'll shortly commit... > 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 > 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)