SOA Getting Failed With Error : "java.sql.SQLException: ORA-01403: no data found" (Doc ID 2706657.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

Symptoms

While trying to start SOA managed node in DR, getting below error. Database is in Snapshot READ/WRITE mode.

java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.1.v20150916-55dc7c3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "FMWPROD_SOAINFRA.SOA", line 1409
ORA-06512: at "FMWPROD_SOAINFRA.SOA", line 1790
ORA-06512: at line 1

Error Code: 1403
Call: BEGIN soa.get_auto_purge_params(job_name=>?, enabled=>?, repeat_interval=>?, soa_purge_type=>?, min_creation_period_days=>?, max_creation_period_days=>?, batch_size=>?, max_runtime=>?, retention_period=>?, retention_period_unit=>?, purge_partitioned_component=>?, ignore_state=>?, PQS=>?, DOP=>?, max_count=>?, sql_trace=>?); END;
  bind => [16 parameters bound]
Query: ResultSetMappingQuery(name="soa.get_auto_purge_params" )

Brought the SOA apps binaries via rysnc and standby Database was with Data Guard.

Cause

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