V16.0.3: SUB Hospital Retry AQ1 Adapter Is Going Down With "ORA-01722: Invalid Number" (Doc ID 2975601.1)

Last updated on SEPTEMBER 26, 2023

Applies to:

Goal

SUB Hospital Retry AQ1 Adapter is Going Down With "ORA-01722: invalid number" after start adapter.

Caused by: oracle.retail.rib.common.exception.PersistenceException: Unable to call sql
select * from (select entry.* from rib_message entry where (id is null or not exists (select null from rib_message ril2 where entry.adapter_class_location=ril2.adapter_class_location and entry.family = ril2.family and entry.id=ril2.id and ril2.id is not null and (ril2.jms_queue_id = ?1 OR ril2.jms_queue_id IS NULL) and ril2.message_num<entry.message_num)) AND entry.in_queue = 0 AND entry.delete_pending = 0 AND entry.attempt_count < entry.max_attempts AND(entry.next_attempt_time IS NULL OR entry.next_attempt_time <= ?3 ) AND entry.reason_code = ?4 and (jms_queue_id = ?2 OR jms_queue_id IS NULL) AND entry.adapter_class_location like ?5 order by entry.message_num) where rownum <= 20
  exception id: 1695169192263
  at com.retek.rib.domain.hospital.dao.impl.HospitalDaoImpl.findHospitalEntryByReadyToRetry(HospitalDaoImpl.java:968) ~[rib-private-kernel-16.0.3.jar:16.0.3]
  at com.retek.rib.domain.hospital.dao.impl.HospitalDaoImpl.getReadyToRetryForDefaultRetrier(HospitalDaoImpl.java:1064) ~[rib-private-kernel-16.0.3.jar:16.0.3]
  at com.retek.rib.collab.HospitalRetryController.doRetry(HospitalRetryController.java:222) ~[rib-private-kernel-16.0.3.jar:16.0.3]
  at com.retek.rib.j2ee.ErrorHospitalRetryEjb.retryMessages(ErrorHospitalRetryEjb.java:228) ~[rib-private-kernel-16.0.3.jar:16.0.3]
  at com.retek.rib.j2ee.ErrorHospitalRetryEjb.doRetry(ErrorHospitalRetryEjb.java:196) ~[rib-private-kernel-16.0.3.jar:16.0.3]
  ... 30 more
Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.7.v20190604-418f1a1c56): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
 

Solution

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