CellProfiler/CellProfiler — Issue #228: JIRA [IMG-301] BatchProfiler: Webpage showing incorrect information for batches with mulitple runs
Author: thouis
Created: 2011-11-23 20:50:44+00:00
State: open

Example: Batch 1484 -http://seaborgium/batchprofiler/cgi-bin/ViewBatch.py?batch_id=1484
Jobs for 195601 - 196000: SELECT job.job_id, job.run_id FROM run,job WHERE batch_id = 1484 AND bstart = 196001 AND bend = 196400 AND run.run_id = job.run_id;
Currently running as job 213871 on imageweb under priority queue, but listed as unknown job 9862736 on the webpage.
I think the problem is in RunBatch.py, line 125:
select run_id,batch_id,bstart,bend,status_file_name, (select max(job_id) from job j where j.run_id = r.run_id)
max(job_id) does not get the value needed. Perhaps add a timestamp field and order by that?

Original reporter: mbray
Jira link: https://jira.broadinstitute.org/browse/IMG-301
Assignee: leek