 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / October 2004FT index not function ?
I configure a table with FT index , but when i search the table , nothing returned , why ? Windows 2003 EE (Chinese Edition) SQL Server 2k + SP3 (Chinese Edition) 1. makefile C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\Config\noise.chs 2. start the MSSearch service with local system account. 3. connect to SQL Database with isqlw create table docbase , the type of dcont field is image and to store my document of word,excel,ppt,htm etc. 4. enable Fulltext of database sp_fulltext_database 'enable' 5. create catalogs execute sp_fulltext_catalog 'ft_test','create','U:\minicent\FTDATA' execute sp_fulltext_table 'DOCBASE','create', 'ft_test','PK_DOCBASE ' execute sp_fulltext_column 'DOCBASE' , 'DCONT' , 'add' , 0x0804 , 'DOCTYPE' -- language is Simplified Chinese 0x0804 execute sp_fulltext_table 'DOCBASE' , 'activate' execute sp_fulltext_catalog 'ft_test','start_full' EXEC sp_tableoption 'DOCBASE', 'text in row', 'ON' EXEC sp_fulltext_table 'DOCBASE', 'Start_change_tracking' EXEC sp_fulltext_table 'DOCBASE', 'Start_background_updateindex' 6. put some docs of type .doc or .xls or .ppt into table docbase by ASP.net applications 7. select kbid , doctype from docbase where freetext ( dcont , 'ChineseChars') nothing returned. But i'm sure the content of the docs include the 'ChineseChars' ! any adea ? thanks ! can you issue this query for me in the database you are Full Text indexing? select FulltextCatalogProperty(N'test', N'ItemCount') Also can you look for any messages in your event log from Microsoft Search with an event ID of 3018 and post the text of this message here?  SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html > I configure a table with FT index , but when i search the > table , nothing returned , why ? [quoted text clipped - 45 lines] > > any adea ? thanks ! Thanks , Cotter 1. > select FulltextCatalogProperty(N'ft_test', N'ItemCount') > 2 2. the 3018 message is: The end of crawl for project <SQLServer SQL0000500005> has been detected. The Gatherer successfully processed 6 documents totaling 0K. It failed to filter 0 documents. URLs could not be reached or were denied access. 3. What's the filter , How to pluggin the filter of document (word ,excel , pdf etc )into the MS Search Service ? >-----Original Message----- >can you issue this query for me in the database you are Full Text indexing? [quoted text clipped - 23 lines] >> 5. create catalogs >> execute sp_fulltext_catalog 'ft_test','create','U:\minicent\FTDATA' >> execute sp_fulltext_table 'DOCBASE','create', 'ft_test','PK_DOCBASE >> ' >> [quoted text clipped - 9 lines] >> >> EXEC sp_fulltext_table 'DOCBASE', 'Start_change_tracking' >> EXEC sp_fulltext_table 'DOCBASE', 'Start_background_updateindex' >> 6. put some docs of type .doc or .xls or .ppt into table >> docbase by ASP.net applications [quoted text clipped - 8 lines] > >. rainbow, From the below results, it does appear that at least 5 rows were successfully FT Indexed. Did you find any other related "Microsoft Search" or MssCi source event errors? Can I assume that the files () that were inserted in by your ASP.NET application contained only Chinese characters and that you issued SQL FTS queries using Chinese characters? If so, and if the documents also contain English words, could you search on the English words? There is a know bug ( bug# 356712) with SQL Server 2000, that "Full-Text: sp_fulltext_column allows you to specify a language on an IMAGE column, though it has no effect on indexing... DOC" and if you are searching on the Chinese characters that the FTS query will fail to return results. Thanks, John > Thanks , Cotter > [quoted text clipped - 82 lines] > > > >. 1) ok, it looks like you have indexed at least one row, or perhaps you are indexing two tables. 2) Is this a recent message for the pubs database? 3) the iFilter for office docs ships with win203 as part of the base operating system so we know its there. Can you try to index the authors table and see if you can query this. This will help to verify that indexing is working currently. I suspect the 3018 is not a recent message. If it is a recent message indexing appears to be working and your problem could be related to language resources. > Thanks , Cotter > [quoted text clipped - 82 lines] > > > >. when i consult the event log , found that : Event Type: Information Event Source: SQLFTHNDLR Event Category: None Event ID: 2001 Date: 10/16/2003 Time: 4:00:41 AM User: N/A Computer: myservername Description: One or more documents stored in image columns with extension 'doc' did not get full-text indexed because loading the filter failed with error '0x1'. Note: These documents will not be passed to MSSearch for indexing, and therefore this failure will not be reflected in the end of crawl summary statistics. How can i load the filter of Ms Office to the MSSearch ??? thanks ! >-----Original Message----- >can you issue this query for me in the database you are Full Text indexing? [quoted text clipped - 23 lines] >> 5. create catalogs >> execute sp_fulltext_catalog 'ft_test','create','U:\minicent\FTDATA' >> execute sp_fulltext_table 'DOCBASE','create', 'ft_test','PK_DOCBASE >> ' >> [quoted text clipped - 9 lines] >> >> EXEC sp_fulltext_table 'DOCBASE', 'Start_change_tracking' >> EXEC sp_fulltext_table 'DOCBASE', 'Start_background_updateindex' >> 6. put some docs of type .doc or .xls or .ppt into table >> docbase by ASP.net applications [quoted text clipped - 8 lines] > >. You're welcome, Rainbow, The key error is "extension 'doc' did not get full-text indexed because loading the filter failed with error '0x1'" and this does indicate a failure to FT Index the MS Word documents that you inserted into a SQL Server table's column (DCONT) defined with the IMAGE datatype. The filter (or more correctly called an IFilter) is loaded automatically based upon the contents of the "file extension" column (DOCTYPE) that is bound with your DCONT column. Could you provide the output of: sp_help DOCBASE as the datatype of DOCTYPE must be correct in order for the MSSearch daemon to load the correct IFilter based upon the content of the DOCTYPE column. Depending upon the datatype and length, you may need to drop the FT Catalog and alter this column in order to correct the bellow error. Note, additional factors may also include how the files are inserted into SQL Server as well as the language of the documents. Regards, John > when i consult the event log , found that : > [quoted text clipped - 88 lines] > > > >. thanks John :) 1. > sp_help DOCBASE > KBID int no 4 10 0 no (n/a) (n/a) NULL DOCTYPE varchar no 10 yes no no Chinese_PRC_CI_AS DCONT image no 16 yes (n/a) (n/a) NULL KBINPUT datetime no 8 yes (n/a) (n/a) NULL 2. select @@version Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: ) 3. select @@language 简体中文 4. sp_help_fulltext_columns dbo 2025058250 DOCBASE DCONT 3 DOCTYPE 2 2052 the fulltext_language is 2052(0x0804 ,simplified_chinese) 5. select FulltextCatalogProperty('ft_test', 'ItemCount') 4 6. Every time i put one document into db , about one minute later , one SQLFTHNDLR 2001 message produced in the system event logs I am compeletely at a loss ! thanks all! >-----Original Message----- >You're welcome, Rainbow, [quoted text clipped - 17 lines] >Regards, >John |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.