Re: No more indexing on text
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Fri, 9 Feb 2007 22:15:47 -0500
do a select distinct std_indexing_type from Files
Check to make sure that you have an ifilter for each extension listed.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Larry Brown" <lbrown@xxxxxxx> wrote in message
news:%23Nr3wHFTHHA.4764@xxxxxxxxxxxxxxxxxxxxxxx
Hello,
I store text files into an SQL Express DB, in a varbinary field.
I have change the naming of some columns in my indexed DB, and I have
changed the indexed column: now, I have two varbinary(max) columns in my
table, one is indexed but not the other. All my files are text.
It appears that none of my files are indexed.Here is what I see in the
logs:
2007-02-09 14:38:02.74 spid21s Informational: Full-text Full
population initialized for table or indexed view
'[IndexingDB].[dbo].[Files]' (table or indexed view ID '37575172',
database ID '7'). Population sub-tasks: 1.
2007-02-09 14:38:15.44 spid21s Warning: No appropriate filter was
found during full-text index population for table or indexed view
'[IndexingDB].[dbo].[Files]' (table or indexed view ID '7', database ID
'37575172'), full-text key value 0x00016B0C. Some columns of the row were
not indexed.
2007-02-09 14:38:15.44 spid21s Warning: No appropriate filter was
found during full-text index population for table or indexed view
'[IndexingDB].[dbo].[Files]' (table or indexed view ID '7', database ID
'37575172'), full-text key value 0x00016B0D. Some columns of the row were
not indexed.
2007-02-09 14:38:15.44 spid21s Warning: No appropriate filter was
found during full-text index population for table or indexed view
'[IndexingDB].[dbo].[Files]' (table or indexed view ID '7', database ID
'37575172'), full-text key value 0x00016B0E. Some columns of the row were
not indexed.
2007-02-09 14:38:15.44 spid21s Informational: Full-text Full
population completed for table or indexed view
'[IndexingDB].[dbo].[Files]' (table or indexed view ID '37575172',
database ID '7'). Number of documents processed: 3. Number of documents
failed: 0. Number of documents need retry: 0.
2007-02-09 14:38:15.46 spid21s Changing the status to MERGE for
full-text catalog "CmpArchivorCat" (41) in database "IndexingDB" (7). This
is an informational message only. No user action is required.
2007-02-09 14:38:15.47 spid24s Informational: Full-text Auto
population initialized for table or indexed view
'[IndexingDB].[dbo].[Files]' (table or indexed view ID '37575172',
database ID '7'). Population sub-tasks: 1.
Here is the stored procedure I used to re-initialize my indexing:
exec sp_fulltext_table 'Files', 'drop'
drop index ui_ftindex on dbo.Files
DROP FULLTEXT CATALOG CmpArchivorCat
exec sp_fulltext_catalog 'CmpArchivorCat', 'create'
CREATE UNIQUE INDEX ui_ftindex ON dbo.Files(file_pk)
CREATE FULLTEXT INDEX ON Files
(file_text TYPE COLUMN std_indexing_type
LANGUAGE 0x0)
KEY INDEX ui_ftindex
ON CmpArchivorCat
WITH
CHANGE_TRACKING AUTO
exec sp_fulltext_service 'load_os_resources', 1;
exec sp_fulltext_service 'verify_signature', 0;
exec sp_fulltext_catalog 'CmpArchivorCat', 'start_full'
I was able to index files from all types in the same DB, but since I've
done my few changes, I can't get anything to work again. I have tried with
both text/plain and text/html in my file type column.
Please help!
.
- Follow-Ups:
- Re: No more indexing on text
- From: Larry Brown
- Re: No more indexing on text
- References:
- No more indexing on text
- From: Larry Brown
- No more indexing on text
- Prev by Date: Re: Index on 4 columns does not return results in expected order
- Next by Date: full text search with language other than english(ex chinese, japanese)
- Previous by thread: No more indexing on text
- Next by thread: Re: No more indexing on text
- Index(es):
Relevant Pages
|
