Auto Purge In SOA EM Shows "An unresolvable error has occured" (Doc ID 2384742.1)

Last updated on AUGUST 12, 2024

Applies to:

Symptoms

On : Core SOA Product Issues

From the EM ->SOA Admin->Auto purge page, the following error is seen:

An unresolvable error has occured. Please contact your administrator for more information.

The log file shows the following error below.

ERROR
-----------------------
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.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-06550: line 1, column 11:
PLS-00302: component 'GET_AUTO_PURGE_JOB_NAMES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Error Code: 6550
Call: BEGIN soa.get_auto_purge_job_names(job_name_list=>?); END;
  bind => [1 parameter bound]
Query: ResultSetMappingQuery(name="soa.get_auto_purge_job_names" ).
javax.management.RuntimeMBeanException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-06550: line 1, column 11:
PLS-00302: component 'GET_AUTO_PURGE_JOB_NAMES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Error Code: 6550
Call: BEGIN soa.get_auto_purge_job_names(job_name_list=>?); END;
  bind => [1 parameter bound]

Cause

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