 |
|
|
|
Next: Developer licensing in 2005
|
| Author |
Message |
External
Since: Oct 22, 2008
Posts: 1
|
(Msg. 1) Posted: Wed Oct 22, 2008 7:25 pm
Post subject: The component 'MSFTE.DLL' reported error while indexing. (IFilter issue?)
Archived from groups: microsoft>public>sqlserver>fulltext (more info?)
|
|
|
Hi all,
I've seen lots of people report this issue, but haven't really ever seen an
answer that is relevant for me, so any suggestions would be welcome.
I'm getting these errors reported when rebuilding all FTS catalogs on our
server.
2008-10-22 23:02:11.41 spid18s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-10-22 23:03:11.41 spid18s Error '0x80043630: The filter daemon
process MSFTEFD timed out for an unknown reason. This may indicate a bug in
a filter, wordbreaker, or protocol handler.' occurred during full-text index
population for table or indexed view
'[SeniorCMS_Master].[dbo].[SN_STANDARDCONTENT_StandardContent]' (table or
indexed view ID '1753109336', database ID '7'), full-text key value
0x00000026. Attempt will be made to reindex it.
We had the Adobe IFilter 6 installed and started getting these errors so I
have uninstalled this to remove this as a source of the problem, and have
rebooted the server, checked the list of installed Ifilters in SQL server
(no longer has the Adobe IFilter using "select document_type, path from
sys.fulltext_document_types") and have rebuilt all the FTS catalogs and am
still getting these errors for each catalog and the catalog ends up with no
0 for an index count.
We have no other Ifilters installed.
We are running SQL Server 9.0.3073 on Server 2003.
Many thanks for any suggestions,
Larry. |
|
| Back to top |
|
 | |
External
Since: Jan 16, 2008
Posts: 143
|
(Msg. 2) Posted: Thu Oct 23, 2008 5:35 am
Post subject: RE: The component 'MSFTE.DLL' reported error while indexing. (IFilter [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
If you are indexing PDF;s you'll need the PDF iFilter installed, and SQL
Server configured to use it.
So you'll need to issue a call to:
sp_fulltext_service 'load_os_resources',1
GO
sp_fulltext_service 'verify_signature', 0.
GO
I would also check the contents of the SN_STANDARDCONTENT_Standard_Content
table, checking what is in the row with a pk value of 38.
"Larry Neylon" wrote:
> Hi all,
>
> I've seen lots of people report this issue, but haven't really ever seen an
> answer that is relevant for me, so any suggestions would be welcome.
>
> I'm getting these errors reported when rebuilding all FTS catalogs on our
> server.
>
> 2008-10-22 23:02:11.41 spid18s The component 'MSFTE.DLL' reported error
> while indexing. Component path 'C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
>
> 2008-10-22 23:03:11.41 spid18s Error '0x80043630: The filter daemon
> process MSFTEFD timed out for an unknown reason. This may indicate a bug in
> a filter, wordbreaker, or protocol handler.' occurred during full-text index
> population for table or indexed view
> '[SeniorCMS_Master].[dbo].[SN_STANDARDCONTENT_StandardContent]' (table or
> indexed view ID '1753109336', database ID '7'), full-text key value
> 0x00000026. Attempt will be made to reindex it.
>
> We had the Adobe IFilter 6 installed and started getting these errors so I
> have uninstalled this to remove this as a source of the problem, and have
> rebooted the server, checked the list of installed Ifilters in SQL server
> (no longer has the Adobe IFilter using "select document_type, path from
> sys.fulltext_document_types") and have rebuilt all the FTS catalogs and am
> still getting these errors for each catalog and the catalog ends up with no
> 0 for an index count.
>
> We have no other Ifilters installed.
>
> We are running SQL Server 9.0.3073 on Server 2003.
>
> Many thanks for any suggestions,
> Larry.
>
>
> |
|
| Back to top |
|
| |
External
Since: Jul 15, 2008
Posts: 4
|
(Msg. 3) Posted: Mon Oct 27, 2008 6:25 am
Post subject: Re: The component 'MSFTE.DLL' reported error while indexing. (IFilter [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Thanks for that Hilary. The problem is that I've removed the PDF IFilter
completely from the machine (I'll worry about indexing PDFs later), but am
still getting this error.
It's not a rogue record, as it's happening on multiple databases on the
server with the same error.
Any other pointers for me?
Cheers,
Larry.
"Hilary Cotter" wrote in message
> If you are indexing PDF;s you'll need the PDF iFilter installed, and SQL
> Server configured to use it.
>
> So you'll need to issue a call to:
>
> sp_fulltext_service 'load_os_resources',1
> GO
> sp_fulltext_service 'verify_signature', 0.
> GO
>
> I would also check the contents of the SN_STANDARDCONTENT_Standard_Content
> table, checking what is in the row with a pk value of 38.
>
>
> "Larry Neylon" wrote:
>
>> Hi all,
>>
>> I've seen lots of people report this issue, but haven't really ever seen
>> an
>> answer that is relevant for me, so any suggestions would be welcome.
>>
>> I'm getting these errors reported when rebuilding all FTS catalogs on our
>> server.
>>
>> 2008-10-22 23:02:11.41 spid18s The component 'MSFTE.DLL' reported
>> error
>> while indexing. Component path 'C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
>>
>> 2008-10-22 23:03:11.41 spid18s Error '0x80043630: The filter daemon
>> process MSFTEFD timed out for an unknown reason. This may indicate a bug
>> in
>> a filter, wordbreaker, or protocol handler.' occurred during full-text
>> index
>> population for table or indexed view
>> '[SeniorCMS_Master].[dbo].[SN_STANDARDCONTENT_StandardContent]' (table or
>> indexed view ID '1753109336', database ID '7'), full-text key value
>> 0x00000026. Attempt will be made to reindex it.
>>
>> We had the Adobe IFilter 6 installed and started getting these errors so
>> I
>> have uninstalled this to remove this as a source of the problem, and have
>> rebooted the server, checked the list of installed Ifilters in SQL server
>> (no longer has the Adobe IFilter using "select document_type, path from
>> sys.fulltext_document_types") and have rebuilt all the FTS catalogs and
>> am
>> still getting these errors for each catalog and the catalog ends up with
>> no
>> 0 for an index count.
>>
>> We have no other Ifilters installed.
>>
>> We are running SQL Server 9.0.3073 on Server 2003.
>>
>> Many thanks for any suggestions,
>> Larry.
>>
>>
>> >> Stay informed about: The component 'MSFTE.DLL' reported error while indexing. (.. |
|
| Back to top |
|
| |
External
Since: Jan 16, 2008
Posts: 143
|
(Msg. 4) Posted: Mon Oct 27, 2008 6:25 am
Post subject: Re: The component 'MSFTE.DLL' reported error while indexing. (IFil [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
What is in the row with a pk of 38? Is it still PDFs? If so, whatever iFilter
is trying to index it will be unable to as it doesn't understand how to
filter PDFs.
"Larry Neylon" wrote:
> Thanks for that Hilary. The problem is that I've removed the PDF IFilter
> completely from the machine (I'll worry about indexing PDFs later), but am
> still getting this error.
>
> It's not a rogue record, as it's happening on multiple databases on the
> server with the same error.
>
> Any other pointers for me?
>
> Cheers,
> Larry.
>
> "Hilary Cotter" wrote in message
>
> > If you are indexing PDF;s you'll need the PDF iFilter installed, and SQL
> > Server configured to use it.
> >
> > So you'll need to issue a call to:
> >
> > sp_fulltext_service 'load_os_resources',1
> > GO
> > sp_fulltext_service 'verify_signature', 0.
> > GO
> >
> > I would also check the contents of the SN_STANDARDCONTENT_Standard_Content
> > table, checking what is in the row with a pk value of 38.
> >
> >
> > "Larry Neylon" wrote:
> >
> >> Hi all,
> >>
> >> I've seen lots of people report this issue, but haven't really ever seen
> >> an
> >> answer that is relevant for me, so any suggestions would be welcome.
> >>
> >> I'm getting these errors reported when rebuilding all FTS catalogs on our
> >> server.
> >>
> >> 2008-10-22 23:02:11.41 spid18s The component 'MSFTE.DLL' reported
> >> error
> >> while indexing. Component path 'C:\Program Files\Microsoft SQL
> >> Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
> >>
> >> 2008-10-22 23:03:11.41 spid18s Error '0x80043630: The filter daemon
> >> process MSFTEFD timed out for an unknown reason. This may indicate a bug
> >> in
> >> a filter, wordbreaker, or protocol handler.' occurred during full-text
> >> index
> >> population for table or indexed view
> >> '[SeniorCMS_Master].[dbo].[SN_STANDARDCONTENT_StandardContent]' (table or
> >> indexed view ID '1753109336', database ID '7'), full-text key value
> >> 0x00000026. Attempt will be made to reindex it.
> >>
> >> We had the Adobe IFilter 6 installed and started getting these errors so
> >> I
> >> have uninstalled this to remove this as a source of the problem, and have
> >> rebooted the server, checked the list of installed Ifilters in SQL server
> >> (no longer has the Adobe IFilter using "select document_type, path from
> >> sys.fulltext_document_types") and have rebuilt all the FTS catalogs and
> >> am
> >> still getting these errors for each catalog and the catalog ends up with
> >> no
> >> 0 for an index count.
> >>
> >> We have no other Ifilters installed.
> >>
> >> We are running SQL Server 9.0.3073 on Server 2003.
> >>
> >> Many thanks for any suggestions,
> >> Larry.
> >>
> >>
> >>
>
>
> >> Stay informed about: The component 'MSFTE.DLL' reported error while indexing. (.. |
|
| Back to top |
|
| |
External
Since: Jul 15, 2008
Posts: 4
|
(Msg. 5) Posted: Mon Oct 27, 2008 8:25 am
Post subject: Re: The component 'MSFTE.DLL' reported error while indexing. (IFil [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Thanks again Hilary,
The data isn't a PDF just text.
There isn't any binary data with a Type in this table.
Regards,
Larry.
"Hilary Cotter" wrote in message
> What is in the row with a pk of 38? Is it still PDFs? If so, whatever
> iFilter
> is trying to index it will be unable to as it doesn't understand how to
> filter PDFs.
>
> "Larry Neylon" wrote:
>
>> Thanks for that Hilary. The problem is that I've removed the PDF IFilter
>> completely from the machine (I'll worry about indexing PDFs later), but
>> am
>> still getting this error.
>>
>> It's not a rogue record, as it's happening on multiple databases on the
>> server with the same error.
>>
>> Any other pointers for me?
>>
>> Cheers,
>> Larry.
>>
>> "Hilary Cotter" wrote in message
>>
>> > If you are indexing PDF;s you'll need the PDF iFilter installed, and
>> > SQL
>> > Server configured to use it.
>> >
>> > So you'll need to issue a call to:
>> >
>> > sp_fulltext_service 'load_os_resources',1
>> > GO
>> > sp_fulltext_service 'verify_signature', 0.
>> > GO
>> >
>> > I would also check the contents of the
>> > SN_STANDARDCONTENT_Standard_Content
>> > table, checking what is in the row with a pk value of 38.
>> >
>> >
>> > "Larry Neylon" wrote:
>> >
>> >> Hi all,
>> >>
>> >> I've seen lots of people report this issue, but haven't really ever
>> >> seen
>> >> an
>> >> answer that is relevant for me, so any suggestions would be welcome.
>> >>
>> >> I'm getting these errors reported when rebuilding all FTS catalogs on
>> >> our
>> >> server.
>> >>
>> >> 2008-10-22 23:02:11.41 spid18s The component 'MSFTE.DLL' reported
>> >> error
>> >> while indexing. Component path 'C:\Program Files\Microsoft SQL
>> >> Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
>> >>
>> >> 2008-10-22 23:03:11.41 spid18s Error '0x80043630: The filter
>> >> daemon
>> >> process MSFTEFD timed out for an unknown reason. This may indicate a
>> >> bug
>> >> in
>> >> a filter, wordbreaker, or protocol handler.' occurred during full-text
>> >> index
>> >> population for table or indexed view
>> >> '[SeniorCMS_Master].[dbo].[SN_STANDARDCONTENT_StandardContent]' (table
>> >> or
>> >> indexed view ID '1753109336', database ID '7'), full-text key value
>> >> 0x00000026. Attempt will be made to reindex it.
>> >>
>> >> We had the Adobe IFilter 6 installed and started getting these errors
>> >> so
>> >> I
>> >> have uninstalled this to remove this as a source of the problem, and
>> >> have
>> >> rebooted the server, checked the list of installed Ifilters in SQL
>> >> server
>> >> (no longer has the Adobe IFilter using "select document_type, path
>> >> from
>> >> sys.fulltext_document_types") and have rebuilt all the FTS catalogs
>> >> and
>> >> am
>> >> still getting these errors for each catalog and the catalog ends up
>> >> with
>> >> no
>> >> 0 for an index count.
>> >>
>> >> We have no other Ifilters installed.
>> >>
>> >> We are running SQL Server 9.0.3073 on Server 2003.
>> >>
>> >> Many thanks for any suggestions,
>> >> Larry.
>> >>
>> >>
>> >>
>>
>>
>> >> Stay informed about: The component 'MSFTE.DLL' reported error while indexing. (.. |
|
| Back to top |
|
| |
| Related Topics: | Indexing (and searching for) percentages - Hi, I have got the following text in a column that is part of a full-text index (SQL Server 2005): Lorem 7% ipsum I understand that by default both the number 7 and the % character are ignored, the former being a noise word, the latter being a..
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..
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..
Fulltext Indexing leaves a transaction open, preventing in.. - Hello, Please read this two threads first, as this all started on .newusers (I'm one of them) More relevant: (http://tinyurl.com/454uav http://preview.tinyurl.com/454uav).. |
|
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
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
