Symptom
The Clean up Background Jobs APM is failing and you can see the following error:
java.sql.SQLException: The connection is closed: The connection is closed
at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:473)
at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:457)
at oracle.ucp.jdbc.proxy.ResultSetProxyFactory.invoke(ResultSetProxyFactory.java:200)
at com.sun.proxy.$Proxy518.next(Unknown Source)
at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.plateau.common.core.api.InterruptibleInvocationHandler.invoke(InterruptibleInvocationHandler.java:71)
at com.plateau.common.db.api.InterruptibleJdbcObjectProxyFactory$InterruptibleJdbcObjectProxy.invoke(InterruptibleJdbcObjectProxyFactory.java:155)
at com.sun.proxy.$Proxy522.next(Unknown Source)
at com.plateau.common.db.api.QueryResults.next(QueryResults.java:513)
at com.plateausystems.elms.framework.jobscheduling.impl.CleanupBackgroundJobsApmJob.execute(CleanupBackgroundJobsApmJob.java:86)
at com.plateau.common.jobscheduling.impl.simple.SimpleJobRunnable.run(SimpleJobRunnable.java:95)
at com.plateau.foundation.jobscheduling.TenantAwareJobRunnable.run(TenantAwareJobRunnable.java)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:807)
Environment
SuccessFactors LMS
Reproducing the Issue
- In Learning Administration, go to System Admin > Automatic Processes > Clean Up Background Jobs
- Click "View Errors"
Cause
A possible cause for this error is that the APM is scheduled to run during the weekend, at the same time we apply our system patches. This will cause the APM to fail.
Resolution
Schedule the APM to run at another time, during the week, or in a daily schedule.
Keywords
automatic process, background job, clean up, connection closed , KBA , LOD-SF-LMS-BCJ , Assign (bulk), Add/ Delete Sub/ Cur, Revise, Import , Problem