Venio Console: Imaging Stuck Task

The Problem

Imaging process appears to be stalled. The job completion percentage on the project job status UI is not increasing.

Resolution 

• Pause the job from the Job priority UI
• In SQL, select your project db and run the following query

• select * from tbl_tiff_shadow where ProcessingFlag  not in (2,-2)
   and jobid = <job id of that job>

• The number of rows it returns, equals the number of files that are in progress for that job. This is shown in Project Job Status UI.
• Run the following SQL query to set the status to 0 for those files.

• update tbl_tiff_Shadow set ProcessingFlag = 0 where jobid =<job id of that job>
  and [ProcessingFlag] not in (2,-2)

• Resume the job from the Job priority UI.
• If these files are desired to be marked as error, then set the ProcessingFlag to 2 and ErrorType to 4.

update tbl_tiff_shadow
set Processingflag=2, ErrorType =4 where 
BatchId = <jobid of the OCR job> and ProcessingFlag not in (2,-2)