July 10, 2011 at 2:19 pm
I'm using SQL Server 2005 Express on Win 2003
I have created a single column index but it is not populating.
I can see the full text service is started.
CREATE FULLTEXT CATALOG Catalog_shop IN PATH 'D:\Data' AS DEFAULT
CREATE FULLTEXT INDEX ON shop_2.dbo.tbl_products
(
searchfield
Language 0X0
)
KEY INDEX PK_tbl_Products ON Catalog_shop
WITH CHANGE_TRACKING AUTO
I have also tried using the below but still the index is not populated.
ALTER FULLTEXT CATALOG Catalog_shop REBUILD
WITH ACCENT_SENSITIVITY = OFF
ALTER FULLTEXT INDEX ON shop_2.dbo.tbl_products
START FULL POPULATION;
its a text field with about 10,000 rows but the catalog is only 257K
it used to work as well but seems to have stopped recently.
any ideas?
July 11, 2011 at 12:32 pm
I've since checked the logs (below).
I've tried dropping and recreating both the catalog and index.
2011-07-10 21:42:43.92 spid27s The full-text catalog monitor reported catalog "Catalog_DB_SALES" (12) in database "DB_SALES_2" (8) in REINITIALIZE state. This is an informational message only. No user action is required.
2011-07-10 21:42:43.94 spid28s Informational: Full-text Full population initialized for table or indexed view '[DB_SALES_2].[dbo].[tbl_Products]' (table or indexed view ID '146815585', database ID '8'). Population sub-tasks: 4.
2011-07-10 21:42:50.70 spid28s Informational: Full-text Full population initialized for table or indexed view '[DB_SALES_2].[dbo].[tbl_Products]' (table or indexed view ID '146815585', database ID '8'). Population sub-tasks: 4.
2011-07-10 21:43:10.56 spid59 Changing the status to PAUSE for full-text catalog "Catalog_DB_SALES" (12) in database "DB_SALES_2" (8). This is an informational message only. No user action is required.
2011-07-10 21:50:24.59 spid59 Warning: Failed to change the status to PAUSE for full-text catalog "Catalog_DB_SALES" (12) in database "DB_SALES_2" (8). Error: 0x80043607(An internal interface is being used after the corresponding catalog has been shutdown. The operation will be aborted.).
2011-07-10 21:50:24.68 spid59 Changing the status to RESUME for full-text catalog "Catalog_DB_SALES" (12) in database "DB_SALES_2" (8). This is an informational message only. No user action is required.
2011-07-10 21:50:24.68 spid59 Warning: Failed to change the status to RESUME for full-text catalog "Catalog_DB_SALES" (12) in database "DB_SALES_2" (8). Error: 0x80043607(An internal interface is being used after the corresponding catalog has been shutdown. The operation will be aborted.).
2011-07-10 21:50:33.94 spid27s The full-text catalog health monitor reported a failure for full-text catalog "Catalog_DB_SALES" (12) in database "DB_SALES_2" (8). Reason code: 0. Error: 0x80010108(The object invoked has disconnected from its clients.). The system will restart any in-progress population from the previous checkpoint. If this message occurs frequently, consult SQL Server Books Online for troubleshooting assistance. This is an informational message only. No user action is required.
2011-07-10 21:50:33.96 spid27s Warning: Failed to get MSFTESQL indexer interface for full-text catalog 'Catalog_DB_SALES' ('12') in database 'DB_SALES_2' ('8'). Error: 0x80070426(The service has not been started.).
2011-07-10 21:50:43.95 spid27s Warning: Failed to get MSFTESQL indexer interface for full-text catalog 'Catalog_DB_SALES' ('12') in database 'DB_SALES_2' ('8'). Error: 0x80070426(The service has not been started.).
2011-07-10 21:50:53.94 spid27s Warning: Failed to get MSFTESQL indexer interface for full-text catalog 'Catalog_DB_SALES' ('12') in database 'DB_SALES_2' ('8'). Error: 0x80070426(The service has not been started.).
2011-07-10 21:51:06.43 spid19s Reinitialized full-text Full population for table '[DB_SALES_2].[dbo].[tbl_Products]' (table ID '146815585', database ID '8') after a temporary failure. Number of documents processed prior to failure: 0, errors encountered: 0. This is an informational message only. No user action is required.
2011-07-10 22:46:04.14 spid57 Changing the status to PAUSE for full-text catalog "Catalog_DB_SALES" (12) in database "DB_SALES_2" (8). This is an informational message only. No user action is required.
2011-07-11 15:52:54.89 spid63 Informational: Full-text Full population for table or indexed view '[DB_SALES_2].[dbo].[tbl_Products]' (table or indexed view ID '146815585', database ID '8') was cancelled by user.
July 11, 2011 at 1:35 pm
July 11, 2011 at 1:48 pm
this seems to relate to internet access which is not our issue.
It started a number of weeks ago, but can't link it to anything on the server. It's pretty much sat there doing it's job then stopped. Certainly no database or system changes. possibly some updates.
July 16, 2011 at 1:25 pm
I've still not got any further with this despite reinstalling SQL Server and the indexing service, dropping the table and catalog/index and recreating everything it still hangs up.
July 18, 2011 at 5:45 pm
This seems to be the cause but as yet no resolution :
The component 'MSFTE.DLL' reported error while indexing.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply