My Oracle Support Banner

Oracle Learning Management (OLM) Sessions Are Not Getting Released In The Database (Doc ID 2550605.1)

Last updated on OCTOBER 14, 2020

Applies to:

Oracle Learning Management - Version 12.2 HRMS RUP10 and later
Information in this document applies to any platform.

Symptoms

On : 12.2 HRMS RUP10 version, Catalog Admin

OLM Sessions are not Getting Released in the Database.

Issue was originally reported in <Bug 28440687>.

The issue started happening again when OLM sessions were created in Production.  Even when the users have logged out of the Applications, some sessions are not getting released in the database.

OLM is leaving hundreds of Inactive sessions in the database causing it to crash when the total process reached the "process" par.

This issue is happening on all of customer's  Scorm 1.2 online content.


SETUP
==============
Application 12.2.6


RUP Level = 24007222 R12.HR_PF.C.Delta.10


In Production both oacore and content server Heap sizes are 4GB.

Gather Schema Stats was ran today and is ran every week on Production and Test.

Checked the Database> RDBMS Alert log- No error till it crashed for reaching "process" init.ora param of 2500

Customer set Database processes from 3500 to 6000.

Customer has WLS Content Server with 4GB Heapsize.







ERROR from Weblogic Content Server:
=====================================
#### <olm_ManagedServer> <[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <[severity-value: 8] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <[ServletContext@438117117[app:contentstorage module:contentstorage path:null spec-version:3.1]] Servlet failed with an IOException.
java.io.IOException: Connection reset by peer
at sun.nio.ch.FileDispatcherImpl.write0(Native Method)
at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47)
at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:93)
at sun.nio.ch.IOUtil.write(IOUtil.java:65)
at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:471)
at weblogic.socket.NIOOutputStream$SingleBufferWrite.writeTo(NIOOutputStream.java:841)
at weblogic.socket.NIOOutputStream$BlockingWriter.flush(NIOOutputStream.java:455)
at weblogic.socket.NIOOutputStream$BlockingWriter.write(NIOOutputStream.java:334)
at weblogic.socket.NIOOutputStream.write(NIOOutputStream.java:220)
at weblogic.socket.JSSEFilterImpl.writeToNetwork(JSSEFilterImpl.java:817)
at weblogic.socket.JSSEFilterImpl.wrapAndWrite(JSSEFilterImpl.java:777)
at weblogic.socket.JSSEFilterImpl.write(JSSEFilterImpl.java:491)
at weblogic.socket.JSSESocket$JSSEOutputStream.write(JSSESocket.java:148)
at weblogic.servlet.internal.ChunkOutput.writeChunkNoTransfer(ChunkOutput.java:649)
at weblogic.servlet.internal.ChunkOutput.writeChunks(ChunkOutput.java:588)
at weblogic.servlet.internal.ChunkOutput.flush(ChunkOutput.java:471)
at weblogic.servlet.internal.ChunkOutput$3.checkForFlush(ChunkOutput.java:757)
at weblogic.servlet.internal.ChunkOutput.writeStream(ChunkOutput.java:520)
at weblogic.servlet.internal.ChunkOutputWrapper.writeStream(ChunkOutputWrapper.java:212)
at weblogic.servlet.internal.ServletOutputStreamImpl.writeStream(ServletOutputStreamImpl.java:640)
at weblogic.servlet.internal.ServletOutputStreamImpl.writeStream(ServletOutputStreamImpl.java:628)
at weblogic.servlet.FileServlet.sendFileUsingOutputStream(FileServlet.java:460)
at weblogic.servlet.FileServlet.sendFile(FileServlet.java:431)
at weblogic.servlet.FileServlet.doGetHeadPost(FileServlet.java:236)
at weblogic.servlet.FileServlet.service(FileServlet.java:161)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:247)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3679)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3649)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326)
at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2433)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2281)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2259)
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1691)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1651)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:270)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:640)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:406)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
>





Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.