While using Performance Center 12.53 I encountered an issue where my Test Runs were becoming stuck in ‘Pending Creating Analysis’ whenever the scenario was configured to Collate (vs Collate and Analyze). The Data Processor Queue in PC was stuck. The issue only became worse as numerous runs began to become stuck in this status, effectively creating a log-jam.
To remedy the issue the following queries were executed in Site Admin – PC LAB. This effectively removed the ‘TASKS’ so that the bad runs could be skipped. Be sure to back-up the ALM DBs / ALM Repository before running any update statements in Site Admin.
update DP_TASKS
set DP_PROGRESS_STATUS=’Finished’, DP_PROGRESS_SUBSTATUS=’Terminating’
Where DP_Progress_Status = ‘Pending’
and DP_Operation_Type = ‘Analyzing’
and QC_Project = ‘<ProjectNameHere>’
and QC_RUN_ID = ‘<QCRunIDHere>’
The statement above was used and fixed the issue. I recommend being very specific and testing it with 1 Test Run before running a mass-update on the DP_TASK table.
StressingQuality 