Apostrophe in Last Name of Person to Whom Order is Delivered Causes a Queue Exception File and Transaction Is Not Persisted to the Database (Doc ID 1570761.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Point-of-Service - Version 13.1 to 14.0 [Release 13.1 to 14.0]
Information in this document applies to any platform.

Symptoms

Apostrophe in the last name to whom the order is to be delivered causes an "Unknown exception for SQL" queue exception file on the Oracle Retail Point of Service (ORPOS) server.

Exception:

Class: com.extendyourstore.foundation.manager.data.DataException(Revision $Revision: /main/9 $) @34275851: Unknown exception for SQL State code: UNKNOWNSource Exception: com.ibm.db2.jcc.b.co: DB2 SQL Error: SQLCODE=-10, SQLSTATE=42603, SQLERRMC='), DRIVER=3.53.70
Transaction Name: TransactionWriteDataTransaction
Error code: [0] [An unknown exception occurred.]
Error code (extended): [-10]
Description: [Unknown exception for SQL State code: UNKNOWNSource Exception: com.ibm.db2.jcc.b.co: DB2 SQL Error: SQLCODE=-10, SQLSTATE=42603, SQLERRMC='), DRIVER=3.53.70]
Query String: INSERT INTO OR_DEL_DTL ( TL_CNCT, ST_ORD, FN_ADS_DEL, SPL_INSTRC, DC_ORD_DEL, ST_DEL, A1_ADS_DEL, A2_ADS_DEL, CI_DEL, AI_ORD_DEL_DTL, DC_DY_BSN, ID_CT, CO_DEL, TY_PHN, ID_ORD, NM_BSN, PC_DEL, LN_ADS_DEL) VALUES ('33904743', 0, 'Mary', 'lowset house drive straight up drive way laundry is at end of driveway. no dogs. disconnect old and take away old washing machine and install to taps. ', '2011-12-07', 'QLD', '5 Main Street', '', 'Murarrie', 1, '2011-12-06', '07581075000166', 'AU', '0', '0758107511004C', null, '4172', 'O'Hagen')
Original exception: [null]


Steps to Reproduce:

  1. Ring two items.
  2. Change one item to delivery.
  3. When prompted, confirm delivery address and enter special directions.
  4. Press Next to continue.  Enter "O'Hagen" for the Last Name.
  5. Finish the transaction.
  6. Check the Queue Exception folder.  A new file has been created there.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms