|
|
You're in the
sql server full text search
group:SQL FT Catalog not populated
sql server full text search:
I created ful-text catalog. then I created full-text index for a few tables. and after that I run select FULLTEXTCATALOGPROPERTY('FT','ItemCount') and it return 0 also I tryed to perform a search and I got 0 results.. I followed the syteps in here ; http://www.geekzilla.co.uk/View0E316ED1-7A99-42FD-B80D-272C15C98027.htm but nothing works , even I tryed to SQL online book samples , but nothing works. does anyone meet similar problems? P.S. SQL 2005 run under MS 2000 Server with SP4
Did you run a full population yet? can you send the gatherer logs?
-- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. 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 [quoted text, click to view] <Dorin.Manoli@gmail.com> wrote in message news:1156522408.960759.120110@b28g2000cwb.googlegroups.com... > In MS SQL 2005 Enterprise Evaluation > I created ful-text catalog. then I created full-text index for a few > tables. and after that I run > select FULLTEXTCATALOGPROPERTY('FT','ItemCount') > and it return 0 > > also I tryed to perform a search and I got 0 results.. > > I followed the syteps in here ; > http://www.geekzilla.co.uk/View0E316ED1-7A99-42FD-B80D-272C15C98027.htm > but nothing works , even I tryed to SQL online book samples , but > nothing works. > does anyone meet similar problems? > > P.S. SQL 2005 run under MS 2000 Server with SP4 >
[quoted text, click to view] Hilary Cotter wrote: > Did you run a full population yet? can you send the gatherer logs? yes I run it but LOGS complain about: 2006-08-28 09:55:47.23 spid22s Informational: Full-text Full population initialized for table or indexed view '[DataIreland].[dbo].[CompanyNames]' (table or indexed view ID '1813581499', database ID '8'). Population sub-tasks: 2. 2006-08-28 09:55:50.79 spid22s Error '0x80040154' occurred during full-text index population for table or indexed view '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID '1813581499', database ID '8'), full-text key value 0x0000000000001964. Failed to index the row. 2006-08-28 09:55:50.79 spid22s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during full-text index population for table or indexed view '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID '1813581499', database ID '8'), full-text key value 0x0000000000001963. Failed to index the row. 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during full-text index population for table or indexed view '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID '1813581499', database ID '8'), full-text key value 0x0000000000001962. Failed to index the row. 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during full-text index population for table or indexed view '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID '1813581499', database ID '8'), full-text key value 0x0000000000001961. Failed to index the row. 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during full-text index population for table or indexed view '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID '1813581499', database ID '8'), full-text key value 0x0000000000001960. Failed to index the row. 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during full-text index population for table or indexed view '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID '1813581499', database ID '8'), full-text key value 0x000000000000195F. Failed to index the row. 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during full-text index population for table or indexed view '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID '1813581499', database ID '8'), full-text key value 0x000000000000195E. Failed to index the row. 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during full-text index population for table or indexed view '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID '1813581499', database ID '8'), full-text key value 0x000000000000195D. Failed to index the row. 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during full-text index population for table or indexed view '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID '1813581499', database ID '8'), full-text key value 0x000000000000195C. Failed to index the row. 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during full-text index population for table or indexed view '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID '1813581499', database ID '8'), full-text key value 0x000000000000195B. Failed to index the row. 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during full-text index population for table or indexed view '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID '1813581499', database ID '8'), full-text key value 0x000000000000195A. Failed to index the row. 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during full-text index population for table or indexed view '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID '1813581499', database ID '8'), full-text key value 0x0000000000001959. Failed to index the row. 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during full-text index population for table or indexed view '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID '1813581499', database ID '8'), full-text key value 0x0000000000001958. Failed to index the row. 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during full-text index population for table or indexed view '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID '1813581499', database ID '8'), full-text key value 0x0000000000001957. Failed to index the row. 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
[quoted text, click to view] Hilary Cotter wrote: "6497 Athlacca National School NULL 255719 1"> That's a generic class not registered error. Perhaps your ifilter is not > registered correctly. > > What is the output of this row > > select * from CompanyNames where pk=6497 > what is the link betwen above errors and select statement?
actualy all rows aren't indexed ...
row is nvarchar(55) and select by name is ok..
That's a generic class not registered error. Perhaps your ifilter is not
registered correctly. What is the output of this row select * from CompanyNames where pk=6497 -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. 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 [quoted text, click to view] <Dorin.Manoli@gmail.com> wrote in message
news:1156757110.529064.201230@m79g2000cwm.googlegroups.com... > > Hilary Cotter wrote: >> Did you run a full population yet? can you send the gatherer logs? > > yes I run it but LOGS complain about: > > 2006-08-28 09:55:47.23 spid22s Informational: Full-text Full > population initialized for table or indexed view > '[DataIreland].[dbo].[CompanyNames]' (table or indexed view ID > '1813581499', database ID '8'). Population sub-tasks: 2. > 2006-08-28 09:55:50.79 spid22s Error '0x80040154' occurred during > full-text index population for table or indexed view > '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID > '1813581499', database ID '8'), full-text key value 0x0000000000001964. > Failed to index the row. > 2006-08-28 09:55:50.79 spid22s The component 'MSFTE.DLL' reported > error while indexing. Component path 'C:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. > 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during > full-text index population for table or indexed view > '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID > '1813581499', database ID '8'), full-text key value 0x0000000000001963. > Failed to index the row. > 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported > error while indexing. Component path 'C:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. > 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during > full-text index population for table or indexed view > '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID > '1813581499', database ID '8'), full-text key value 0x0000000000001962. > Failed to index the row. > 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported > error while indexing. Component path 'C:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. > 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during > full-text index population for table or indexed view > '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID > '1813581499', database ID '8'), full-text key value 0x0000000000001961. > Failed to index the row. > 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported > error while indexing. Component path 'C:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. > 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during > full-text index population for table or indexed view > '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID > '1813581499', database ID '8'), full-text key value 0x0000000000001960. > Failed to index the row. > 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported > error while indexing. Component path 'C:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. > 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during > full-text index population for table or indexed view > '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID > '1813581499', database ID '8'), full-text key value 0x000000000000195F. > Failed to index the row. > 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported > error while indexing. Component path 'C:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. > 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during > full-text index population for table or indexed view > '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID > '1813581499', database ID '8'), full-text key value 0x000000000000195E. > Failed to index the row. > 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported > error while indexing. Component path 'C:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. > 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during > full-text index population for table or indexed view > '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID > '1813581499', database ID '8'), full-text key value 0x000000000000195D. > Failed to index the row. > 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported > error while indexing. Component path 'C:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. > 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during > full-text index population for table or indexed view > '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID > '1813581499', database ID '8'), full-text key value 0x000000000000195C. > Failed to index the row. > 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported > error while indexing. Component path 'C:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. > 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during > full-text index population for table or indexed view > '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID > '1813581499', database ID '8'), full-text key value 0x000000000000195B. > Failed to index the row. > 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported > error while indexing. Component path 'C:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. > 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during > full-text index population for table or indexed view > '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID > '1813581499', database ID '8'), full-text key value 0x000000000000195A. > Failed to index the row. > 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported > error while indexing. Component path 'C:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. > 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during > full-text index population for table or indexed view > '[DatabaseName].[dbo].[CompanyNames]' (table or indexed view ID > '1813581499', database ID '8'), full-text key value 0x0000000000001959. > Failed to index the row. > 2006-08-28 09:55:50.81 spid22s The component 'MSFTE.DLL' reported > error while indexing. Component path 'C:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'. > 2006-08-28 09:55:50.81 spid22s Error '0x80040154' occurred during
I think this is one of the rows which was not indexed. What are the column
headers for this row? And can you search on "Athlacca National School" and get this row? -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. 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 [quoted text, click to view] <Dorin.Manoli@gmail.com> wrote in message news:1156770471.490050.319030@b28g2000cwb.googlegroups.com... > > Hilary Cotter wrote: >> That's a generic class not registered error. Perhaps your ifilter is not >> registered correctly. >> >> What is the output of this row >> >> select * from CompanyNames where pk=6497 >> > "6497 Athlacca National School NULL 255719 1" > > what is the link betwen above errors and select statement? >
can be that an issue only on Win 2k ?
[quoted text, click to view] Dorin.Manoli@gmail.com wrote:
> actualy all rows aren't indexed ... > row is nvarchar(55) > > and select by name is ok..
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |