My Oracle Support Banner

Transactions Fail To Replicate from POS to CO When 2 Customer Address Records Exist for the Same Customer (Doc ID 2731266.1)

Last updated on DECEMBER 08, 2020

Applies to:

Oracle Retail Point-of-Service - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to persist data into the LO_ADS table for customer details as part of a sale transaction, intermittently the ID_ADS and TY_ADS columns are saved as -1. There is also a situation where the LO_ADS table where 2 records exist for the same customer with address types of 0 and1. The transaction replication to CO fails and the following error occurs.

ERROR
-----------------------

020-09-29 12:02:55,906 ERROR [oracle.retail.stores.commerceservices.transaction.ejb.TransactionImportServiceBean] oracle.retail.stores.xmlreplication.importer.ReplicationImportException: Error persisting data to table PA_CT where SQL = UPDATE PA_CT SET ID_PRTY = 183487734, NM_CT = '-1', ID_EM = 'xxxxN.50', STS_CT = ENT.CAIRO, ID_NCRPT_ACTN_CRD = null, ID_MSK_ACNT_CRD = 'xxxx', LCL = null, ID_NCRPT_TAX = '07960', ID_MSK_TAX = null, ID_PRCGP = MX, ID_CT_BTCH = null, TY_CUST = null WHERE ID_CT = '-1'
2020-09-29 12:02:55,914 INFO [oracle.retail.stores.xmlreplication.importer.TableData] Error inserting exsiting row to table PA_PRTY.
2020-09-29 12:02:55,919 ERROR [oracle.retail.stores.xmlreplication.importer.TableData] Error persisting data to table PA_CT.
SQL = UPDATE PA_CT SET ID_PRTY = 183487735, NM_CT = '-1', ID_EM = 'xxxxxN.50', STS_CT = ENT.CAIRO, ID_NCRPT_ACTN_CRD = null, ID_MSK_ACNT_CRD = 'xxxx', LCL = null, ID_NCRPT_TAX = '07960', ID_MSK_TAX = null, ID_PRCGP = MX, ID_CT_BTCH = null, TY_CUST = null, WHERE ID_CT = '-1'
java.lang.NumberFormatException
at java.math.BigDecimal.(BigDecimal.java:499)
at java.math.BigDecimal.(BigDecimal.java:739)
at oracle.retail.stores.xmlreplication.importer.TableData.addColumnDataAndPersistStatement(TableData.java:154)
at oracle.retail.stores.xmlreplication.importer.TableData.persistRow(TableData.java:91)
at oracle.retail.stores.xmlreplication.importer.XMLReplicationImporterHandler.endElement(XMLReplicationImporterHandler.java:118)
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at xxxx.retail.stores.commerceservices.transaction.ejb.TransactionServiceBean.importReplicationXml(TransactionServiceBean.java:5525)
at xxxx.retail.stores.commerceservices.transaction.ejb.TransactionServiceBean.importTransactions(TransactionServiceBean.java:5462)
at xxxx.retail.stores.commerceservices.transaction.ejb.TransactionServiceSB_cle122_EOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
at xxxx.retail.stores.commerceservices.transaction.ejb.TransactionServiceSB_cle122_EOImpl.importTransactions(Unknown Source)
at xxx.oracle.retail.stores.commerceservices.transaction.ejb.xxxTransactionImportServiceBean.doImport(TransactionImportServiceBean.java:96)
at oracle.retail.stores.commerceservices.workflow.ImportBean.onMessage(ImportBean.java:73)
at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:583)
at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:486)
at weblogic.ejb.container.internal.NewJMSMessagePoller.processOneMessage(NewJMSMessagePoller.java:282)
at weblogic.ejb.container.internal.NewJMSMessagePoller.run(NewJMSMessagePoller.java:120)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:550)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.