Auto Purge In SOA EM Shows "An unresolvable error has occured"

(Doc ID 2384742.1)

Last updated on APRIL 17, 2018

Applies to:

SOA Suite Cloud Service - Version N/A to N/A
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms