Venio Console: Indexing Stuck on few Files

Problem

Indexing is stuck on few files. Generic log has messages like 'Full text location not found'.

Run the following query on the project database:

select top 1000* from tbl_lg_GenericLog 
where module ='indexing' and logtype<>'information' order by 1 desc

If you  see error message like 'Fulltext location not found', check the corresponding fileid field.

For example let us say we have 2 such files with fileid 1 and 2.

Now check the isnotext flag of tbl_ex_fileinfo table for these 2 files

select isnotext, * from tbl_ex_FileInfo where fileid in (1,2)

If isnotext flag is 0 then it means that it should have full text file location.

Now check the tbl_ex_fulltextfilelocation table for those files.

select * from tbl_ex_FulltextFileLocation where fileid in (1,2)

If it does not return any row, would mean, the fulltext files were not created.

Resolution

Search these files from the console UI and send these files to images. Once the image job is complete, send these files for OCR. This will resolve the issue.