SAP Knowledge Base Article - Public

2668332 - Clean up Background Job APM - java.sql.SQLException: The ResultSet is closed

Symptom

  • Clean up Background Job APM is failing. Error message below:

java.sql.SQLException: The ResultSet is closed: The ResultSet 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:233)
at com.sun.proxy.$Proxy133.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.$Proxy137.next(Unknown Source)
at com.plateau.common.db.api.QueryResults.next(QueryResults.java:515)
at com.plateausystems.elms.framework.jobscheduling.impl.CleanupBackgroundJobsApmJob.execute(CleanupBackgroundJobsApmJob.java:86)
at com.plateau.common.jobscheduling.impl.simple.SimpleJobRunnable.run(SimpleJobRunnable.java:96)
at com.plateau.foundation.jobscheduling.TenantAwareJobRunnable.run(TenantAwareJobRunnable.java)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622)
at java.lang.Thread.run(Thread.java:807)

Environment

  • Learning Management System

Cause

  •  Per Engineering's response, the above issue happens when resultset goes null and gets closed.

Resolution

  • This issue is fixed on b1808 release.
  • A proposed workaround by Engineering is to disable this job until b1808 release is live.

See Also

  • In case you require further information about what this Job does, please refer to this link.

Keywords

LRN-34818, LRN-41197, Clean up Background Job, automatic process, The ResultSet is closed. , KBA , LOD-SF-LMS-BCJ , LMS Background Jobs , Bug Filed

Product

SAP SuccessFactors HCM Core 1805