Jacques Le Roux created OFBIZ-11010:
---------------------------------------
Summary: 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: Release Branch 16.11, Trunk, Release Branch 17.12,
Release Branch 18.12
Reporter: Jacques Le Roux
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)
