Solved

How do I change the path in sys.fulltext_document_types

Posted on 2009-05-17
16
984 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 1

Author Comment

by:grant-ellsworth
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
did you get any error when you try to use this  .mhtml file type?
0
 
LVL 42

Expert Comment

by:EugeneZ
Comment Utility
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 42

Expert Comment

by:EugeneZ
Comment Utility
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
Comment Utility
Microslop rides again ....
0
 
LVL 42

Expert Comment

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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Adventure works database .msi 4 50
get all customers 2 37
SQL Query 2 56
How to query LOCK_ESCALATION 4 37
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…
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…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now