How can I reset the Bug counter in ALM/ QC?

  • Questions
  • How can I reset the Bug counter in ALM/ QC?
Question ID: 105098

I was wondering how I could reset the Bug counter within our ALM/QC applications. We were using it for testing, now as testing is completed we would like to delete everything used in testing, reset the counters, and start from new. Is this possible?

Thanks for your help.

Marked as spam
Posted by (Questions: 379, Answers: 35)
Asked on August 8, 2013 12:12 pm
Answers (2)
Private answer

Hi HomerJ,
If you wish to reset any of the counters (defects, release, cycle), it is recommended to make sure that the previous entities are removed (which I see you plan ion doing) to insure that the counters don't over write others already in use and cause issues. Then you would need to perform the following (I would make sure that you have a backup in place before performing this and it is done at your own risk):

Resetting the defect counter
1. Bring up the Project Administration Utility (Site Administrator).
2. Highlight the desired database to modify.
3. Expand the database to view all the tables by either double-clicking on the database or by clicking on the ''+'' next to the connected database.
4. Click on the Sequences table.
5. Run the following SQL.
NOTE : SQ_SEQ_NAME can be Release_cycles for the Cycle ID etc...
6. Click button.
7. Logout of Quality Center, log back in again and check the value.

I hope that helps,

Marked as spam
Posted by (Questions: 0, Answers: 770)
Answered on August 8, 2013 12:19 pm
Thanks, that is exactly what I was looking for.
( at August 8, 2013 12:21 pm)
Private answer


Please delete the defects and try adding the new defect. If you dont, then the error message 'failed to post bug' will be thrown.

to verify whether the SQL code has worked fine, run 'Select * from SEQUENCES' and check the value of Bug field. If it shows 0 then the count has been reset.

Marked as spam
Posted by (Questions: 0, Answers: 1)
Answered on February 21, 2014 12:40 pm