Venio Console: Stuck Ingestion Task

The Problem

Depending on the issue, follow the corresponding guide.

1. Ingestion appears to be stalled. The job completion percentage on the project job status UI is not increasing.
2. Processing jobs are stuck with the status “Set media status as complete if all post-processing tasks are complete is in progress."

Issue #1 Resolution

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

• select * from tbl_jb_ingestionfileexpansion where status 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 to re-queue, -2 to mark error. For example the following update query will error out those files.

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

• Resume the job from the Job priority UI

Issue #2 Resolution

• Pause the job from the Job priority UI
• Reboot the server(s) which hosts the Venio Distributed Services
• When the servers come back online, go into the console, launch the Distributed Services Manager, and run all health checkups
• If all health checkups pass, resume the job from the Job priority UI