My Oracle Support Banner

Migration App REST API Causes DB Connection Leakage (Doc ID 2520418.1)

Last updated on FEBRUARY 04, 2020

Applies to:

Siebel CRM - Version 19.1 and later
Information in this document applies to any platform.

Symptoms

On : 19.1 version, System Admin

ACTUAL BEHAVIOR
---------------
Migration App REST API causes DB connection leak

Every new request to the Migration App REST API creates a new DB connection.
These connections are never dropped until AI Tomcat is shut down.
After a certain amount of time, the DB will not accept new connections anymore and thus the system becomes unstable.

The number of DB connections is ever increasing with every request. It correlates with these log entries in the migration.log:

"Migration - com.siebel.migration.server.MigrationDataComp:initConnection Entering in initConnection Function"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Start AI tomcat
2. Using curl, for example, execute the following GET command:

3) At the database server verify the increasing number of connections associated with "JDBC Thin Client", see the sample below:

SQL> SELECT COUNT(*), PROGRAM, USERNAME FROM V$SESSION WHERE USERNAME IS NOT NULL GROUP BY PROGRAM, USERNAME;

 COUNT(*) PROGRAM                                                         USERNAME
  ---------- ------------------------------------------------------- ------------------------------
             4 siebmtsh.exe                                                     SADMIN
             6 siebprocmw.exe                                                 SADMIN
             1 siebmtshmw.exe                                                GUESTCST
        193 JDBC Thin Client                                              SADMIN
             1 sqlplus.exe                                                        SYSTEM
             4 siebmtshmw.exe                                                SADMIN

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
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.