Go Premium for a chance to win a PS4. Enter to Win


MS SQL FTS Index Population Error

Posted on 2008-06-22
Medium Priority
Last Modified: 2012-08-13
I have a MS SQL Server 2005 running a FTS over some PDFs.
On the whole its working, but the Indexing is showing an error, which i cant work out how to resolve:

Errors were encountered during full-text index population for table or indexed view '[****].[dbo].[PDFFiles]', database '****' (table or indexed view ID '133575514', database ID '6'). Please see full-text crawl logs for details.

I understand that i should look in this directory
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
and have a look in the event log.

It showed an entry like this:
Errors were encountered during full-text index population for table or indexed view '[****].[dbo].[PDFFiles]', database '****' (table or indexed view ID '133575514', database ID '6'). Please see full-text crawl logs for details.

I assume the crawl logs are the ones names like this: SQLFT....LOG

And there are a few there, with names like


In those logs are Errors like this:

2008-05-12 23:59:54.18 spid21s     The component 'AcroRdIF.dll' reported error while indexing. Component path 'C:\Program Files\Adobe\Reader 8.0\Reader\AcroRdIF.dll'.
2008-05-12 23:59:54.18 spid21s     Informational: Full-text retry pass of Full population completed for table or indexed view '[****].[dbo].[PDFFiles]' (table or indexed view ID '133575514', database ID '6'). Number of retry documents processed: 1. Number of documents failed: 0.
2008-05-12 23:59:55.18 spid21s     Error '0x80004005' occurred during full-text index population for table or indexed view '[****].[dbo].[PDFFiles]' (table or indexed view ID '133575514', database ID '6'), full-text key value 0xD491EECCA4EBD7448EBC99FFF50E26CD. Attempt will be made to reindex it.

Now if that is the problem row, is that value (0xD491EECCA4EBD7448EBC99FFF50E26CD) a GUID, and is it the Primary Key of the Row containing the PDF?

I need to know how to locate the PDF files causing the issue with the indexing, and work out why they are cauing an issue.

Question by:thetimp
  • 4
  • 4
LVL 14

Expert Comment

by:Jagdish Devaku
ID: 21843920

try the following to resolve the issue...

Download and install the Adobe PDF iFilter from Adobe, and test it using the iFiltTst on a directory with PDF files. It does index the pdf files.

I think Adobe has recently released IFilter 6.0

Then try to reindex them in SQL server...

If you still face the issue... run the following...

use master
sp_fulltext_service 'load_os_resources',1
sp_fulltext_service 'verfiy_signature', 0
reconfigure with override

let me know if u face any issues...

all the best...

Author Comment

ID: 21844091
I have the Adobe PDF Filter 6.0 installed and correctly indexing 700+ PDF's.
It is that filter (as i see it) that is raising an error with some of the PDF's.

I am trying to locate which PDF's are having the issue, and then what the issue is with them.

Thanks anyway.
LVL 14

Expert Comment

by:Jagdish Devaku
ID: 21844203
Locating the pdf's causing issues is hard to find...

check the following issues...

·         Verify that the PDF file is not damaged or password protected. The PDF iFilter cannot index PDF files that cannot be opened in Acrobat. Open the PDF file in Adobe Reader 6, Adobe Acrobat 6 Standard or Adobe Acrobat 6 Professional to verify that the file is not damaged or password protected.

·         Verify that the PDF file does not contain Security Permissions prohibiting you from searching the file.  Open the file and choose File > Document Properties > Security.  Verify that the value for "Content Copying or Extraction" is "Allowed". If it is "Not Allowed", the PDF iFilter cannot index the text.

·         Verify that the PDF file contains searchable text. You can verify if there is searchable text in the PDF file by opening it in Reader or Acrobat and selecting the text with the Text Select tool.  Or, you can open the file and using the Edit > Select All command to select text.  If neither method highlights any text, it is likely that the PDF contains a source image of text which the PDF iFilter cannot index.  You can then use a tool like Acrobats Paper Capture tool (Document > Paper Capture > Start Capture&) to convert the source image of text into searchable text which PDF iFilter can index.

·         Verify that the PDF file contains text that is properly encoded.  If the file contains searchable text, yet the Acrobat Search tool (Edit > Search) cannot find the text, then the text may not be properly encoded.  Select a word using the Text Select tool, copy it to your clipboard, and paste it into a text editor (e.g. Notepad).  If the word is not legible in the text editor, the file contains text or fonts that are not properly encoded.

·         Ensure the PDF file has a ".pdf" filename extension. Clients, such as Index Services, find the PDF iFilter by looking up the filename's extension in the Windows Registry.

·         If the original document was created in a Windows 95 application and uses TrueType fonts, either reformat the text with Type 1 fonts or use Adobe PDF Printer to recreate the PDF file. In Windows 95, PDF files generated from PostScript files containing TrueType fonts include text that is not searchable.  Both the Microsoft and Adobe PostScript® printer drivers remap TrueType fonts at PostScript generation time, which disconnects the character you see on screen from that character in the font (for more information, see http://www.adobe.com/support/techdocs/12f6e.htm ).

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 21844261
Excellent, that's what I can do once I locate which of the 700+ Pdf's the Filter is having trouble with...

The PDF's are only in the database,  so to test them I would have to extract them from the database first and some are over 200mb..

I need to know how to locate the specific PDF files causing the issue with the indexing by translating the error message...I am happy to extract and correct/ replace those.

LVL 14

Accepted Solution

Jagdish Devaku earned 2000 total points
ID: 21844754
i think the below code works...

it gives you the name of the pdf in which letter 'a' is there... all readable pdf's will be listed... out of that we need to find out the unreadable pdf's....

FROM <table_name> AS FT_TBL
    INNER JOIN FREETEXTTABLE(<table_name>, <pdf_file_column_name>,
        'a') AS KEY_TBL
        ON FT_TBL.CategoryID = KEY_TBL.[KEY];

all the best...

Author Comment

ID: 21845091
Ok now we are getting somewhere..

the 'a' didn't work but I found a common word for most projects , but it gave me some results - brilliant!. (See the attached code)
It exposed some PDFs that had been secured. (I can fix that) :-)

But it also found a PDF that is not secured and I can search with acrobat reader that contains the <common word>, and returns results inside of Acrobat...perhaps i will get the PDF re-created from the original document and see if the problem persists?. (FYI Properties say it was created with Distiller 8.1.0 , PDF version  1.4  for Acrobat 5.x)

But getting back to my question how do the logs point to those files..It seems the ID's in the logs are not too helpful?
The full-text key value in the log is not in my list of PDFFilesID's.... is it not an ID.. how does it relate?

Select cast(PDFFilesID as NvarChar(50)),PDFName from
PDFFilesID not in 
        ON FT_TBL.PDFFilesID = KEY_TBL.[KEY])
Order By cast(PDFFilesID as NvarChar(50));

Open in new window

LVL 14

Expert Comment

by:Jagdish Devaku
ID: 21852588
I think its the ID generated by full text while creating the log....

Author Comment

ID: 21852769

So there is no relation between the ID's in the Log and the table.
How disappointing.

You provided a Solution to the issue so I will considier this issue closed.


Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question