Venio Console: Stuck Export Task

The Problem

Export 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

If the export in stuck on exporting the natives then

• select * from tbl_ep_nativedetails where status  not in (2,-2)
   and export = <export 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_ep_nativedetails set [status] = 0 where exportid =<export id of that job>
  and [status] not in (2,-2)

• Resume the job from the Job priority UI.

If the export is stuck on exporting the pdfs then

• select * from tbl_ep_pdfdetails where status  not in (2,-2)
   and exportid = <export 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_ep_pdfdetails set [status] = 0 where exportid =<export id of that job>
  and [status] not in (2,-2)

• Resume the job from the Job priority UI.