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

Technote (troubleshooting)


Problem(Abstract)

Attempts to log in to IBM Rational Change results in a login failure with the message "WARN: User <XXX> waited to get a session for <xxxxx> ms on database <DB_name>" 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

Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Change
General Information

Software 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

Operating system(s):

AIX, Linux, Solaris, Windows

Reference #:

1605443

Modified date:

2012-07-18

Translate my page

Machine Translation

Content navigation