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

add server to farm in sharepoint

You need to add server to farm in sharepoint, then follow the step by step below. Let’s say, there is some issue due to which you disconnected web front-end server from sharepoint farm. Once issue resolved, you need to join web front-end server to farm again. In that case follow the step by step below.

Advertisements
  • Open the web front-end server which is disconnected from sharepoint farm or you need to join server to farm.
  • Click on sharepoint product configuration wizard from Start.
  • Click on Next from the dialog opened.
sharepoint-products-configuration-wizard
sharepoint products configuration wizard
Advertisements
  • You will get additional dialog box which will inform the services may have to be started or reset during configuration. You see internet information services, sharepoint administration service, sharepoint timer service will be restarted during this config wizard run. Click on Yes.
services started or reset
services started or reset
Advertisements
  • You will get a dialog connect to a server farm with options like connect to an existing server farm and create a new farm. Select the option Connect to an existing farm and click on Next.
  • You may skip to next step to enter details like Database server name and Database name.
  • Enter Database server name and click on Retrieve Database names. Config database will be auto populated in the field Database name.
specify-configuration-database-settings
specify configuration database settings
Advertisements

In the next dialog Specify Farm Security Settings, enter passphrase and click on Next.

enter passphrase
enter passphrase
Advertisements

Next you need to Specify a Server Role since minrole is implemented in sharepoint 2019. Select Front-end server present under Dedicated Roles and click on Next.

specify server role from dedicated roles
specify server role
Advertisements

Verify details like Configuration Database Server, Configuration Database Name, Local Server Role and click on Next.

Complete-products-configuration-wizard
Advertisements

Running Configuration Wizard will start.

configuring-sharepoint-products
configuring sharepoint products started
Advertisements

Once all tasks in Configuration Wizard completed, you will get message on the same. Click on Finish. Central admin page will open.

add-server-to-farm-successful
add server to farm successful
Advertisements

Start site in IIS

Once server is added, you need to start site from IIS.

  • Open Internet Information Services (IIS) Manager from start.
  • You will find the status of site/sites as stopped state.
  • Select the site which is stopped state and click on Start from Action pane.
start website iis
Advertisements

Check site binding

Once site is in started state, you need to check the site binding.

  • Select the site and right click on it.
  • Click on Edit Bindings.
  • Verify the binding. It should be proper and certificate should be applied on it.
Advertisements
Advertisements