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