Unable To View Auto-Purge Window In SOA Administration Page In Oracle EM Console (Doc ID 2285141.1)

Last updated on NOVEMBER 15, 2023

Applies to:

Symptoms

Unable to view Auto-Purge Window in SOA Administration page in Oracle EM console



ERROR
-----------------------

####<Jul 6, 2017 5:32:24 AM UTC> <Warning> <RMI> <ip-10-24-2-140.localdomain> <soa_server1> <[ACTIVE] ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <4869632a-a872-4494-8e98-36b69194dcb6-000003c2> <1499319144122> <[severity-value: 16] [rid: 0:69] [partition-id: 0] [partition-name: DOMAIN] > <BEA-080003> <A RuntimeException was generated by the RMI server: javax.management.remote.rmi.RMIConnectionImpl.getAttribute(Ljavax.management.ObjectName;Ljava.lang.String;Ljavax.security.auth.Subject;)
javax.management.RuntimeMBeanException: 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-06550: line 1, column 11:
PLS-00302: component 'GET_AUTO_PURGE_PARAMS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Error Code: 6550
Call: BEGIN soa.get_auto_purge_params(job_name=>?, enabled=>?, repeat_interval=>?, soa_purge_type=>?, min_creation_period_days=>?, max_creation_period_days=>?, batch_si
ze=>?, 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:382)
  at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260)
  at org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:521)
  at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:400)
  at oracle.integration.platform.instance.purge.PurgeInstanceManagerImpl.getAutoPurgeParams(PurgeInstanceManagerImpl.java:135)
  at oracle.fabric.management.purge.PurgeJobMXBeanImpl.getPurgeJobDetails(PurgeJobMXBeanImpl.java:176)
  at oracle.fabric.management.purge.PurgeJobMXBeanImpl.initPurgeJobDetails(PurgeJobMXBeanImpl.java:56)
  at oracle.fabric.management.purge.PurgeJobMXBeanImpl.getPurgeJobDetails(PurgeJobMXBeanImpl.java:69)
--

Caused By: 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-06550: line 1, column 11:
PLS-00302: component 'GET_AUTO_PURGE_PARAMS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
run soa purge script from Oracle\Middleware\Oracle_Home\soa\common\sql\soainfra\sql\oracle\122100\soa_purge\

Changes

Cause

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