CODEWITHSUNDEEP
azure-cognitive-search
Zekokhan
Zekokhan

Reputation: 203

Azure Search Index Indexer Issues

We are seeing some issues with our indexer throwing an error every other time it tries to run the indexer on our data-source. Our indexer runs on a schedule and we have Sql server "Change Tracking" turned ON for db and the table that we use for indexing. The indexer runs successfully every other time which is strange. I will attach a picture to show you the indexer status page. The odd thing is it shows an error saying:

"Indexing was stopped because the data source has no change detection policy and corresponding quota of 100000 documents has been reached. To index more documents please add a change detection policy".

So like I mentioned we have the "Change detection policy" set (Change Tracking is ON) and indexer running on a schedule. And it works every other time. We are on a "standard" billing tier so we do not have a quota "100000". We believe that this error might also be contributing to our counts in the index data-source and index table not to match. The indexer is NOT deleting the ID that have been removed from our source table.

I have attached an image to show the status page of our indexer. Please help! We have launched our search and are seeing issues pretty late in the game.

Thanks in advance and let me know if you need any more info.

embedded image

Upvotes: 1

Views: 2535

Answers (1)

Eugene Shvets
Eugene Shvets

Reputation: 4671

It's not enough to enable change tracking on the SQL side. You also need to set up an Integrated Change Tracking policy on your Azure Search datasource. This is described in the documentation

Upvotes: 0

Related Questions