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

SAP Knowledge Base Article - Public

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

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

  1. In Learning Administration, go to System Admin > Automatic Processes > Clean Up Background Jobs
  2. 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 , LMS Background Jobs , Problem

Product

SAP SuccessFactors Learning all versions