IBM Support

Login results in "WARN: User <XXX> waited to get a session for <xxxxx> ms on database <DB_name>" message reported in the Rational Change event.log

Troubleshooting


Problem

Attempts to log in to IBM Rational Change results in a login failure with the message "WARN: User waited to get a session for ms on database " reported in the Rational Change event.log

Symptom

Login to Change fails with the following error displayed in the Rational Change event.log.

*************************


2012/06/20 09:40:41  WARN: User <XXX> waited to get a session for <xxxxx> ms on database <DB_name>.
2012/06/20 09:41:46  Queuing parallel backend requests from user <USER_ID>
2012/06/20 09:52:32  Queuing parallel backend requests from user <USER_ID>
2012/06/20 10:04:33  Queuing parallel backend requests from user <USER_ID>
2012/06/20 10:04:46  Accent command cs_cmds:CSapi_cr_cvqueryinfo for user "<USER_ID>" exceeded threshold of 20000 ms: 23147 ms.
*************************

Cause

By default only one session is assigned per user. Large queries can cause a bottleneck and this chokes when user are running huge quires.

Resolving The Problem

Change the application to allocate more than one session by adding the below tag to pt.cfg file.

Note: This change will help to avoid the requests getting queued up. The default value is 1.

  1. Edit the pt.cfg file located at CS_HOME/jetty/webapps/<context>/WEB-INF/wsconfig/pt.cfg

  2. Add the following line to pt.cfg file under the SYSTEM VARIABLES SECTION

    ************************
    [CCM_SYSTEM][MAX_USER_SESSIONS_COUNT]3[/MAX_USER_SESSIONS_COUNT]/CCM_SYSTEM]
    ************************

  3. Restart the IBM Rational Change server

[{"Product":{"code":"SSYQQ2","label":"Rational Change"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"General Information","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"5.1;5.2;5.2.0.1;5.2.0.2;5.2.0.3;5.2.0.4;5.2.0.5;5.2.0.6;5.2.0.7;5.3;5.3.0.1;5.3.0.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
16 June 2018

UID

swg21605443

Page Feedback