ORA-01400: Cannot Insert NULL Into ("TAFRHOSP"."RIB_MESSAGE"."THREAD_VALUE") (Doc ID 3038675.1)

Last updated on JULY 31, 2024

Applies to:

Goal

RIB 14.1.2 version

ORA-01400: cannot insert NULL into ("TAFRHOSP"."RIB_MESSAGE"."THREAD_VALUE")

TOPIC messages are not getting processed from RIB

Error Code: 1400
Call: INSERT INTO RIB_MESSAGE (MESSAGE_NUM, ADAPTER_CLASS_LOCATION, ADAPTER_INSTANCE_NUMBER, ATTEMPT_COUNT, DELETE_PENDING, IN_QUEUE, JMS_QUEUE_ID, MAX_ATTEMPTS, NEXT_ATTEMPT_TIME, REASON_CODE, TOPIC_NAME, ID, CUSTOM_DATA, CUSTOM_FLAG, FAMILY, MESSAGE_DATA, PUBLISH_TIME, RIB_MESSAGE_ID, THREAD_VALUE, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [20 parameters bound]
Query: InsertObjectQuery(com.retek.rib.domain.hospital.bo.impl.HospitalEntryImpl@4adec75d[messageNum=568105])
  exception id: 1721493026376
2024-07-20 20:30:26,379 [ASNOutToASNIn_tafr_1] ERROR com.retek.rib.j2ee.RIBMessageTafrEjb - This message is determined as a POISON message, hence writing this message to the file system and shutting down the adapter.
2024-07-20 20:30:26,380 [ASNOutToASNIn_tafr_1] ERROR com.retek.rib.j2ee.RIBMessageTafrEjb - oracle.retail.rib.common.exception.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("TAFRHOSP"."RIB_MESSAGE"."THREAD_VALUE")
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.