?
Solved

How do I change the path in sys.fulltext_document_types

Posted on 2009-05-17
16
Medium Priority
?
1,027 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

762 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