My Oracle Support Banner

ORA-01403: No Data Found error soa.get_auto_purge_params when starting SOA Server (Doc ID 2855525.1)

Last updated on MARCH 15, 2022

Applies to:

Oracle SOA Suite - Version 12.2.1.0.0 to 12.2.1.4.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

[2022-02-08T11:35:47.889+00:00] [soa_server1] [WARNING] [] [oracle.fabric.management.purge.PurgeJobMXBeanImpl] [tid: [ACTIVE].ExecuteThread: 'xx' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xx] [ecid: xxx] [APP: soa-infra] [partition-name: DOMAIN] [tenant-name: GLOBAL] Encountered error while reading job "DELETE_INSTANCES_AUTO_JOB2". Please see logs for details.[[
java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.7.v20190604-418f1a1c56): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "XX.SOA", line 947
ORA-06512: at "XX.SOA", line 1951
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" )
at oracle.integration.platform.instance.purge.PurgeInstanceManagerImpl.getAutoPurgeParams(PurgeInstanceManagerImpl.java:198)
at oracle.fabric.management.purge.PurgeJobMXBeanImpl.getPurgeJobDetails(PurgeJobMXBeanImpl.java:214)
..
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
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.SQLException: ORA-01403: no data found
ORA-06512: at "XX.SOA", line 947
ORA-06512: at "XX.SOA", line 1951
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" )
at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:387)
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260)
at org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:526)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:400)
at oracle.integration.platform.instance.purge.PurgeInstanceManagerImpl.getAutoPurgeParams(PurgeInstanceManagerImpl.java:137)
... 88 more
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.7.v20190604-418f1a1c56): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "XX.SOA", line 947
ORA-06512: at "XX.SOA", line 1951
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" )
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:902)
..
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
... 91 more
Caused by: java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "XX.SOA", line 947
ORA-06512: at "XX.SOA", line 1951
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:266)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:87)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:966)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1280)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3719)
at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1359)
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3809)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3789)
at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4275)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1064)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:170)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:892)
... 108 more
Caused by: Error : 1403, Position : 0, Sql = BEGIN soa.get_auto_purge_params(job_name=>:1 , enabled=>:2 , repeat_interval=>:3 , soa_purge_type=>:4 , min_creation_period_days=>:5 , max_creation_period_days=>:6 , batch_size=>:7 , max_runtime=>:8 , retention_period=>:9 , retention_period_unit=>:10 , purge_partitioned_component=>:11 , ignore_state=>:12 , PQS=>:13 , DOP=>:14 , max_count=>:15 , sql_trace=>:16 ); END;, OriginalSql = 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;, Error Msg = ORA-01403: no data found
ORA-06512: at "XX.SOA", line 947
ORA-06512: at "XX.SOA", line 1951
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:514)
... 125 more

]]

 

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
References


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