In Weblogic Server Console ODI_server1 JDBC Data Source Connection Pool Status Changes to "Overloaded" Causing ODI Console to Hang in ODI 12.2.1 (Doc ID 2125454.1)

Last updated on JANUARY 11, 2017

Applies to:

Oracle Data Integrator - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When logging in with ANY user that does not have the supervisor privilege the weblogic JDBC Connection pool produces a lot of sessions which in turn produce a JDBC Overload error and then the ODI Console freezes.
There are too many sessions generated for non supervisor user as compared to supervisor user.  The number of sessions increase by 4-5 with each user login, while with a supervisor user, number of sessions increase by 1.

This can be seen from WebLogic Server console:

Weblogic Server console -> odi_domain -> Servers -> ODI_Server1 -> Monitoring -> Health

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