RIB ADAPTER SUB Hospital Retry Fails When A Large Number Of Messages To Delete Exist
(Doc ID 2851759.1)
Last updated on JANUARY 11, 2024
Applies to:
Oracle Retail Integration Cloud Service - Version NA and laterInformation 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 |