My Oracle Support Banner

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

Last updated on SEPTEMBER 03, 2020

Applies to:

Oracle SOA Suite - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

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

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
Symptoms
Cause
Solution


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