How to identify TIBCO Data Virtualization users opening a lot of sessions, resulting in messages that the connection limit has been exceeded?
book
Article ID: KB0074619
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
7.0 and higher
Description
How to identify TIBCO Data Virtualization users opening a lot of sessions, resulting in messages that the connection limit has been exceeded?
Resolution
By default, TDV is configured to allow 100 sessions. If the number of client sessions exceeds this number, any new client that attempts to open a connection will receive an error of the type:
----------------- The connection limit of 100 has been exceeded -----------------
The error may be resolved by opening TDV Studio and increasing the value of Administration>>Configuration>>Server>>Client Drivers>>Session>>Maximum Session to a value higher than 100.
It may also be prudent to find out which users are opening a lot of sessions. To obtain this information, the following query may be run in TIBCO Data Virtualization Studio Scratchpad:
----------------- SELECT * from /services/databases/system/SYS_SESSIONS where STATUS != 'CLOSED' order by OWNER -----------------
This output of the query will:
list the users who have opened sessions
provide detailed information on on each session
As an example, the screenshot below shows that a user named yogesh_gupta has 3 open JDBC sessions.
The LOGIN_TIME field shows the time at which each session was started.
Issue/Introduction
How to identify TIBCO Data Virtualization users opening a lot of sessions, resulting in messages that the connection limit has been exceeded?