SQL 2005 full-text catalog error

• Eric W. Bowers

  SSC Rookie

  Points: 36

  More actions

  June 8, 2007 at 7:15 am

  #173981

  I need to create a new full-text catalog on a SQL2005 SP2 database running on Windows 2000 SP4 with a few tables containing nvarchar text fields.

  SQL Server will not populate the full-text catalog. I added one indexed view to a new catalog and tried to rebuild the catalog. MSSQLSERVER generates Event ID 7683, which points me to the full-text crawl log for details.

  For each record in the indexed view, two lines are generated in the crawl log:

  Error '0x80070003' occurred during full-text index population for table or indexed view '[hrdb].[dbo].[vw_ftProfileGoals]' (table or indexed view ID '1918629878', database ID '16'), full-text key value 0x620075007900200061002000630061007200. Attempt will be made to reindex it.

  The component 'MSFTE.DLL' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.

  This is identical to a posting on the Microsoft TechNet site:

  http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1680008&SiteID=17

  Other Googling and MSKB'ing yielded no solutions. This is not a data-specific problem, because I created a new database, a new table, populated it, and tried the same steps with identical results.

  If you can help me solve it, there are 500 points waiting for you at Experts Exchange.

  http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_22613880.html