2610918 - Clean up Background Jobs APM failure - java.sql.SQLException: The connection is closed

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)

SuccessFactors LMS

1. In Learning Administration, go to System Admin > Automatic Processes > Clean Up Background Jobs
2. Click "View Errors"

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.

Schedule the APM to run at another time, during the week, or in a daily schedule.

automatic process, background job, clean up, connection closed , KBA , LOD-SF-LMS-BCJ , Assign (bulk), Add/ Delete Sub/ Cur, Revise, Import , Problem