Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Full-text indexing doesn't work for Office 2007 files

  
   Database Help (Home) -> Full Text RSS
Next:  header()  
Author Message
Vishal Dalsania

External


Since: Nov 30, 2008
Posts: 5



(Msg. 1) Posted: Sat Nov 29, 2008 4:25 pm
Post subject: Full-text indexing doesn't work for Office 2007 files
Archived from groups: microsoft>public>sqlserver>fulltext (more info?)
I have installed the New iFilter pack for Office 2007 and currently using
SQL 2005 Enterprise.

All Office 2007 documents are not being indexed.

I installed filter pack from here
http://www.microsoft.com/downloads/details.aspx?FamilyId=60C92A37-719C...77-B5C6

And followed instruction from here
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b945934

I get below error in SQL Server FT Log

2008-11-30 01:06:26.53 spid27s Informational: Full-text Auto population
initialized for table or indexed view '[Test].[dbo].[tblDocuments]' (table
or indexed view ID '21575115', database ID '130'). Population sub-tasks: 1.
2008-11-30 01:08:46.51 spid27s Error '0x80cb4204' occurred during
full-text index population for table or indexed view
'[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115', database
ID '130'), full-text key value 0x00000009. Attempt will be made to reindex
it.
2008-11-30 01:08:46.51 spid27s The component 'offfiltx.dll' reported
error while indexing. Component path
'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
2008-11-30 01:08:48.51 spid27s Error '0x80cb4204' occurred during
full-text index population for table or indexed view
'[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115', database
ID '130'), full-text key value 0x00000009. Attempt will be made to reindex
it.
2008-11-30 01:08:48.51 spid27s The component 'offfiltx.dll' reported
error while indexing. Component path
'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
2008-11-30 01:08:49.51 spid27s Error '0x80cb4204' occurred during
full-text index population for table or indexed view
'[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115', database
ID '130'), full-text key value 0x00000009. Attempt will be made to reindex
it.
2008-11-30 01:08:49.51 spid27s The component 'offfiltx.dll' reported
error while indexing. Component path
'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
2008-11-30 01:08:50.51 spid27s Error '0x80cb4204' occurred during
full-text index population for table or indexed view
'[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115', database
ID '130'), full-text key value 0x00000009. Attempt will be made to reindex
it.
2008-11-30 01:08:50.51 spid27s The component 'offfiltx.dll' reported
error while indexing. Component path
'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
2008-11-30 01:09:54.51 spid24s Error '0x80cb4204' occurred during
full-text index population for table or indexed view
'[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115', database
ID '130'), full-text key value 0x0000000A. Attempt will be made to reindex
it.
2008-11-30 01:09:54.51 spid24s The component 'offfiltx.dll' reported
error while indexing. Component path
'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
2008-11-30 01:09:56.51 spid24s Error '0x80cb4204' occurred during
full-text index population for table or indexed view
'[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115', database
ID '130'), full-text key value 0x0000000A. Attempt will be made to reindex
it.
2008-11-30 01:09:56.51 spid24s The component 'offfiltx.dll' reported
error while indexing. Component path
'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
2008-11-30 01:09:58.51 spid24s Error '0x80cb4204' occurred during
full-text index population for table or indexed view
'[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115', database
ID '130'), full-text key value 0x0000000A. Attempt will be made to reindex
it.
2008-11-30 01:09:58.51 spid24s The component 'offfiltx.dll' reported
error while indexing. Component path
'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
2008-11-30 01:09:59.51 spid24s Error '0x80cb4204' occurred during
full-text index population for table or indexed view
'[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115', database
ID '130'), full-text key value 0x0000000A. Attempt will be made to reindex
it.
2008-11-30 01:09:59.51 spid24s The component 'offfiltx.dll' reported
error while indexing. Component path
'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
2008-11-30 01:12:26.51 spid24s Error '0x80cb4204' occurred during
full-text index population for table or indexed view
'[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115', database
ID '130'), full-text key value 0x0000000A. Attempt will be made to reindex
it.
2008-11-30 01:12:26.51 spid24s The component 'offfiltx.dll' reported
error while indexing. Component path
'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
2008-11-30 01:12:28.51 spid24s Error '0x80cb4204' occurred during
full-text index population for table or indexed view
'[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115', database
ID '130'), full-text key value 0x0000000A. Attempt will be made to reindex
it.
2008-11-30 01:12:28.51 spid24s The component 'offfiltx.dll' reported
error while indexing. Component path
'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
2008-11-30 01:12:30.51 spid24s Error '0x80cb4204' occurred during
full-text index population for table or indexed view
'[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115', database
ID '130'), full-text key value 0x0000000A. Attempt will be made to reindex
it.
2008-11-30 01:12:30.51 spid24s The component 'offfiltx.dll' reported
error while indexing. Component path
'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
2008-11-30 01:12:31.51 spid24s Error '0x80cb4204' occurred during
full-text index population for table or indexed view
'[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115', database
ID '130'), full-text key value 0x0000000A. Attempt will be made to reindex
it.
2008-11-30 01:12:31.51 spid24s The component 'offfiltx.dll' reported
error while indexing. Component path
'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.




What am i missing here?

 >> Stay informed about: Full-text indexing doesn't work for Office 2007 files 
Back to top
Login to vote
Vishal Dalsania

External


Since: Nov 30, 2008
Posts: 5



(Msg. 2) Posted: Sat Nov 29, 2008 6:26 pm
Post subject: Re: Full-text indexing doesn't work for Office 2007 files [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Never mind.

I figured out the problem.

Thanks,


"Vishal Dalsania" wrote in message

>I have installed the New iFilter pack for Office 2007 and currently using
>SQL 2005 Enterprise.
>
> All Office 2007 documents are not being indexed.
>
> I installed filter pack from here
> http://www.microsoft.com/downloads/details.aspx?FamilyId=60C92A37-719C...77-B5C6
>
> And followed instruction from here
> http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b945934
>
> I get below error in SQL Server FT Log
>
> 2008-11-30 01:06:26.53 spid27s Informational: Full-text Auto
> population initialized for table or indexed view
> '[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115',
> database ID '130'). Population sub-tasks: 1.
> 2008-11-30 01:08:46.51 spid27s Error '0x80cb4204' occurred during
> full-text index population for table or indexed view
> '[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115',
> database ID '130'), full-text key value 0x00000009. Attempt will be made
> to reindex it.
> 2008-11-30 01:08:46.51 spid27s The component 'offfiltx.dll' reported
> error while indexing. Component path
> 'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
> 2008-11-30 01:08:48.51 spid27s Error '0x80cb4204' occurred during
> full-text index population for table or indexed view
> '[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115',
> database ID '130'), full-text key value 0x00000009. Attempt will be made
> to reindex it.
> 2008-11-30 01:08:48.51 spid27s The component 'offfiltx.dll' reported
> error while indexing. Component path
> 'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
> 2008-11-30 01:08:49.51 spid27s Error '0x80cb4204' occurred during
> full-text index population for table or indexed view
> '[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115',
> database ID '130'), full-text key value 0x00000009. Attempt will be made
> to reindex it.
> 2008-11-30 01:08:49.51 spid27s The component 'offfiltx.dll' reported
> error while indexing. Component path
> 'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
> 2008-11-30 01:08:50.51 spid27s Error '0x80cb4204' occurred during
> full-text index population for table or indexed view
> '[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115',
> database ID '130'), full-text key value 0x00000009. Attempt will be made
> to reindex it.
> 2008-11-30 01:08:50.51 spid27s The component 'offfiltx.dll' reported
> error while indexing. Component path
> 'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
> 2008-11-30 01:09:54.51 spid24s Error '0x80cb4204' occurred during
> full-text index population for table or indexed view
> '[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115',
> database ID '130'), full-text key value 0x0000000A. Attempt will be made
> to reindex it.
> 2008-11-30 01:09:54.51 spid24s The component 'offfiltx.dll' reported
> error while indexing. Component path
> 'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
> 2008-11-30 01:09:56.51 spid24s Error '0x80cb4204' occurred during
> full-text index population for table or indexed view
> '[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115',
> database ID '130'), full-text key value 0x0000000A. Attempt will be made
> to reindex it.
> 2008-11-30 01:09:56.51 spid24s The component 'offfiltx.dll' reported
> error while indexing. Component path
> 'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
> 2008-11-30 01:09:58.51 spid24s Error '0x80cb4204' occurred during
> full-text index population for table or indexed view
> '[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115',
> database ID '130'), full-text key value 0x0000000A. Attempt will be made
> to reindex it.
> 2008-11-30 01:09:58.51 spid24s The component 'offfiltx.dll' reported
> error while indexing. Component path
> 'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
> 2008-11-30 01:09:59.51 spid24s Error '0x80cb4204' occurred during
> full-text index population for table or indexed view
> '[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115',
> database ID '130'), full-text key value 0x0000000A. Attempt will be made
> to reindex it.
> 2008-11-30 01:09:59.51 spid24s The component 'offfiltx.dll' reported
> error while indexing. Component path
> 'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
> 2008-11-30 01:12:26.51 spid24s Error '0x80cb4204' occurred during
> full-text index population for table or indexed view
> '[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115',
> database ID '130'), full-text key value 0x0000000A. Attempt will be made
> to reindex it.
> 2008-11-30 01:12:26.51 spid24s The component 'offfiltx.dll' reported
> error while indexing. Component path
> 'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
> 2008-11-30 01:12:28.51 spid24s Error '0x80cb4204' occurred during
> full-text index population for table or indexed view
> '[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115',
> database ID '130'), full-text key value 0x0000000A. Attempt will be made
> to reindex it.
> 2008-11-30 01:12:28.51 spid24s The component 'offfiltx.dll' reported
> error while indexing. Component path
> 'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
> 2008-11-30 01:12:30.51 spid24s Error '0x80cb4204' occurred during
> full-text index population for table or indexed view
> '[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115',
> database ID '130'), full-text key value 0x0000000A. Attempt will be made
> to reindex it.
> 2008-11-30 01:12:30.51 spid24s The component 'offfiltx.dll' reported
> error while indexing. Component path
> 'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
> 2008-11-30 01:12:31.51 spid24s Error '0x80cb4204' occurred during
> full-text index population for table or indexed view
> '[Test].[dbo].[tblDocuments]' (table or indexed view ID '21575115',
> database ID '130'), full-text key value 0x0000000A. Attempt will be made
> to reindex it.
> 2008-11-30 01:12:31.51 spid24s The component 'offfiltx.dll' reported
> error while indexing. Component path
> 'C:\PROGRA~1\COMMON~1\MICROS~1\Filters\offfiltx.dll'.
>
>
>
>
> What am i missing here?
>
>

 >> Stay informed about: Full-text indexing doesn't work for Office 2007 files 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQL 2008 Full text indexing - Hi all, Does anyone know if there is a list of improvements to FT indexing in SQL 2008? So far I've heard that it's integrated into the SQL Server engine and no longer a seperate process? I'm assuming this has memory implications like using AWE etc....

How can I rename full text indexing file name - Can any one point me to right direction for renaming of full text index file name. I have full text indexing on a table and I have to rename this file without droping and receating full text indexing. For example SELECT name, physical_name FROM..

Indexing PDF files stored externally to database - Hi I'm working on a project where we intend to use Sql Server FTS to index pdf, chm, doc and html files. For performance reasons, we'd prefer to have the files stored on the file system as opposed to in BLOB fields. These files are going to be..

Full-Text Limitation in SQL 2000? - Hello, Is there a limit to the number of databases on a single SQL Server that can be Full-Text enabled? I have 15 databases all with Full-Text search working fine. Now I just made a 16th database and enabled Full-Text in the usuall manner and nothing..

Can Full Text Searching do this???? - 1. Create a robust search engine able searching of information across all types of content. 2. Support Open Search specification 3. content indexer applying A-Z indexing model and establish keyword metadata references. 4. performs naive Bayes..
   Database Help (Home) -> Full Text All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]