How long to release sessions and locks... An explantion of WAIT_BEFORE_DISCONNECT parameter Important note - The server does not use the WAIT_BEFORE_DISCONNECT parameter , only the client. This example is based on configuration parameter settings of * WAIT_BEFORE_DISCONNECT = 60 minutes and * LOCK_TIMEOUT = 1 Hour * AUTO_LOGOUT_ON_SERVER_DISCONNECT = Y Every 5 minutes, each client machine sends a PING to the server to notify that the client is alive. Part of the data that is being sent is the interval in milliseconds from the last action that this specific client actually performed (not the ping, but an actual activity). Each client session is aware of the WAIT_BEFORE_DISCONNECT = 60 minutes value. After the WAIT_BEFORE_DISCONNET interval, 60 minutes, the client stops sending PING requests and the client session will display the message, "You have been disconnected by the server." Since the AUTO_LOGOUT_ON_SERVER_DISCONNECT parameter is implemented, your users will be logged out. Meanwhile every 15 minutes, a process runs on the server to a. locate these inactive sessions, b. clear the sessions and c. release their resources (license, locks, etc). Sessions that did not send PING request to the server in the last 10 minutes are considered as inactive. Using this example in this environment, the worst case to release the sessions and locks is 85 minutes. 15 minutes [server process poll] + 10 minutes [ping threshold of server process] + 60 minute [WAIT_BEFORE_DISCONECT value]

Have you tried the WAIT_BEFORE_DISCONNECT site parameter? (Site Administrator - Site Configuration Tab) From the Site Admin: "The time interval in minutes that the Quality Center client can be inactive before it is disconnected from the Quality Center server. Disconnecting the client enables the license to be used by another Quality Center user. By default, the value is set to 600 minutes. For performance reasons, it is recommended to set a value of at least 60 minutes. If you set the value to -1, Quality Center will not disconnect, regardless of how long the client is inactive."

What is the SQL script that you can run to unlockk user in the site admin? Please send response to pinkybabes@yahoo.com