Azure搜索索引器失败，并显示错误消息 [英] Azure search indexer failing with error message

问题描述

我的azure搜索索引器从带有更改跟踪的sql表中读取，但由于以下错误而失败

My azure search indexer which reads from an sql table with Change Tracking, is failing with the following error

"Unable to cast object of type 'Newtonsoft.Json.Linq.JObject' to type 'System.String'."

如果我重置索引器，它将开始正常工作.造成此问题的根本原因是什么?

If I reset the indexer, it'll start working fine. What is the root cause of the problem here?

推荐答案

我们已经发现使用SQL集成变更检测的SQL索引器中存在一个问题，该问题会影响极少数的客户.我们正在研究一个修复程序，该修复程序可能会在下周投入生产.我们还将改进遥测技术，以便能够主动识别此类问题.

We’ve identified an issue in SQL indexers that use SQL integrated change detection that affects a very small number of customers. We’re working on a fix, which will probably be deployed in production next week. We'll also improve our telemetry so that we'll be able to identify this class of issues proactively.

您已经使用的解决方法(重置索引器)是解决此问题的最佳方法.

The workaround you’ve already used (resetting the indexer) is the best workaround for this issue.

对不起，麻烦了！

这篇关于Azure搜索索引器失败，并显示错误消息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！