SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Page 1 of 3 123 LastLast
Results 1 to 10 of 26
  1. #1
    Junior Member
    Join Date
    Aug 2007
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    this test is locked by another quality center user

    Hi all,

    one of my QTP user hits the message "this test is locked by another quality center user" "it will open is Read-only mode"
    Actually no other user is opened the test in Edit mode,
    I confirmed this via site admin user connection sessions
    Any idea why its happens, are there any setting in QTP/QC to avoid this problem

    Thanks all

  2. #2
    Moderator
    Join Date
    Mar 2000
    Location
    Orange County, CA
    Posts
    3,187
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: this test is locked by another quality center user

    you might need to look in the LOCK table for the project to see if there is an orphan entry that needs to be removed for the test.

    Get the test ID that is reporting as locked, then just query the table to see if that test is there (I lay odds it is), then all you need to do is delete that entry in the table.
    Insanity: doing the same thing over and over again and expecting different results

  3. #3
    Senior Member
    Join Date
    Aug 2007
    Location
    Raleigh, NC USA
    Posts
    100
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: this test is locked by another quality center

    select * from locks (shows all rows in the lock table)

    delete from locks where lk_session_id=<whatever one is causing your problem> (deletes the "stuck" lock allowing users to edit the test again)

  4. #4
    Super Member Jonty's Avatar
    Join Date
    Jan 2007
    Location
    India
    Posts
    1,266
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: this test is locked by another quality center user

    sometimes you may have imposed a self lock on it..?

    This happens mostly when user kill the QTP process when the script is still open(from QC).
    Cheers
    Jonty..
    -- Here to Learn and share ---

  5. #5
    Member
    Join Date
    May 2005
    Location
    Pune
    Posts
    472
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: this test is locked by another quality center user

    Yes, this seems a known issue with TD/QC.

  6. #6
    Junior Member
    Join Date
    Nov 2006
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: this test is locked by another quality center user

    Hi,
    How to reopen it? Since we are working in a comapny they will be having a server and that server we cannot access. so how come we can run the previous SQL query and delete the particular row. Any other solution for that?

    Thanks n Rgds
    Naveen

  7. #7
    Senior Member
    Join Date
    Oct 2001
    Location
    Nashville, TN, USA
    Posts
    713
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: this test is locked by another quality center user

    QC stores locks in the database table, so that's the only way to remove the lock. Whoever has access to Quality Center Site Administration can do this for you. Otherwise, contact your DBA.
    Boyd Patterson
    Patterson Consulting, LLC
    www.patterson-consulting.net

    [i]Creator of Test Design Studio - Powerful IDE for QuickTest Pro[i]

  8. #8
    Moderator
    Join Date
    Mar 2000
    Location
    Orange County, CA
    Posts
    3,187
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: this test is locked by another quality center user

    Probably opening a can of worms, but you can do it through workflow scripting as well (using the TDConnection database access functionality).

    We created a new button and some code behind it for managers at my last place of employment to perform the needed query to delete the locked user, Although we would have to do a blanket deletion for that user, having them log out and removing all reamining locks listed in the table for the specific user (supplied via an Input box).

    Still, to do this, you would need to talk to your DBA as the log in and password to the database is required to connect.
    Insanity: doing the same thing over and over again and expecting different results

  9. #9
    Senior Member
    Join Date
    Oct 2001
    Location
    Nashville, TN, USA
    Posts
    713
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: this test is locked by another quality center user

    By default, non-Admin users cannot use the 'Command' API object to execute queries on the project database unless you update the Site Admin parameters to explicitly enable this feature. I think this changed in QC 8.2, but can't remember exactly when it happened.
    Boyd Patterson
    Patterson Consulting, LLC
    www.patterson-consulting.net

    [i]Creator of Test Design Studio - Powerful IDE for QuickTest Pro[i]

  10. #10
    Moderator
    Join Date
    Mar 2000
    Location
    Orange County, CA
    Posts
    3,187
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: this test is locked by another quality center user

    hmmn - I think I might have to contact wmcvetty back there and ask exactly what we did. But thinking on it, the people who had access to it were all project admins, the only person that should have been able to handle, and know when to handle, the script being run.

    I think I need to retract my statements on this as it is a little more complex than I remember it was to implement.

    Thanks Boyd.
    Insanity: doing the same thing over and over again and expecting different results

 

 
Page 1 of 3 123 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 8.33%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 12:30 AM.

Copyright BetaSoft Inc.