Solved

How do I change the path in sys.fulltext_document_types

Posted on 2009-05-17
16
1,019 Views
Last Modified: 2012-05-07
Hello,  In our sql2005 sp3 configuration, the path for the .mhtml filetype processor stored in the sys.Fullltext_document_types is in error.  It needs to be changed from
C:\windows\system32\%systemroot%\system32\.... to  %systemroot%\system32\  or to the absolute path of C:\windows\system32 ...
0
Comment
Question by:grant-ellsworth
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 7
16 Comments
 
LVL 43

Expert Comment

by:Eugene Z
ID: 24410843
try to add (fix ) new entry in the PATH variable for  the IFilter DLL. (it is what the path in the sys.Fullltext_document_type table)

see more
http://blogs.msdn.com/ifilter/archive/2006/11/20/breaking-the-monolithic-filter-dll.aspx
0
 
LVL 1

Author Comment

by:grant-ellsworth
ID: 24411968
From what I've read since posting the question, I find that I must update the field (column) for the row defining the path for the .mhtml doctype in the system catalog.  So, since I can't do an adhoc update, how DO i update the row in the system catalog table, sys.fulltext_doctypes.  I checked out the link you referred  me to.  that's for programmers.  I'm not doing programming.  I just need to alter this thing for a running production application.
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 24414108
you can not update system tables in sql server 2005 period.
 it looks like  IFilter setup (OS) related
Did you get any errors?
 I have  same .mhtml C:\WINDOWS\system32\%systemroot%\system32\mimefilt.dll   - so it maybe sql server 2005 bug (I have all sp\patches)
 so probalby search does not care about the table...
 
see
http://www.dbnewsgroups.net/group/microsoft.public.sqlserver.programming/topic14884.aspx 
"
that only gives the iFilters which ship with SQL Server 2005. If you choose
to load the ones via

exec sp_fulltext_service 'load_os_resources', 1;
exec sp_fulltext_service 'verify_signature', 0;
go

you need to get a complete list via filtreg

  filtreg.exe
http://msdn.microsoft.com/en-us/library/ms692537(VS.85).aspx
more:
Using Custom Filters with Indexing Service
http://msdn.microsoft.com/en-us/library/ms692577(VS.85).aspx 
0
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
LVL 1

Author Comment

by:grant-ellsworth
ID: 24414444
So far, none of this looks very helpful.  You address the issue as if it was a programmer/developer issue.  I don't have filtreg.exe anywhere on our system.  Nor do I have any programming/development tools on this system.

so, how do we get the fulltext indexer to use the correct filter(?) from the correct location?

Does FiltReg FIX the problem?  How do I obtain this program?
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 24414799
from microsoft
--
It looks like a bug- you need to open MS PSS support  case
 
---
I just checked registry - the path  is there %systemroot%\system32\mimefilt.dll
 
0
 
LVL 1

Author Comment

by:grant-ellsworth
ID: 24415220
Interesdting - MS will charge me $245 to report a bug - after they argue with me on the phone about wheether it is really abug or a figment of my imagination ...
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 24415633
did you get any error when you try to use this  .mhtml file type?
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 24415755
for - fre post bug at
http://connect.microsoft.com/default.aspx
you may need to wait - I am waiting for my posted bug anwser>8 weeks
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 24415788
ops sorry there was answer:
 
Dear Customer,
Thank you for the submission. currently we are unable to resolve this issue,we will look into this in the future.
---
So if it is real issue for you go for PSS
 
0
 
LVL 1

Author Comment

by:grant-ellsworth
ID: 24415933
Microslop rides again ....
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 24416073
lloks like all in the regkey
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSearch\Filters
have normal path
sys.Fullltext_document_types
this one  .mhtml - is not here
 
maybe it is not the same case - however - you may get some good ideas ...
Extending SQL 2005 fulltext search
http://blogs.msdn.com/shajan/archive/2005/12/09/Extending-SQL-2005-Fulltext-Search.aspx 
 
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 24416108
hmm
maybe it just not installed for sql server like in the link above
 
check
http://www.citeknet.com/Products/IFilters/MHTIFilter/tabid/67/Default.aspx 
0
 
LVL 1

Author Comment

by:grant-ellsworth
ID: 24416634
My krap-trapper said http://www.citeknet.com/Products/IFilters/MHTIFilter/tabid/67/Default.aspx is a security exposure - it identified the threat as : Exploit Javascript obfuscation (type 501) - have you got an alternate source?
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 24416954
try
http://www.brothersoft.com/mht-ifilter-78651.html

check
HOW TO: Index Multipurpose Internet Mail Extension Hypertext Markup Language Files in SharePoint Portal Server
http://support.microsoft.com/kb/316040
0
 
LVL 1

Author Comment

by:grant-ellsworth
ID: 24422010
I really don't understand how your last post connects with my problem of sqlserver2005 having incorrect info about where to locate the dll for the mime filter.
---------------------------------------------------------------------------
Meanwhile, I think I've got a generic solution to the problem.  See next post.
0
 
LVL 1

Accepted Solution

by:
grant-ellsworth earned 0 total points
ID: 25006386
Turns out that the solution to this issue involves a registry hack ... as follows:

a.       Run regedit.exe and select the following registry key:  HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{5645C8C2-E277-11CF-8FDA-00AA00A14F93}\InprocServer32 

b.       Modify %systemroot% \system32\mimefilt.dll to c:\WINDOWS\system32\mimefilt.dll 
Please note that FrontRange Solutions does not provide technical support for modifications to the Windows registry.

c.       From the Windows Control Panel, restart the SQL Server FullText Search service and the Microsoft SQL Server service

(credit due to FrontRange Technical support for Goldmine Premium Edition 8.5
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

688 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