Venio Console: Stuck OCR Task

The problem 

OCR is stuck. The job completion percentage on the project job status 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_OCR_shadow where ProcessingFlag  not in (2,-2)
   and Batchid = <job id of the ocr job>

• The count of rows it returns corresponds to the number of files currently in progress for the respective job. This information is displayed in the Project Job Status UI. It's important to note that statuses other than 2 and -2 include 0, 1, and -1. A status of 1 indicates that the files are currently in progress, -1 indicates they have been postponed, and 0 signifies files that have not yet been picked up.
• Run the following SQL query to set the status to 0 for those files

• update tbl_OCR_Shadow set ProcessingFlag = 0 where Batchid=<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_OCR_shadow
 set Processingflag=2, ErrorType =4 where 
 BatchId = <jobid of the OCR job> and ProcessingFlag not in (2,-2)