Solution to "this test is locked by another quality center user"


There are a lot of instances while working with Quality center that you might have noticed this message "this test is locked by another quality center user”
Sometimes you may have imposed a self lock on it.. J This happens mostly when the user kills the QTP process when the script is still open(from QC).

If you have forgotten the machine where you have imposed a self lock then don’t worry as here is the soln to get rid of the same:

Copy the following code and run it from the machine were qc is instantiated.

On Error Resume Next   
desc = "Please provide the network id for the user, and please make sure" &_
        "this user is logged out prior to removing locks"   
UName = InputBox(desc,"Provide network id")  
If(UName <> "") Then     
  Set cmd = TDConnection.Command      
  cmd.CommandText = "DELETE FROM Locks WHERE LK_USER = '" & UName & "'"       
  cmd.Execute      
  MsgBox "All locks for user id: " & UName & " were removed", _       
    vbNotify+vbOKOnly,"Compelted"  
Else    
  MsgBox "No locks were changed", vbNotify+vbOKOnly, "No Info" 
End If   
On Error Goto 0

Provide your userid when prompted and wallah , the magic is done J
You can now go ahead and edit your scripts.
Happy Testing!

Comments

  1. Matias18/11/11

    Hi, i tried this and didn´t work. Do QTP or QC need to be opened or something?
    Thanks, this problem has been haunting me since forever...

    ReplyDelete
  2. Aditya Kalra (Ady)18/11/11

    Make sure that qtp is closed and all instances of the qtp processes are killed and make sure you get the message ""All locks for user id: x were removed" .

    ReplyDelete
  3. Matias18/11/11

    Do i have to run this on the client PC? How does this script know how to connect to the DB?
    I finally accessed QC as an admin and ran the SQL query to delete myself, but i can´t give everybody access to the DB, so this script would simplify things.
    Thanks!!

    ReplyDelete
  4. Rahul25/11/11

    This is seen when we directly Kill the QTP process, The best way is to close QTP instance then again open it, Now test still open in Readonly mode. Now disconnect from QC and close QTP. Now when you will open QTP you can see your test in edit mode

    ReplyDelete
  5. Anonymous12/1/12

    how can i run the code?

    ReplyDelete
  6. Aditya Kalra (Ady)12/1/12

    @ Anonymous - Copy the code to a text file and save it as a .vbs file.

    ReplyDelete
  7. Aditya Kalra (Ady)11/5/12

    @Hernan - Glad that worked for you!

    ReplyDelete
  8. Aditya Kalra (Ady)26/6/12

    This comment has been removed by the author.

    ReplyDelete
  9. Priyank25/10/13

    Awesome.. it worked. :) Thanks Aditya. Thats the simple thing for which we are looking for.

    ReplyDelete
  10. Jina29/10/13

    Good job dude. code works excellent

    ReplyDelete
  11. Anonymous24/4/14

    Not working for me :(

    ReplyDelete
  12. Anonymous23/12/15

    Thanks alot man.......

    ReplyDelete
    Replies
    1. Aditya Kalra (Ady)23/12/15

      More than happy when it works for someone :)

      Delete
  13. Manish Sen Gautam10/8/16

    Hi Tried above code but it not worked for me

    i am getting this message ""All locks for user id: x were removed" when i open script it show locked .:(

    ReplyDelete
  14. Anonymous18/7/23

    palm angels
    goyard tote bag
    supreme clothing
    hermes outlet
    goyard

    ReplyDelete

Post a Comment

Popular posts from this blog

Software Testing @ Microsoft

Image
In continuation from my previous  series of posts  targeting testing in top few companies from the technology space. After  Software Testing @Facebook  and @Google  we shall now look at Microsoft: Testing@Microsoft Software Development Engineers in Test (SDETs) are usually just called Test and sometimes Software Testing. SDETs are responsible for maintaining high testing and qualityassurance standards for all Microsoft products. Software Development Engineers (SDEs) are often referred to as Software Development. SDEs write the code that drives Microsoft products and upgrades. Very few teams in Microsoft are still using SDETs to do significant amount of manual testing. Manual testing is mainly outsourced. Actually, as early as in 2004, for example, most of the manual testing of MSN Explorer was outsourced. Think about it this way: it just doesn't make sense for test manager to spend their headcount (SDETs) on something can be easily outsourced.  Until 2005, Microso
Read more

Trim / Remove spaces in Xpath?

Image
If you are wondering how you can trim the spaces in your xpath, this is how: The normalize-space function strips leading and trailing white-space from a string, replaces sequences of white-space characters by a single space, and returns the resulting string. Example : Which one is better? //td[starts-with(normalize-space(),'Text to Trim')] //td[starts-with(normalize-space(text()),' Text to Trim ')] The second option is better as it targets at the specific nodes More string functions in XPATH: Functions Description starts-with( string1 ,  string2 ) Returns true if the first string starts with the second string. contains( string1 ,  string2 ) Returns true if the first string contains the second string. substring( string offset length ) Returns a section of the string. The section starts at  offset (which is a number), and is as long as the value provided at  length. substring-before( string1 ,  string2 ) Returns the part of  string1  up unti
Read more