| Groups | Blog | Home |
sql server full text search : More PDF IFilter problems
Hi all,
I'm having some frustrating issues with the PDF IFilter and making it work. I've read the other posts here, and still haven't been able to figure this out. I am running SQL Server 2005 Standard 32 bit edition on Windows Server 2003 Standard Edition. I performed the following: 1 - Installed the PDF IFilter v 6.0 2 - Ran EXEC sp_fulltext_service 'load_os_resources', 1 3 - Stopped and restarted the SQL Server service 4 - Ran sys.fulltext_document_types and verified that .pdf was indeed a valid document type 5 - Built a new full-text catalog and added my table with PDF & other files (stored as image data type) to the catalog 6 - Fully populated the FT index 7 - Ran my CONTAINS query against that table. I'm able to return results against Office files, but nothing for PDF files. So, I'm not sure what I should do at this point. I even tried restarting the server itself. Somebody (Hilary Cotter?) mentioned that it might be possible to look at gatherer logs somewhere, but I'm not clear where those would be. I would appreciate any further suggestions. Thanks, Jim
So, I have found the log, and am receiving the following error information:
2007-09-27 14:40:23.13 spid21s Informational: Full-text Full population initialized for table or indexed view '[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762', database ID '12'). Population sub-tasks: 1. 2007-09-27 14:40:37.24 spid21s Error '0x80043651: msftesql should reprocess this document in an isolated fashion to confirm the error.' occurred during full-text index population for table or indexed view '[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762', database ID '12'), full-text key value 0x00000001. Attempt will be made to reindex it. 2007-09-27 14:40:37.24 spid21s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. 2007-09-27 14:40:37.24 spid21s Warning: No appropriate filter for embedded object was found during full-text index population for table or indexed view '[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762', database ID '12'), full-text key value 0x00000002. Some embedded objects in the row could not be indexed. 2007-09-27 14:40:37.24 spid21s Informational: Full-text Full population completed for table or indexed view '[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762', database ID '12'). Number of documents processed: 2. Number of documents failed: 0. Number of documents need retry: 1. Clearly, it doesn't like my IFilter. Any ideas how I can make SQL recognize this? Thanks, Jim [quoted text, click to view] "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message news:%23o1jMiUAIHA.3940@TK2MSFTNGP05.phx.gbl... > Hi all, > > I'm having some frustrating issues with the PDF IFilter and making it > work. I've read the other posts here, and still haven't been able to > figure this out. I am running SQL Server 2005 Standard 32 bit edition on > Windows Server 2003 Standard Edition. I performed the following: > > 1 - Installed the PDF IFilter v 6.0 > 2 - Ran EXEC sp_fulltext_service 'load_os_resources', 1 > 3 - Stopped and restarted the SQL Server service > 4 - Ran sys.fulltext_document_types and verified that .pdf was indeed a > valid document type > 5 - Built a new full-text catalog and added my table with PDF & other > files (stored as image data type) to the catalog > 6 - Fully populated the FT index > 7 - Ran my CONTAINS query against that table. I'm able to return results > against Office files, but nothing for PDF files. > > So, I'm not sure what I should do at this point. I even tried restarting > the server itself. Somebody (Hilary Cotter?) mentioned that it might be > possible to look at gatherer logs somewhere, but I'm not clear where those > would be. I would appreciate any further suggestions. > > Thanks, Jim >
OK, this gets stranger by the minute. I am able to successfully index Excel
files, but I am not able to index Word documents! I get this message in my logs. 2007-09-27 15:41:04.59 spid19s Error '0x8004170c: The document format is not recognized by the filter.' occurred during full-text index population for table or indexed view '[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762', database ID '12'), full-text key value 0x00000003. Attempt will be made to reindex it. 2007-09-27 15:41:04.59 spid19s The component 'offfilt.dll' reported error while indexing. Component path 'C:\WINDOWS\system32\offfilt.dll'. Please, I will lose all my hair soon, any ideas are welcome. [quoted text, click to view] "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message news:eyhiy9UAIHA.1168@TK2MSFTNGP02.phx.gbl... > So, I have found the log, and am receiving the following error > information: > > 2007-09-27 14:40:23.13 spid21s Informational: Full-text Full > population initialized for table or indexed view > '[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762', > database ID '12'). Population sub-tasks: 1. > 2007-09-27 14:40:37.24 spid21s Error '0x80043651: msftesql should > reprocess this document in an isolated fashion to confirm the error.' > occurred during full-text index population for table or indexed view > '[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762', > database ID '12'), full-text key value 0x00000001. Attempt will be made to > reindex it. > 2007-09-27 14:40:37.24 spid21s The component 'MSFTE.DLL' reported > error while indexing. Component path 'C:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. > 2007-09-27 14:40:37.24 spid21s Warning: No appropriate filter for > embedded object was found during full-text index population for table or > indexed view '[RMSTest].[Template].[Content]' (table or indexed view ID > '2142018762', database ID '12'), full-text key value 0x00000002. Some > embedded objects in the row could not be indexed. > 2007-09-27 14:40:37.24 spid21s Informational: Full-text Full > population completed for table or indexed view > '[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762', > database ID '12'). Number of documents processed: 2. Number of documents > failed: 0. Number of documents need retry: 1. > > Clearly, it doesn't like my IFilter. Any ideas how I can make SQL > recognize this? > > Thanks, Jim > > "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message > news:%23o1jMiUAIHA.3940@TK2MSFTNGP05.phx.gbl... >> Hi all, >> >> I'm having some frustrating issues with the PDF IFilter and making it >> work. I've read the other posts here, and still haven't been able to >> figure this out. I am running SQL Server 2005 Standard 32 bit edition on >> Windows Server 2003 Standard Edition. I performed the following: >> >> 1 - Installed the PDF IFilter v 6.0 >> 2 - Ran EXEC sp_fulltext_service 'load_os_resources', 1 >> 3 - Stopped and restarted the SQL Server service >> 4 - Ran sys.fulltext_document_types and verified that .pdf was indeed a >> valid document type >> 5 - Built a new full-text catalog and added my table with PDF & other >> files (stored as image data type) to the catalog >> 6 - Fully populated the FT index >> 7 - Ran my CONTAINS query against that table. I'm able to return results >> against Office files, but nothing for PDF files. >> >> So, I'm not sure what I should do at this point. I even tried restarting >> the server itself. Somebody (Hilary Cotter?) mentioned that it might be >> possible to look at gatherer logs somewhere, but I'm not clear where >> those would be. I would appreciate any further suggestions. >> >> Thanks, Jim >> > >
Sorry, scratch that last one, the DOC file I was looking at was corrupted.
PDF problem remains, however... Thanks! [quoted text, click to view] "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message news:O1Tn0fVAIHA.5184@TK2MSFTNGP02.phx.gbl... > OK, this gets stranger by the minute. I am able to successfully index > Excel files, but I am not able to index Word documents! I get this > message in my logs. > > 2007-09-27 15:41:04.59 spid19s Error '0x8004170c: The document format > is not recognized by the filter.' occurred during full-text index > population for table or indexed view '[RMSTest].[Template].[Content]' > (table or indexed view ID '2142018762', database ID '12'), full-text key > value 0x00000003. Attempt will be made to reindex it. > 2007-09-27 15:41:04.59 spid19s The component 'offfilt.dll' reported > error while indexing. Component path 'C:\WINDOWS\system32\offfilt.dll'. > > Please, I will lose all my hair soon, any ideas are welcome. > > > > "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message > news:eyhiy9UAIHA.1168@TK2MSFTNGP02.phx.gbl... >> So, I have found the log, and am receiving the following error >> information: >> >> 2007-09-27 14:40:23.13 spid21s Informational: Full-text Full >> population initialized for table or indexed view >> '[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762', >> database ID '12'). Population sub-tasks: 1. >> 2007-09-27 14:40:37.24 spid21s Error '0x80043651: msftesql should >> reprocess this document in an isolated fashion to confirm the error.' >> occurred during full-text index population for table or indexed view >> '[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762', >> database ID '12'), full-text key value 0x00000001. Attempt will be made >> to reindex it. >> 2007-09-27 14:40:37.24 spid21s The component 'MSFTE.DLL' reported >> error while indexing. Component path 'C:\Program Files\Microsoft SQL >> Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. >> 2007-09-27 14:40:37.24 spid21s Warning: No appropriate filter for >> embedded object was found during full-text index population for table or >> indexed view '[RMSTest].[Template].[Content]' (table or indexed view ID >> '2142018762', database ID '12'), full-text key value 0x00000002. Some >> embedded objects in the row could not be indexed. >> 2007-09-27 14:40:37.24 spid21s Informational: Full-text Full >> population completed for table or indexed view >> '[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762', >> database ID '12'). Number of documents processed: 2. Number of documents >> failed: 0. Number of documents need retry: 1. >> >> Clearly, it doesn't like my IFilter. Any ideas how I can make SQL >> recognize this? >> >> Thanks, Jim >> >> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >> news:%23o1jMiUAIHA.3940@TK2MSFTNGP05.phx.gbl... >>> Hi all, >>> >>> I'm having some frustrating issues with the PDF IFilter and making it >>> work. I've read the other posts here, and still haven't been able to >>> figure this out. I am running SQL Server 2005 Standard 32 bit edition >>> on Windows Server 2003 Standard Edition. I performed the following: >>> >>> 1 - Installed the PDF IFilter v 6.0 >>> 2 - Ran EXEC sp_fulltext_service 'load_os_resources', 1 >>> 3 - Stopped and restarted the SQL Server service >>> 4 - Ran sys.fulltext_document_types and verified that .pdf was indeed a >>> valid document type >>> 5 - Built a new full-text catalog and added my table with PDF & other >>> files (stored as image data type) to the catalog >>> 6 - Fully populated the FT index >>> 7 - Ran my CONTAINS query against that table. I'm able to return >>> results against Office files, but nothing for PDF files. >>> >>> So, I'm not sure what I should do at this point. I even tried >>> restarting the server itself. Somebody (Hilary Cotter?) mentioned that >>> it might be possible to look at gatherer logs somewhere, but I'm not >>> clear where those would be. I would appreciate any further suggestions. >>> >>> Thanks, Jim >>> >> >> > >
can you post a problem pdf here? Sometime PDFs only contain images and no
text. The iFilter can only understand the text. Also what version of the PDF is it? -- RelevantNoise.com - dedicated to mining blogs for business intelligence. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message news:%23eQ$P6VAIHA.3848@TK2MSFTNGP05.phx.gbl... > Sorry, scratch that last one, the DOC file I was looking at was corrupted. > PDF problem remains, however... > Thanks! > "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message > news:O1Tn0fVAIHA.5184@TK2MSFTNGP02.phx.gbl... >> OK, this gets stranger by the minute. I am able to successfully index >> Excel files, but I am not able to index Word documents! I get this >> message in my logs. >> >> 2007-09-27 15:41:04.59 spid19s Error '0x8004170c: The document format >> is not recognized by the filter.' occurred during full-text index >> population for table or indexed view '[RMSTest].[Template].[Content]' >> (table or indexed view ID '2142018762', database ID '12'), full-text key >> value 0x00000003. Attempt will be made to reindex it. >> 2007-09-27 15:41:04.59 spid19s The component 'offfilt.dll' reported >> error while indexing. Component path 'C:\WINDOWS\system32\offfilt.dll'. >> >> Please, I will lose all my hair soon, any ideas are welcome. >> >> >> >> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >> news:eyhiy9UAIHA.1168@TK2MSFTNGP02.phx.gbl... >>> So, I have found the log, and am receiving the following error >>> information: >>> >>> 2007-09-27 14:40:23.13 spid21s Informational: Full-text Full >>> population initialized for table or indexed view >>> '[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762', >>> database ID '12'). Population sub-tasks: 1. >>> 2007-09-27 14:40:37.24 spid21s Error '0x80043651: msftesql should >>> reprocess this document in an isolated fashion to confirm the error.' >>> occurred during full-text index population for table or indexed view >>> '[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762', >>> database ID '12'), full-text key value 0x00000001. Attempt will be made >>> to reindex it. >>> 2007-09-27 14:40:37.24 spid21s The component 'MSFTE.DLL' reported >>> error while indexing. Component path 'C:\Program Files\Microsoft SQL >>> Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. >>> 2007-09-27 14:40:37.24 spid21s Warning: No appropriate filter for >>> embedded object was found during full-text index population for table or >>> indexed view '[RMSTest].[Template].[Content]' (table or indexed view ID >>> '2142018762', database ID '12'), full-text key value 0x00000002. Some >>> embedded objects in the row could not be indexed. >>> 2007-09-27 14:40:37.24 spid21s Informational: Full-text Full >>> population completed for table or indexed view >>> '[RMSTest].[Template].[Content]' (table or indexed view ID '2142018762', >>> database ID '12'). Number of documents processed: 2. Number of documents >>> failed: 0. Number of documents need retry: 1. >>> >>> Clearly, it doesn't like my IFilter. Any ideas how I can make SQL >>> recognize this? >>> >>> Thanks, Jim >>> >>> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >>> news:%23o1jMiUAIHA.3940@TK2MSFTNGP05.phx.gbl... >>>> Hi all, >>>> >>>> I'm having some frustrating issues with the PDF IFilter and making it >>>> work. I've read the other posts here, and still haven't been able to >>>> figure this out. I am running SQL Server 2005 Standard 32 bit edition >>>> on Windows Server 2003 Standard Edition. I performed the following: >>>> >>>> 1 - Installed the PDF IFilter v 6.0 >>>> 2 - Ran EXEC sp_fulltext_service 'load_os_resources', 1 >>>> 3 - Stopped and restarted the SQL Server service >>>> 4 - Ran sys.fulltext_document_types and verified that .pdf was indeed a >>>> valid document type >>>> 5 - Built a new full-text catalog and added my table with PDF & other >>>> files (stored as image data type) to the catalog >>>> 6 - Fully populated the FT index >>>> 7 - Ran my CONTAINS query against that table. I'm able to return >>>> results against Office files, but nothing for PDF files. >>>> >>>> So, I'm not sure what I should do at this point. I even tried >>>> restarting the server itself. Somebody (Hilary Cotter?) mentioned that >>>> it might be possible to look at gatherer logs somewhere, but I'm not >>>> clear where those would be. I would appreciate any further >>>> suggestions. >>>> >>>> Thanks, Jim >>>> >>> >>> >> >> > >
Hi Hilary,
Thank you for responding. I've tried a number of different PDFs, but this is one of the ones that did not work (http://www.cogenix.com/Registration_2007-2008.pdf). As you'll see, it's version 1.3 (Acrobat 4.x), and it's got quite a bit of text in it. I'm sorry I couldn't attach this file directly to this post... Thanks again, Jim [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:ucRJ11WAIHA.1212@TK2MSFTNGP05.phx.gbl... > can you post a problem pdf here? Sometime PDFs only contain images and no > text. The iFilter can only understand the text. Also what version of the > is it? > > -- > RelevantNoise.com - dedicated to mining blogs for business intelligence. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message > news:%23eQ$P6VAIHA.3848@TK2MSFTNGP05.phx.gbl... >> Sorry, scratch that last one, the DOC file I was looking at was >> corrupted. >> PDF problem remains, however... >> Thanks! >> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >> news:O1Tn0fVAIHA.5184@TK2MSFTNGP02.phx.gbl... >>> OK, this gets stranger by the minute. I am able to successfully index >>> Excel files, but I am not able to index Word documents! I get this >>> message in my logs. >>> >>> 2007-09-27 15:41:04.59 spid19s Error '0x8004170c: The document >>> format >>> is not recognized by the filter.' occurred during full-text index >>> population for table or indexed view '[RMSTest].[Template].[Content]' >>> (table or indexed view ID '2142018762', database ID '12'), full-text key >>> value 0x00000003. Attempt will be made to reindex it. >>> 2007-09-27 15:41:04.59 spid19s The component 'offfilt.dll' reported >>> error while indexing. Component path 'C:\WINDOWS\system32\offfilt.dll'. >>> >>> Please, I will lose all my hair soon, any ideas are welcome. >>> >>> >>> >>> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >>> news:eyhiy9UAIHA.1168@TK2MSFTNGP02.phx.gbl... >>>> So, I have found the log, and am receiving the following error >>>> information: >>>> >>>> 2007-09-27 14:40:23.13 spid21s Informational: Full-text Full >>>> population initialized for table or indexed view >>>> '[RMSTest].[Template].[Content]' (table or indexed view ID >>>> '2142018762', >>>> database ID '12'). Population sub-tasks: 1. >>>> 2007-09-27 14:40:37.24 spid21s Error '0x80043651: msftesql should >>>> reprocess this document in an isolated fashion to confirm the error.' >>>> occurred during full-text index population for table or indexed view >>>> '[RMSTest].[Template].[Content]' (table or indexed view ID >>>> '2142018762', >>>> database ID '12'), full-text key value 0x00000001. Attempt will be made >>>> to reindex it. >>>> 2007-09-27 14:40:37.24 spid21s The component 'MSFTE.DLL' reported >>>> error while indexing. Component path 'C:\Program Files\Microsoft SQL >>>> Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. >>>> 2007-09-27 14:40:37.24 spid21s Warning: No appropriate filter for >>>> embedded object was found during full-text index population for table >>>> or >>>> indexed view '[RMSTest].[Template].[Content]' (table or indexed view ID >>>> '2142018762', database ID '12'), full-text key value 0x00000002. Some >>>> embedded objects in the row could not be indexed. >>>> 2007-09-27 14:40:37.24 spid21s Informational: Full-text Full >>>> population completed for table or indexed view >>>> '[RMSTest].[Template].[Content]' (table or indexed view ID >>>> '2142018762', >>>> database ID '12'). Number of documents processed: 2. Number of >>>> documents >>>> failed: 0. Number of documents need retry: 1. >>>> >>>> Clearly, it doesn't like my IFilter. Any ideas how I can make SQL >>>> recognize this? >>>> >>>> Thanks, Jim >>>> >>>> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >>>> news:%23o1jMiUAIHA.3940@TK2MSFTNGP05.phx.gbl... >>>>> Hi all, >>>>> >>>>> I'm having some frustrating issues with the PDF IFilter and making it >>>>> work. I've read the other posts here, and still haven't been able to >>>>> figure this out. I am running SQL Server 2005 Standard 32 bit edition >>>>> on Windows Server 2003 Standard Edition. I performed the following: >>>>> >>>>> 1 - Installed the PDF IFilter v 6.0 >>>>> 2 - Ran EXEC sp_fulltext_service 'load_os_resources', 1 >>>>> 3 - Stopped and restarted the SQL Server service >>>>> 4 - Ran sys.fulltext_document_types and verified that .pdf was indeed >>>>> a >>>>> valid document type >>>>> 5 - Built a new full-text catalog and added my table with PDF & other >>>>> files (stored as image data type) to the catalog >>>>> 6 - Fully populated the FT index >>>>> 7 - Ran my CONTAINS query against that table. I'm able to return >>>>> results against Office files, but nothing for PDF files. >>>>> >>>>> So, I'm not sure what I should do at this point. I even tried >>>>> restarting the server itself. Somebody (Hilary Cotter?) mentioned >>>>> that >>>>> it might be possible to look at gatherer logs somewhere, but I'm not >>>>> clear where those would be. I would appreciate any further >>>>> suggestions. >>>>> >>>>> Thanks, Jim >>>>> >>>> >>>> >>> >>> >> >> > >
Hi Hilary,
Thank you for responding. I've tried a number of different PDFs, but this is one of the ones that did not work (http://www.cogenix.com/Registration_2007-2008.pdf). As you'll see, it's version 1.3 (Acrobat 4.x), and it's got quite a bit of text in it. I'm sorry I couldn't attach this file directly to this post... Thanks again, Jim [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:ucRJ11WAIHA.1212@TK2MSFTNGP05.phx.gbl... > can you post a problem pdf here? Sometime PDFs only contain images and no > text. The iFilter can only understand the text. Also what version of the > PDF is it? > > -- > RelevantNoise.com - dedicated to mining blogs for business intelligence. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message > news:%23eQ$P6VAIHA.3848@TK2MSFTNGP05.phx.gbl... >> Sorry, scratch that last one, the DOC file I was looking at was >> corrupted. PDF problem remains, however... >> Thanks! >> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >> news:O1Tn0fVAIHA.5184@TK2MSFTNGP02.phx.gbl... >>> OK, this gets stranger by the minute. I am able to successfully index >>> Excel files, but I am not able to index Word documents! I get this >>> message in my logs. >>> >>> 2007-09-27 15:41:04.59 spid19s Error '0x8004170c: The document >>> format is not recognized by the filter.' occurred during full-text index >>> population for table or indexed view '[RMSTest].[Template].[Content]' >>> (table or indexed view ID '2142018762', database ID '12'), full-text key >>> value 0x00000003. Attempt will be made to reindex it. >>> 2007-09-27 15:41:04.59 spid19s The component 'offfilt.dll' reported >>> error while indexing. Component path 'C:\WINDOWS\system32\offfilt.dll'. >>> >>> Please, I will lose all my hair soon, any ideas are welcome. >>> >>> >>> >>> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >>> news:eyhiy9UAIHA.1168@TK2MSFTNGP02.phx.gbl... >>>> So, I have found the log, and am receiving the following error >>>> information: >>>> >>>> 2007-09-27 14:40:23.13 spid21s Informational: Full-text Full >>>> population initialized for table or indexed view >>>> '[RMSTest].[Template].[Content]' (table or indexed view ID >>>> '2142018762', database ID '12'). Population sub-tasks: 1. >>>> 2007-09-27 14:40:37.24 spid21s Error '0x80043651: msftesql should >>>> reprocess this document in an isolated fashion to confirm the error.' >>>> occurred during full-text index population for table or indexed view >>>> '[RMSTest].[Template].[Content]' (table or indexed view ID >>>> '2142018762', database ID '12'), full-text key value 0x00000001. >>>> Attempt will be made to reindex it. >>>> 2007-09-27 14:40:37.24 spid21s The component 'MSFTE.DLL' reported >>>> error while indexing. Component path 'C:\Program Files\Microsoft SQL >>>> Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. >>>> 2007-09-27 14:40:37.24 spid21s Warning: No appropriate filter for >>>> embedded object was found during full-text index population for table >>>> or indexed view '[RMSTest].[Template].[Content]' (table or indexed view >>>> ID '2142018762', database ID '12'), full-text key value 0x00000002. >>>> Some embedded objects in the row could not be indexed. >>>> 2007-09-27 14:40:37.24 spid21s Informational: Full-text Full >>>> population completed for table or indexed view >>>> '[RMSTest].[Template].[Content]' (table or indexed view ID >>>> '2142018762', database ID '12'). Number of documents processed: 2. >>>> Number of documents failed: 0. Number of documents need retry: 1. >>>> >>>> Clearly, it doesn't like my IFilter. Any ideas how I can make SQL >>>> recognize this? >>>> >>>> Thanks, Jim >>>> >>>> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >>>> news:%23o1jMiUAIHA.3940@TK2MSFTNGP05.phx.gbl... >>>>> Hi all, >>>>> >>>>> I'm having some frustrating issues with the PDF IFilter and making it >>>>> work. I've read the other posts here, and still haven't been able to >>>>> figure this out. I am running SQL Server 2005 Standard 32 bit edition >>>>> on Windows Server 2003 Standard Edition. I performed the following: >>>>> >>>>> 1 - Installed the PDF IFilter v 6.0 >>>>> 2 - Ran EXEC sp_fulltext_service 'load_os_resources', 1 >>>>> 3 - Stopped and restarted the SQL Server service >>>>> 4 - Ran sys.fulltext_document_types and verified that .pdf was indeed >>>>> a valid document type >>>>> 5 - Built a new full-text catalog and added my table with PDF & other >>>>> files (stored as image data type) to the catalog >>>>> 6 - Fully populated the FT index >>>>> 7 - Ran my CONTAINS query against that table. I'm able to return >>>>> results against Office files, but nothing for PDF files. >>>>> >>>>> So, I'm not sure what I should do at this point. I even tried >>>>> restarting the server itself. Somebody (Hilary Cotter?) mentioned >>>>> that it might be possible to look at gatherer logs somewhere, but I'm >>>>> not clear where those would be. I would appreciate any further >>>>> suggestions. >>>>> >>>>> Thanks, Jim >>>>> >>>> >>>> >>> >>> >> >> > >
You are so right! I apologize, I had seen the text in the document and
thought it was text - and I did try a couple of other PDF files with a similar lack of success. However, I did generate a new PDF file (which is version 1.4 (Acrobat 5.x)), and it does index correctly. I wonder if the PDF version needs to be 1.4 or greater, and, if so, how does one determine that it is so... Anyway, thank you so much for your help... Jim [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:OGVR2AgAIHA.4752@TK2MSFTNGP04.phx.gbl... > The entire pdf is an image (an image of text mind you), but there is not > text in there. > > You need to do ocr on the image to extract the text. = > > -- > RelevantNoise.com - dedicated to mining blogs for business intelligence. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message > news:OaUtPGfAIHA.1208@TK2MSFTNGP03.phx.gbl... >> Hi Hilary, >> >> Thank you for responding. I've tried a number of different PDFs, but >> this is one of the ones that did not work >> (http://www.cogenix.com/Registration_2007-2008.pdf). As you'll see, it's >> version 1.3 (Acrobat 4.x), and it's got quite a bit of text in it. I'm >> sorry I couldn't attach this file directly to this post... >> >> Thanks again, Jim >> >> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >> news:ucRJ11WAIHA.1212@TK2MSFTNGP05.phx.gbl... >>> can you post a problem pdf here? Sometime PDFs only contain images and >>> no text. The iFilter can only understand the text. Also what version of >>> the PDF is it? >>> >>> -- >>> RelevantNoise.com - dedicated to mining blogs for business intelligence. >>> >>> Looking for a SQL Server replication book? >>> http://www.nwsu.com/0974973602.html >>> >>> Looking for a FAQ on Indexing Services/SQL FTS >>> http://www.indexserverfaq.com >>> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >>> news:%23eQ$P6VAIHA.3848@TK2MSFTNGP05.phx.gbl... >>>> Sorry, scratch that last one, the DOC file I was looking at was >>>> corrupted. PDF problem remains, however... >>>> Thanks! >>>> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >>>> news:O1Tn0fVAIHA.5184@TK2MSFTNGP02.phx.gbl... >>>>> OK, this gets stranger by the minute. I am able to successfully index >>>>> Excel files, but I am not able to index Word documents! I get this >>>>> message in my logs. >>>>> >>>>> 2007-09-27 15:41:04.59 spid19s Error '0x8004170c: The document >>>>> format is not recognized by the filter.' occurred during full-text >>>>> index population for table or indexed view >>>>> '[RMSTest].[Template].[Content]' (table or indexed view ID >>>>> '2142018762', database ID '12'), full-text key value 0x00000003. >>>>> Attempt will be made to reindex it. >>>>> 2007-09-27 15:41:04.59 spid19s The component 'offfilt.dll' >>>>> reported error while indexing. Component path >>>>> 'C:\WINDOWS\system32\offfilt.dll'. >>>>> >>>>> Please, I will lose all my hair soon, any ideas are welcome. >>>>> >>>>> >>>>> >>>>> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >>>>> news:eyhiy9UAIHA.1168@TK2MSFTNGP02.phx.gbl... >>>>>> So, I have found the log, and am receiving the following error >>>>>> information: >>>>>> >>>>>> 2007-09-27 14:40:23.13 spid21s Informational: Full-text Full >>>>>> population initialized for table or indexed view >>>>>> '[RMSTest].[Template].[Content]' (table or indexed view ID >>>>>> '2142018762', database ID '12'). Population sub-tasks: 1. >>>>>> 2007-09-27 14:40:37.24 spid21s Error '0x80043651: msftesql should >>>>>> reprocess this document in an isolated fashion to confirm the error.' >>>>>> occurred during full-text index population for table or indexed view >>>>>> '[RMSTest].[Template].[Content]' (table or indexed view ID >>>>>> '2142018762', database ID '12'), full-text key value 0x00000001. >>>>>> Attempt will be made to reindex it. >>>>>> 2007-09-27 14:40:37.24 spid21s The component 'MSFTE.DLL' reported >>>>>> error while indexing. Component path 'C:\Program Files\Microsoft SQL >>>>>> Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. >>>>>> 2007-09-27 14:40:37.24 spid21s Warning: No appropriate filter for >>>>>> embedded object was found during full-text index population for table >>>>>> or indexed view '[RMSTest].[Template].[Content]' (table or indexed >>>>>> view ID '2142018762', database ID '12'), full-text key value >>>>>> 0x00000002. Some embedded objects in the row could not be indexed. >>>>>> 2007-09-27 14:40:37.24 spid21s Informational: Full-text Full >>>>>> population completed for table or indexed view >>>>>> '[RMSTest].[Template].[Content]' (table or indexed view ID >>>>>> '2142018762', database ID '12'). Number of documents processed: 2. >>>>>> Number of documents failed: 0. Number of documents need retry: 1. >>>>>> >>>>>> Clearly, it doesn't like my IFilter. Any ideas how I can make SQL >>>>>> recognize this? >>>>>> >>>>>> Thanks, Jim >>>>>> >>>>>> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >>>>>> news:%23o1jMiUAIHA.3940@TK2MSFTNGP05.phx.gbl... >>>>>>> Hi all, >>>>>>> >>>>>>> I'm having some frustrating issues with the PDF IFilter and making >>>>>>> it work. I've read the other posts here, and still haven't been able >>>>>>> to figure this out. I am running SQL Server 2005 Standard 32 bit >>>>>>> edition on Windows Server 2003 Standard Edition. I performed the >>>>>>> following: >>>>>>> >>>>>>> 1 - Installed the PDF IFilter v 6.0 >>>>>>> 2 - Ran EXEC sp_fulltext_service 'load_os_resources', 1 >>>>>>> 3 - Stopped and restarted the SQL Server service >>>>>>> 4 - Ran sys.fulltext_document_types and verified that .pdf was >>>>>>> indeed a valid document type >>>>>>> 5 - Built a new full-text catalog and added my table with PDF & >>>>>>> other files (stored as image data type) to the catalog >>>>>>> 6 - Fully populated the FT index >>>>>>> 7 - Ran my CONTAINS query against that table. I'm able to return >>>>>>> results against Office files, but nothing for PDF files. >>>>>>> >>>>>>> So, I'm not sure what I should do at this point. I even tried >>>>>>> restarting the server itself. Somebody (Hilary Cotter?) mentioned >>>>>>> that it might be possible to look at gatherer logs somewhere, but >>>>>>> I'm not clear where those would be. I would appreciate any further >>>>>>> suggestions. >>>>>>> >>>>>>> Thanks, Jim >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
The entire pdf is an image (an image of text mind you), but there is not
text in there. You need to do ocr on the image to extract the text. = -- RelevantNoise.com - dedicated to mining blogs for business intelligence. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message news:OaUtPGfAIHA.1208@TK2MSFTNGP03.phx.gbl... > Hi Hilary, > > Thank you for responding. I've tried a number of different PDFs, but this > is one of the ones that did not work > (http://www.cogenix.com/Registration_2007-2008.pdf). As you'll see, it's > version 1.3 (Acrobat 4.x), and it's got quite a bit of text in it. I'm > sorry I couldn't attach this file directly to this post... > > Thanks again, Jim > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:ucRJ11WAIHA.1212@TK2MSFTNGP05.phx.gbl... >> can you post a problem pdf here? Sometime PDFs only contain images and no >> text. The iFilter can only understand the text. Also what version of the >> PDF is it? >> >> -- >> RelevantNoise.com - dedicated to mining blogs for business intelligence. >> >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >> news:%23eQ$P6VAIHA.3848@TK2MSFTNGP05.phx.gbl... >>> Sorry, scratch that last one, the DOC file I was looking at was >>> corrupted. PDF problem remains, however... >>> Thanks! >>> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >>> news:O1Tn0fVAIHA.5184@TK2MSFTNGP02.phx.gbl... >>>> OK, this gets stranger by the minute. I am able to successfully index >>>> Excel files, but I am not able to index Word documents! I get this >>>> message in my logs. >>>> >>>> 2007-09-27 15:41:04.59 spid19s Error '0x8004170c: The document >>>> format is not recognized by the filter.' occurred during full-text >>>> index population for table or indexed view >>>> '[RMSTest].[Template].[Content]' (table or indexed view ID >>>> '2142018762', database ID '12'), full-text key value 0x00000003. >>>> Attempt will be made to reindex it. >>>> 2007-09-27 15:41:04.59 spid19s The component 'offfilt.dll' reported >>>> error while indexing. Component path 'C:\WINDOWS\system32\offfilt.dll'. >>>> >>>> Please, I will lose all my hair soon, any ideas are welcome. >>>> >>>> >>>> >>>> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >>>> news:eyhiy9UAIHA.1168@TK2MSFTNGP02.phx.gbl... >>>>> So, I have found the log, and am receiving the following error >>>>> information: >>>>> >>>>> 2007-09-27 14:40:23.13 spid21s Informational: Full-text Full >>>>> population initialized for table or indexed view >>>>> '[RMSTest].[Template].[Content]' (table or indexed view ID >>>>> '2142018762', database ID '12'). Population sub-tasks: 1. >>>>> 2007-09-27 14:40:37.24 spid21s Error '0x80043651: msftesql should >>>>> reprocess this document in an isolated fashion to confirm the error.' >>>>> occurred during full-text index population for table or indexed view >>>>> '[RMSTest].[Template].[Content]' (table or indexed view ID >>>>> '2142018762', database ID '12'), full-text key value 0x00000001. >>>>> Attempt will be made to reindex it. >>>>> 2007-09-27 14:40:37.24 spid21s The component 'MSFTE.DLL' reported >>>>> error while indexing. Component path 'C:\Program Files\Microsoft SQL >>>>> Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. >>>>> 2007-09-27 14:40:37.24 spid21s Warning: No appropriate filter for >>>>> embedded object was found during full-text index population for table >>>>> or indexed view '[RMSTest].[Template].[Content]' (table or indexed >>>>> view ID '2142018762', database ID '12'), full-text key value >>>>> 0x00000002. Some embedded objects in the row could not be indexed. >>>>> 2007-09-27 14:40:37.24 spid21s Informational: Full-text Full >>>>> population completed for table or indexed view >>>>> '[RMSTest].[Template].[Content]' (table or indexed view ID >>>>> '2142018762', database ID '12'). Number of documents processed: 2. >>>>> Number of documents failed: 0. Number of documents need retry: 1. >>>>> >>>>> Clearly, it doesn't like my IFilter. Any ideas how I can make SQL >>>>> recognize this? >>>>> >>>>> Thanks, Jim >>>>> >>>>> "LiveCycle" <livecycle@sandbox.etech.adobe.com> wrote in message >>>>> news:%23o1jMiUAIHA.3940@TK2MSFTNGP05.phx.gbl... >>>>>> Hi all, >>>>>> >>>>>> I'm having some frustrating issues with the PDF IFilter and making it >>>>>> work. I've read the other posts here, and still haven't been able to >>>>>> figure this out. I am running SQL Server 2005 Standard 32 bit >>>>>> edition on Windows Server 2003 Standard Edition. I performed the >>>>>> following: >>>>>> >>>>>> 1 - Installed the PDF IFilter v 6.0 >>>>>> 2 - Ran EXEC sp_fulltext_service 'load_os_resources', 1 >>>>>> 3 - Stopped and restarted the SQL Server service >>>>>> 4 - Ran sys.fulltext_document_types and verified that .pdf was indeed >>>>>> a valid document type >>>>>> 5 - Built a new full-text catalog and added my table with PDF & other >>>>>> files (stored as image data type) to the catalog >>>>>> 6 - Fully populated the FT index >>>>>> 7 - Ran my CONTAINS query against that table. I'm able to return >>>>>> results against Office files, but nothing for PDF files. >>>>>> >>>>>> So, I'm not sure what I should do at this point. I even tried >>>>>> restarting the server itself. Somebody (Hilary Cotter?) mentioned >>>>>> that it might be possible to look at gatherer logs somewhere, but I'm >>>>>> not clear where those would be. I would appreciate any further >>>>>> suggestions. >>>>>> >>>>>> Thanks, Jim >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
I'm not sure if this will work, these instructions were with a similar situation.
Run both of these against the master database, one at a time sp_fulltext_service 'load_os_resources',1 sp_fulltext_service 'verify_signature',0 Then restart SQL server service and the SQL server full text search service. Then try searching for full text in PDF again. If that doesn't work, I had to do this recently when we had a problem, I had to uninstall the PDF ifilter v6.0, re-install it, rerun the queries against the master db, delete the full text search object_data, create a new one, rerun the full text rebuild command and then it all worked. EggHeadCafe - .NET Developer Portal of Choice
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |