OfflineDB Consumption in POS Client Fails With 'java.sql.BatchUpdateException' for Frequent Consumer Jobs (Doc ID 1919480.1)

Last updated on FEBRUARY 13, 2017

Applies to:

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

Symptoms

 In Oracle Retail Point of Service (ORPOS) , offlineDB consumption fails to update Frequent Consumer jobs and the following exception occurs:


2. Make sure there are some temp table files (like PA_ATHY_TX_temp.txt, CD_GEO_temp.txt, etc.) in BACKUP folder of IDDI_CACHE of the POS client.

3. Once the POS application is on the Main Options screen for 15 mins (IDDITimeoutInterval) , the offlineDB consumption fails with the above exception.

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