| || |
QC creates duplicate Defect ID
I have this weird issue which I am trying to seek help from HP but have no hope.
I have a defect created in Defects tab under Quality Center and linked with test and has history for this defect.When I change the status from "Fixed" to "Open",it somehow created a duplicate defect with same values.
Did anyone come across these kind of issues before? Please help.
Re: QC creates duplicate Defect ID
Can any provide me how can i delete duplicate row in Quality Center 9.2 MS SQL SERVER Database.
I use following SQL-QWERY to found duplicate
SELECT RP_ID, COUNT(RP_ID) AS number_of
GROUP BY RP_ID
HAVING (COUNT(RP_ID) = 2)
This query identify the duplicate
WHERE (RP_ID = 19175)
Please, Who can provide me with SQL query to delete duplicate from td.REPOSITORY