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

Last updated on JUNE 21, 2023

Applies to:

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 / un-enroll 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

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