How to remove one defect from QC’s DB back-end?
Question ID: 104878
0
0

Hi, I need some help in removing a specific defect – we can live without it. One defect is freezing the entire Quality Center. We can open all the defects but when we go to this defect QC freezes.

Marked as spam
Posted by (Questions: 193, Answers: 14)
Asked on March 4, 2013 2:39 pm
34 views
Answers (1)
0
Private answer

If you know the ID of the Defect, it is easy to remove it from the database from Site Admin.

0) ensure you have a good, recent backup of the project DB and Repository

1) In Site Admin, select the Project

2) expand the project (plus sign at left of the name) to see the tables

3) Click on the ''BUG'' table

4) in the box just above the results table listing all bugs, you should see this SQL statement: SELECT * FROM BUG

5) Replace that with this SQL code (I am using ID=31 for an example, replace with your ID)
SELECT * FROM BUG WHERE BG_BUG_ID=31

That should select the single record so you can confirm that it is the right one.

6) Change the SQL statement to this:

DELETE FROM BUG WHERE BG_BUG_ID=31

[it should return ''empty table''

7) Try

SELECT * FROM BUG WHERE BG_BUG_ID=31

or

SELECT * FROM BUG

to confirm record is gone.

8) Users will need to get out and back into project or refresh Defects module to see change.

Marked as spam
Posted by (Questions: 4, Answers: 509)
Answered on March 4, 2013 2:41 pm
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top