QC Unique problem-solution

    0
    149
    Spread the love
    • 1
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
      1
      Share

    This problem is taken from Suresh Kumar’s forum….
    http://forums.sureshkumar.net/testing-tools-qa/44269-quality-center-doubt.html

    I find this is extremly usefull for all QC users…

    let me share the problem and solution..

    Problem:
    can anyone tell how to change the REQ ID’s in QC?
    I m having a problem with REQ ID’s when I delete any requirement(Lets assume REQ ID:2), that number is not coming again its starting from REQ ID:3 and REQ ID:2 is completely gone. I m unable to use the number again

    How to overcome this problem??

    Solution:

    You need to reset the sequence value on the Sequences Table for the parameter REQ.

    Go to the Site administrator and select the project (that needs Requirement id to reset to 0).Select the Sequences table and paste the below query on the right side of the screen and click on the Execute SQL

    Update Sequences set SQ_SEQ_VALUE = 0 where SQ_SEQ_NAME = ‘REQ’

    Note: make sure you select the correct project on the Site Project tab on your Site administrator to do the update

    This is applicable for defects and test tables as well.

    Don't miss out!
    Subscribe To Newsletter

    Receive top technical news, lesson ideas, travel tips and more!

    Invalid email address
    Give it a try. You can unsubscribe at any time.

    Spread the love
    • 1
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
      1
      Share

    LEAVE A REPLY

    Please enter your comment!
    Please enter your name here