You experience issues with portal alerts in SharePoint Portal Server 2003 or with search performance in SharePoint Server 2007 after you create SQL Server 2005 maintenance plans

Cause:
These issues occur because the Rebuild index task does not restore all the options that are set on the indexes that are used by SharePoint Portal Server 2003 or by SharePoint Server 2007 after indexes are rebuilt. The Ignore duplicate values option is turned off after indexes are rebuilt.

Symptoms:
SqlCrawl::ExecuteCommand fails Error 0x80040e2f
CGathererQueueManager::FlushQueue failed with recoverable error 0x80040e2f
CGathererFilterSink::CommitLinks : pGatherAddLink->AddLinkComplete error=0x80040e2f

Resolution:
Check Ignore Duplicate Values for this following indexes:
select [name], [type_desc], [is_unique], [ignore_dup_key] from sys.indexes where name in (‘IX_MSSAnchorChangeLog’, ‘IX_MSSAnchorPendingChangeLog’, ‘IX_MSSCrawlChangedSourceDocs’, ‘IX_MSSCrawlChangedTargetDocs’,’IX_MSSCrawledPropSamplesByDocid’,’IX_MSSCrawlErrorList_hrResult’, ‘IX_MSSCrawlHostList_Name’,’IX_MSSCrawlQueue’,’IX_MSSDocSdids’)
Result: ignore_dup_key must 1, fix accordingly if you encounter 0.

Link:
http://support.microsoft.com/kb/930887/en-us

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s