Re: error populating full text index.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I take it you have 8 rows in this table. Are you indexing any binary documents?

It might be possible that there is some locking going on which is causing SQL FTS to be unable to access these docs. Can you try to query the base table and do dummy updates to check for locking? IE update TableName set Col1=Col1?

"Bob Hetzel" <BobHetzel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:61CA1BC2-4D34-4011-91AB-29B2D94F6876@xxxxxxxxxxxxxxxx

I'm trying to populate a full text index on a database but I'm having some
troubles.
I've tried re-creating the index, re-populating it fully, and even
incrementally all to no avail. The full text catalog for this table still
says the item count is 0. Can anybody shed some light on this?

Here's what gets logged in the log directory on the database server...

2008-06-17 22:56:17.23 spid20s Informational: Full-text Full population
initialized for table or indexed view '[FacultyAff].[dbo].[Keywords]' (table
or indexed view ID '1222295414', database ID '28'). Population sub-tasks: 1.
2008-06-17 22:56:18.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323235343137303334. Attempt will be
made to reindex it.
2008-06-17 22:56:18.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:18.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x333031363636343033. Attempt will be
made to reindex it.
2008-06-17 22:56:18.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:18.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323838343430383839. Attempt will be
made to reindex it.
2008-06-17 22:56:18.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:18.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323838303835383735. Attempt will be
made to reindex it.
2008-06-17 22:56:18.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:18.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323930353633393539. Attempt will be
made to reindex it.
2008-06-17 22:56:18.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:18.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x353331383238303135. Attempt will be
made to reindex it.
2008-06-17 22:56:18.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:18.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x343937313139393037. Attempt will be
made to reindex it.
2008-06-17 22:56:18.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:18.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323939343033303339. Attempt will be
made to reindex it.
2008-06-17 22:56:18.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:18.23 spid20s Informational: Full-text Full population
completed for table or indexed view '[FacultyAff].[dbo].[Keywords]' (table or
indexed view ID '1222295414', database ID '28'). Number of documents
processed: 8. Number of documents failed: 0. Number of documents need retry:
8.
2008-06-17 22:56:19.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323235343137303334. Attempt will be
made to reindex it.
2008-06-17 22:56:19.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:19.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323838303835383735. Attempt will be
made to reindex it.
2008-06-17 22:56:19.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:19.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323838343430383839. Attempt will be
made to reindex it.
2008-06-17 22:56:19.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:19.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323930353633393539. Attempt will be
made to reindex it.
2008-06-17 22:56:19.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:19.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x333031363636343033. Attempt will be
made to reindex it.
2008-06-17 22:56:19.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:19.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x343937313139393037. Attempt will be
made to reindex it.
2008-06-17 22:56:19.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:19.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x353331383238303135. Attempt will be
made to reindex it.
2008-06-17 22:56:19.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:19.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323939343033303339. Attempt will be
made to reindex it.
2008-06-17 22:56:19.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:19.23 spid20s Informational: Full-text retry pass of
Full population completed for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'). Number of retry documents processed: 8. Number of
documents failed: 0.
2008-06-17 22:56:20.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323235343137303334. Attempt will be
made to reindex it.
2008-06-17 22:56:20.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:20.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323838303835383735. Attempt will be
made to reindex it.
2008-06-17 22:56:20.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:20.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323838343430383839. Attempt will be
made to reindex it.
2008-06-17 22:56:20.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:20.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323930353633393539. Attempt will be
made to reindex it.
2008-06-17 22:56:20.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:20.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x333031363636343033. Attempt will be
made to reindex it.
2008-06-17 22:56:20.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:20.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x353331383238303135. Attempt will be
made to reindex it.
2008-06-17 22:56:20.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:20.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323939343033303339. Attempt will be
made to reindex it.
2008-06-17 22:56:20.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:20.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x343937313139393037. Attempt will be
made to reindex it.
2008-06-17 22:56:20.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:20.23 spid20s Informational: Full-text retry pass of
Full population completed for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'). Number of retry documents processed: 8. Number of
documents failed: 0.
2008-06-17 22:56:21.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323235343137303334. Attempt will be
made to reindex it.
2008-06-17 22:56:21.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:21.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323838303835383735. Attempt will be
made to reindex it.
2008-06-17 22:56:21.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:21.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323838343430383839. Attempt will be
made to reindex it.
2008-06-17 22:56:21.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:21.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323939343033303339. Attempt will be
made to reindex it.
2008-06-17 22:56:21.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:21.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x333031363636343033. Attempt will be
made to reindex it.
2008-06-17 22:56:21.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:21.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x323930353633393539. Attempt will be
made to reindex it.
2008-06-17 22:56:21.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:21.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x353331383238303135. Attempt will be
made to reindex it.
2008-06-17 22:56:21.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:21.23 spid20s Error '0x80070003' occurred during
full-text index population for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'), full-text key value 0x343937313139393037. Attempt will be
made to reindex it.
2008-06-17 22:56:21.23 spid20s The component 'MSFTE.DLL' reported error
while indexing. Component path 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2008-06-17 22:56:21.23 spid20s Informational: Full-text retry pass of
Full population completed for table or indexed view
'[FacultyAff].[dbo].[Keywords]' (table or indexed view ID '1222295414',
database ID '28'). Number of retry documents processed: 8. Number of
documents failed: 8.
2008-06-17 22:56:21.23 spid20s Changing the status to MERGE for
full-text catalog "keywords_ftcat" (9) in database "FacultyAff" (28). This is
an informational message only. No user action is required.


.

Relevant Pages