Question

Raj Yendluri on Fri, 17 Aug 2018 09:13:57


We have attachments table and a full-text index. The index was worked properly in 2008R2 SQL server. But Recently we upgraded to 2012 sp4 and couple new columns are added to the attachment table. We had to rebuild the indexes, But we are getting the error and index population is stopped. 

Below site shows temp fix was given in 2012 sp3. We are already on 2012 sp4. 

After you install this update and SQL Server indexes documents that are too large for Full-Text Search indexing, the documents are skipped, and SQL Server generates an error message resembling the following in the Full-Text Search error log instead of throwing exceptions and generating file dumps. 

https://support.microsoft.com/en-in/help/3208276/update-improves-handling-of-documents-too-large-for-full-text-search-i

Our documents are not that much large.

Does anyone know why this error occurs?

spid39s     Error '0x8004fd0a: Occurrence counter overflow, document is not indexed.' occurred during full-text index population for table or indexed view '[RedAlerts].[dbo].[ResearchAttachments]' (table or indexed view ID '2126630619', database ID '6'), full-text key value 'A58B67C0-DE55-4F21-88AE-0013FF1C8AD0'. Failed to index the row.

2018-08-16 12:58:11.15 spid39s     Error '0x8004362f: A previous error prevented further processing of the batch.' occurred during full-text index population for table or indexed view '[RedAlerts].[dbo].[ResearchAttachments]' (table or indexed view ID '2126630619', database ID '6'), full-text key value 'C891D712-6FC8-4F38-AAD1-000110901958'. Attempt will be made to reindex it.

2018-08-16 12:58:11.15 spid39s     Error '0x8004362f: A previous error prevented further processing of the batch.' occurred during full-text index population for table or indexed view '[RedAlerts].[dbo].[ResearchAttachments]' (table or indexed view ID '2126630619', database ID '6'), full-text key value '1398FD3D-04FC-47E4-B77B-0001FDED3F7C'. Attempt will be made to reindex it.

2018-08-16 12:58:11.15 spid39s     Error '0x8004362f: A previous error prevented further processing of the batch.' occurred during full-text index population for table or indexed view '[RedAlerts].[dbo].[ResearchAttachments]' (table or indexed view ID '2126630619', database ID '6'), full-text key value '6AC3AECD-9292-488F-B2C0-000239D487B5'. Attempt will be made to reindex it.