Page Comparison

...

Diagnosis: This is usually caused by a flowcell with 2 runs valid run (uncanceled), one of which should have been cancelled. Run the query below to determine the trouble flowcell:

SELECT r.flowcell_barcode, count(DISTINCT r.run_name)
FROM slxre2_organic_run r
WHERE
r.is_cancelled = 0
AND r.run_type <> 'UNDECIDED'
AND  r.run_date >= <SOME DATE>
GROUP BY r.flowcell_barcode
HAVING count(DISTINCT r.run_name)>1

Remedy: There is an agent (OrganicRun) that reviews if a flowcell has 2 valid runs, and emails the Sequencing team to clear the bad run from their dashboard. Designation ETL will recover as soon as the run is cleared. 

...