RIB Adapters Shut Down with In-doubt Transactions (Doc ID 1448954.1)

Last updated on MAY 02, 2017

Applies to:

Oracle Retail Integration Bus - Version 13 and later
Information in this document applies to any platform.

Goal

RIB-SIM SUB Hospital Retry adapter is failing with the following exception:

...
2012-04-12 14:16:25,392 [Timer-51] ERROR com.retek.rib.domain.hospital.dao.jpa.HospitalDaoImpl - javax.persistence.PersistenceException: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0 (Build b41-beta2 (03/30/2007))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-01591: lock held by in-doubt distributed transaction 36.0.2
....

Because of this issue,  the adapter is always getting down.
How to resolve this issue ?

Solution

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