[jira] [Closed] (OFBIZ-9153) webpos can not check out in ofbiz 16.11.01 and also in16.11 Release Branch Demo

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

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

Jacques Le Roux closed OFBIZ-9153.
----------------------------------
    Resolution: Fixed

I can' reproduce this error either in R16 or trunk but I get this error


{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

So we should close this issue and open a new one for the issue above. I'll do so in a week w/o comments.

> webpos can not check out in ofbiz 16.11.01 and also in16.11 Release Branch Demo
> -------------------------------------------------------------------------------
>
>                 Key: OFBIZ-9153
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-9153
>             Project: OFBiz
>          Issue Type: Bug
>          Components: webpos
>    Affects Versions: 16.11.01
>            Reporter: 李浩
>            Priority: Major
>
>  in Keyboard Shortcuts's"F7 PAY BY CC
> "
> is not credit card pay but actualy is checkout and insert order.
> F8  CHECKOUT  actualy just focus on product amount.
> If we checkout ,will encount an error"INSERT on table 'ORDER_HEADER' caused a violation of foreign key constraint 'ORDER_HDR_SCENUM' for key (POS_SALES_CHANNEL)."background
> the reason is enum_id column of ofbiz.ENUMERATION table does not contain the data "POS_SALES_CHANNEL".
> so now webpos demo can not check out and create order.



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