RIB TAFR Adapters Down With "Internal Exception: java.sql.SQLException: ORA-01400" And Cannot Be Started (Doc ID 1593374.1)

Last updated on OCTOBER 07, 2015

Applies to:

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

Symptoms

RIB TAFR JMS Hospital Retry, OrderToOdrWH_tafr_1,ASNOutToASNIn_tafr_1 adapters are down in RIB TAFR instance and cannot be brought up.

OrderToOdrWH_tafr_1.TafrEjb Exception at pians010.mffcomet.com Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))): oracle.toplink.essentials.exceptions.DatabaseException
ASNOutToASNIn_tafr_1.TafrEjb Exception at pians010.mffcomet.com Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))): oracle.toplink.essentials.exceptions.DatabaseException


Errors
------
java.sql.SQLException: ORA-01400: cannot insert NULL into ("TAFRHOSP"."RIB_MESSAGE"."THREAD_VALUE")
javax.ejb.EJBException: Exception thrown during retry.; nested exception is: java.lang.RuntimeException: oracle.jms.AQjmsException: Attempt to use an invalid handle : 'oracle_jdbc_driver_LogicalConnection_Proxy@46ca46ca'.

Cause

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