My Oracle Support Banner

RIB ADAPTER SUB Hospital Retry Fails When A Large Number Of Messages To Delete Exist (Doc ID 2851759.1)

Last updated on MARCH 02, 2022

Applies to:

Oracle Retail Integration Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

When a large number of messages are requested to be purged (e.g. > 100k), due to the volume, the Adapter Hospital fails with the following error:

Caused by: org.eclipse.persistence.exceptions.DatabaseException:
Internal Exception: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation

Steps To Recreate:

1 - Create large volume of RIB messages with incorrect data (e.g. invalid item) above 100k
2 - After messages fail 5 times, go to RIHA and request to delete all
3 - Verify the SUB Adapter fails to delete messages due to timeout

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.