05-08-2008 09:19 AM
05-08-2008 09:32 AM
Removing the lock from the locks table is the best method. Also, the lock may drop on its own when the Lock_Timeout is reached. Restarting the services would also remove the lock.
05-08-2008 09:48 AM
05-12-2008 03:12 AM
Please keep in mind to return the Lock_Timeout back to the default value or some reasonable value.
This value should not be small because then you can get the trouble with editing of records with a lot of users.
05-16-2011 10:56 PM
Go to Attachments -> Take a Test Snap Shot of other window -> Now try to change status. It should work.
05-17-2011 07:12 AM
If you have version control on, and the particular item s checkout, you can undo-checkout (right click - versions - undo checkout)
Thsi way you can release the object but the changes made by the previous person (who had teh lock) will be lost
09-26-2011 01:09 AM
I am also facing the same problem. Only thing i would like to confirm here is that when locks table is flushed, does it flush only idle users or all the users from that QC Instance.
Is there any way to kick out all the idle users after a specific time.
09-26-2011 06:39 AM
The Locks table is project specific. So a complete "delete from locks" command will only release the locks from that single project and not all projects. You can also qualify the command like 'delet from locks where user_name = 'abc'' in order to delete a specific lock without releaseing other locks.
The Idle Users issue is a different issue. The Site Config parameter Wait_Before_Disconnect handles this. When a user session is idle past the amount of time specified in this parameter, the user's session will be automatically disconnected. It is not recommended to set this value less than 10 min. You can also cancel user sessions using the Site Connects tab within Site Administration.
05-15-2012 12:04 PM
Hi sreekanth what about locks in run or test modules how can we delete them other than writing sql query ..
can you explain in brief about attachements , snap shot method i didn't get that exactly
Appriciate your help