Solved

How do I change the path in sys.fulltext_document_types

Posted on 2009-05-17
16
997 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
  • 9
  • 7
16 Comments
 
LVL 42

Expert Comment

by:EugeneZ
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 42

Expert Comment

by:EugeneZ
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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 42

Expert Comment

by:EugeneZ
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 42

Expert Comment

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

Expert Comment

by:EugeneZ
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 42

Expert Comment

by:EugeneZ
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 42

Expert Comment

by:EugeneZ
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 42

Expert Comment

by:EugeneZ
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 42

Expert Comment

by:EugeneZ
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

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…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

825 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