My Oracle Support Banner

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

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
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.