My Oracle Support Banner

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:

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


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 = and and 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 ~[rib-private-kernel-16.0.3.jar:16.0.3]
  at ~[rib-private-kernel-16.0.3.jar:16.0.3]
  at com.retek.rib.collab.HospitalRetryController.doRetry( ~[rib-private-kernel-16.0.3.jar:16.0.3]
  at com.retek.rib.j2ee.ErrorHospitalRetryEjb.retryMessages( ~[rib-private-kernel-16.0.3.jar:16.0.3]
  at com.retek.rib.j2ee.ErrorHospitalRetryEjb.doRetry( ~[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


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

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