SQL 2005 full-text search not working

[henriqueo]

Hi, I have a W2003 R2 x64 clustered environment and in the cluster running a SQL Server 2005 x32. Trying to make full-text to work but the item count fails.

The SQL FT crawl log shows over and over again

Error '0x80070003' occurred during full-text index population for table or indexed view '[DLI_STORE_productcatalog].[dbo].[StoreMaster_CatalogProducts]' (table or indexed view ID '1430296155', database ID '7'), full-text key value 0x00001D26. Attempt will be made to reindex it.
2009-05-11 21:49:23.12 spid25s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2009-05-11 21:49:23.12 spid25s Error '0x80070003' occurred during full-text index population for table or indexed view '[DLI_STORE_productcatalog].[dbo].[StoreMaster_CatalogProducts]' (table or indexed view ID '1430296155', database ID '7'), full-text key value 0x00001D24. Attempt will be made to reindex it.
2009-05-11 21:49:23.12 spid25s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2009-05-11 21:49:23.12 spid25s Error '0x80070003' occurred during full-text index population for table or indexed view '[DLI_STORE_productcatalog].[dbo].[StoreMaster_CatalogProducts]' (table or indexed view ID '1430296155', database ID '7'), full-text key value 0x00001D28. Attempt will be made to reindex it.
2009-05-11 21:49:23.12 spid25s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2009-05-11 21:49:23.12 spid25s Error '0x80070003' occurred during full-text index population for table or indexed view '[DLI_STORE_productcatalog].[dbo].[StoreMaster_CatalogProducts]' (table or indexed view ID '1430296155', database ID '7'), full-text key value 0x00001D27. Attempt will be made to reindex it.
2009-05-11 21:49:23.12 spid25s The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2009-05-11 21:49:23.12 spid25s Informational: Full-text retry pass of Full population completed for table or indexed view '[DLI_STORE_productcatalog].[dbo].[StoreMaster_CatalogProducts]' (table or indexed view ID '1430296155', database ID '7'). Number of retry documents processed: 2320. Number of documents failed: 2320.
2009-05-11 21:49:23.12 spid25s Changing the status to MERGE for full-text catalog "StoreMaster" (6) in database "DLI_STORE_productcatalog" (7). This is an informational message only. No user action is required.

Searched everywhere but with no success.

Any help would be welcome
Henrique Oliveira

 

[hmckillop]

Hello

Just a few questions,
what sql server pack do you have - SELECT @@VERSION in a query window. ( i have vague recollection that there was a known error in SQL for full text indexing and specific characters in the data being indexed)

How much data do you have - can you provide samples?



"I'm living so far beyond my income that we may almost be said to be living apart

 

[henriqueo]

Hi,

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2).

Even in a simple DB with one table and three columns, with 2 ou 3 characters in each throws the same errors in the FT carwl log.