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 JULY 13, 2018
Applies to:Oracle Data Integrator - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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
In Weblogic Server console -> odi_domain -> Servers -> ODI_Server1 -> Monitoring -> JDBC
By default in Weblogic Server console -> odi_domain -> Services -> Data Sources -> odiMasterRepository -> Connection Pool -> Maximum Capacity = 15
By increasing this number this issue may pass unnoticed. And by restarting the managed server odi_server1 the sessions are cleared.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!