Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-11010

Touch F8 in webpos does not work and generate an error

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Trunk, Release Branch 16.11, Release Branch 17.12, Release Branch 18.12
    • Fix Version/s: 17.12.01, 16.11.06, 18.12.01
    • Component/s: webpos
    • Labels:
      None

      Description

      While working on OFBIZ-9153 I could not reproduce the same error either in R16 or trunk but got:

      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
      

      After selecting

      1. GZ-1005 '.NIT Gizmo ',
      2. 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)
      3. checking out using the F8 button

        Attachments

          Activity

            People

            • Assignee:
              jacques.le.roux Jacques Le Roux
              Reporter:
              jacques.le.roux Jacques Le Roux
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: