Degraded index partition yellow warning

Degraded index partition yellow exclamation mark waring for sharepoint search index partition noticed. Sharepoint search correlation id error when user try to search. Yellow exclamation mark in sharepoint search Index partitioning warning indiactes towards search Index degraded.

Advertisements

You can run the command below to find index partition status.

$SearchServiceApplication = Get-SPEnterpriseSearchServiceApplication
Get-SPEnterpriseSearchStatus -SearchApplication $SearchServiceApplication -Text
search index partition yellow warning
Advertisements

You can follow the blog below to find and analyze log based on the correlation id error you got while searching in sharepoint site.

Advertisements

Stopped crawling that were running and waited to check the status of index partition yellow exclamation mark waring. Wait for some time and check the index partition status.

Cleared config cache following the steps mentioned in blog below and then rebooted search server.

Advertisements

Restarted windows search services like SharePoint Search Host Controller and SharePoint Server Search 16 following steps below.

net stop SPSearchHostController
net start SPSearchHostController
net stop OSearch16
net start OSearch16
Advertisements

Open SharePoint Central Admin and click on Application Management from left navigation. Under Service Application click on Manage services on server. Identify the service SharePoint Server Search and click on Restart. If SharePoint Server Search stuck on Stopping state then follow the blog below to reprovision sharepoint search service.

Advertisements

Check event logs. If you are getting error with properties as below.

Event ID: 45
Task Category: Index Lookup
Description: Query2-78786d46-hd02-5b20-a3bd-e87sf943: Index lookup failed to work since no active index cell was available

Event ID: 283
Task category: Document Parsing
Description: Excel generic Format Handler failed to parse with exception: Max output size of 2000000 has been reached while parsing

Event ID: 169
Task category: SP index related tasks
Description: System Index2-94638-sb04-3b50-c3bd-b47be55cd877. Index system SPd92d9d4227cb. Invalidating index cell I.0.1

Advertisements

The above event logs give more confirmation that sharepoint search index corrupt. Finally do search index reset. Degraded index partition yellow warning will be resolved. You can follow the steps below to do search index reset.

Advertisements

Restart SharePoint Search Host Controller service.

net stop SPSearchHostController
net start SPSearchHostController

Degraded index partition yellow exclamation mark waring is resolved. Start full crawling of all content sources.

Advertisements
Advertisements

Reprovision sharepoint search service

Reprovision sharepoint server search service when there is a situation where you find status of sharepoint server search service in stopping state. When there is an issue in search service application and its component due to which sharepoint search is not working. You need to restart service sharepoint server search. While restart, you find the sharepoint server search service stuck stopping state. In that case this post is helpful.

Advertisements

Restart sharepoint server search service

Run below script to restart or reprovision sharepoint server search service.

Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
$SearchServiceInstance = Get-SPEnterpriseSearchServiceInstance -Identity "WIN-Q2REPGHF9DU"
Start-SPEnterpriseSearchServiceInstance -identity $SearchServiceInstance # Wait for search service instance to come online
do {$online = Get-SPEnterpriseSearchServiceInstance -identity $SearchServiceInstance; Write-Host "Waiting for service: " $online.Status}
until ($online.Status -eq "Online")
Advertisements

Once script started running, you will find the details as seen in figure below.

sharepoint server search service status stopping
Advertisements

The service sharepoint server serach will be stopped first, then will chanage to state starating and finally will come to status as Started.

sharepoint server search service
Advertisements
Advertisements

reset search index all crawled content source in sharepoint 2019 powershell

reset search index in sharepoint 2019 for all crawled content source is a critical task. You know there are 6 search components like crawl component,content processing component,analytics processing component, index component, query processing component, search administration component in search topology. When user query something, results retrieving from index files. Administrator adds content source, crawling happens, indexing happening. In case of corrupt index , status of index component is degraded, search result not coming, sharepoint index partition yellow triangle appears, we have to perform this activity. We can follow UI method from search administration page for index reset but timeout error might come. We can use powershell command to clear indexed results for all crawled content source.

Advertisements

Pre-Index Reset Task

Before doing index reset, make sure below check points satisfying

  • Crawl status for content source is idle.
  • Crawler background activity status is none.
  • Disable crawl schedule otherwise. recent crawl rate should be 0 items per second.
  • Recent query rate should be 0 queries per minute
  • Administrative status should not be running. Suspend search service application if its running mode by running beow command.
Suspend-SPEnterpriseSearchServiceApplication "Search Service Application"
Advertisements
suspend search service application
crawl status is idle
crawl status disabled
Advertisements

Navigate to manage service application from central administrator in sharepoint 2019. Click on search service application, you will be redirected to search service application administrator page. validate the pre-index reset task checks.

index reset task search administration

After that, its good to proceed for reset indexing in sharepoint search.

Advertisements

Index Reset Task

We can do this by UI method or by using powershell command. let’s underatand both methos.

UI method from Search Administration Page

click on “Index reset” from left navigation.

index reset tasak search administration sharepoint 2019
Advertisements

Deactivate search alerts by selecting the checkbox to stop alerts. Its very important to diable alerts without any miss and click on “Reset Now” from searchreset page.

reset now
Advertisements

index files will be cleared, once process completed. Click on “Crawl log” and you will find last crawl field reset to “No data”. Crawl properties like successes, warnings, errors, top level errors, deletes reset to “0”.

crawl log in sharepoint server 2019

search index reset timeout might come in UI method, so better to use powershell command method.

Advertisements

Powershell command to reset search index

We can use powershell command to delete search index files for all crawled content source. Find below the powershell command.

(Get-SPEnterpriseSearchServiceApplication).reset($true, $true)
# $True: Disable Alerts and Ignore Timeout error
search index reset using powershell in sharepoint 2019 on-premises
Advertisements

Post-Index Reset Task

After clearing or resetting search index, always have to start full crawl for the content source. Click on “Content sources” from left navigation. Click on the drop down option for the content source and select “Start Full Crawl”

start full crawl content sources search in sharepoint server 2019

follow the vide below, to know step by step procedure in video format for better understanding.

Advertisements
Advertisements
Advertisements