Hello Experts,
Auto purger functionality is not working for us.Any help please?
log says:
####<Oct 10, 2017 6:20:15 PM EDT> <Info> <WorkManager> <hcv391mmcirac04> <soa_MIserver1> <[ACTIVE] ExecuteThread: '17' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <91c2e29f-44a7-4f19-a906-fb95189c0483-00004655> <1507674015820> <BEA-002917> <Enqueued request belonging to Work Manager ESSRAWM, application ESSAPP is cancelled as the Work Manager is shutdown.>
####<Oct 10, 2017 6:20:39 PM EDT> <Warning> <RMI> <hcv391mmcirac04> <soa_MIserver1> <[ACTIVE] ExecuteThread: '34' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <1bfd4c1d-e7a0-437b-9c3e-6a8ab48e1fb6-00000cd6> <1507674039507> <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.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "DRMI_SOAINFRA.SOA", line 742
ORA-06512: at "DRMI_SOAINFRA.SOA", line 1671
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_days=>?, purge_partitioned_component=>?, ignore_state=>?, PQS=>?, DOP=>?, max_count=>?, sql_trace=>?); END;
bind => [15 parameters bound]
Query: ResultSetMappingQuery(name="soa.get_auto_purge_params" ).
javax.management.RuntimeMBeanException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "DRMI_SOAINFRA.SOA", line 742
ORA-06512: at "DRMI_SOAINFRA.SOA", line 1671
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_days=>?, purge_partitioned_component=>?, ignore_state=>?, PQS=>?, DOP=>?, max_count=>?, sql_trace=>?); END;
bind => [15 parameters bound]
Query: ResultSetMappingQuery(name="soa.get_auto_purge_params" )
Can someone suggest me how to get this auto purge enabled?
Thanks,
Rakesh