Oracle Learning Management Running Out Of Data Source Connections When Using Oracle Learning Management (OLM). (Doc ID 2182945.1)

Last updated on OCTOBER 20, 2016

Applies to:

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

Symptoms

On : 12.2 HRMS RUP6 version, Content Admin



ACTUAL BEHAVIOR
---------------


Database running out of connections when using Oracle Learning Management (OLM).


When using OLM, the database runs out of connections (session count climbs drastically) and the WebLogic console shows that it's done by the oacore_server Manager Servers.


Customer is experiencing the datasource connection problem only with Oracle Learning Management (OLM).
The quickest way to reproduce the problem is to enroll / unenroll from courses, but any action in OLM seems to cause the problem.

No significant datasource connection increases have been observed in in Production environment when business started defining the course catalogue.

The problem seems to be related to the "My Current Enrollments" section of the "My Learning Home Page" screen.
Every time the learner  navigates to this screen, and/or scroll down the "My Current Enrollment" section, the datasource connections increase quite a bit, 10 to 15 connections at a time.  It is from this section that they enroll/un-enroll and play courses.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
The quickest way to reproduce the problem is to enroll / unenroll from courses, but any action in OLM seems to cause the problem.



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms