Sitecore - issue while checking xDB index rebuild status with Azure Search Explorer

Posted 4 Dec 2023 by Marek Musielak

If, by any chance, you still need to support older Sitecore versions and Azure Search, you may be unpleasantly surprised to find that Azure Search queries, used for checking the status of rebuilding the xDB index as mentioned on the Sitecore documentation website, no longer work in Azure Search Explorer.

I was trying to use the queries from Sitecore documentation - Rebuild the xDB index in Azure Search but both:

$filter=id eq 'indexconfiguration'&$select=id,isactivecore

and

$filter=id eq 'xdb-rebuild-status'&$select=id,rebuildstate

returned empty table:

I searched online and found this article Query stopped working on Azure Cognitive Search Index. It appears that there have been some changes to Azure Search Explorer, which have resulted in queries not working as they used to.

So how to check now which core is an active one and what is the status of rebuilding the Sitecore xDB index in Azure Search now? Instead of using Query view, switch to JSON view and use the following JSON queries:

{
 "search": "*",
 "filter": "id eq 'indexconfiguration'",
 "select": "id, isactivecore"
}

{
 "search": "*",
 "filter": "id eq 'xdb-rebuild-status'",
 "select": "id, rebuildstate"
}