Azure AI Search - Indexer Error

Question

Azure AI Search - Indexer Error

Lyncheese 105

I have datasource with azuresql type.

I run indexer with that datasource and I got this error

Message: Could not read document.

Details: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

I tried to read below link, but there is no explanation about the error with same detail I had:
https://learn.microsoft.com/en-us/azure/search/cognitive-search-common-errors-warnings#could-not-read-document

How to debug this kind of problem ?

SnehaAgrawal-MSFT 22,721 Reputation points Moderator

2024-02-17T00:57:50.0466667+00:00
@Lyncheese It seems like you are encountering an error while running an indexer on your Azure SQL data source. The error message you provided indicates that the indexer was not able to read a document due to a subquery returning more than one value.

Based on the information you provided, it is difficult to determine the exact cause of the error. However, there are a few things you can check to help diagnose the issue:

Check the field mappings in your indexer to ensure that they are correctly configured to map the fields in your SQL data source to the fields in your search index.

Verify that the SQL query used to retrieve data from your data source is correctly formatted and returns the expected results.

Check if there are any duplicate records in your data source that could be causing the subquery to return more than one value.

Refer the similar discussion might be helpful-

If query remains please let us know.
Lyncheese 105 Reputation points

2024-02-19T08:33:09.6033333+00:00
@SnehaAgrawal-MSFT

Thank you for your response

Unfortunately, I'm not sure how to do your recommended diagnose step.
I have made quite numbers of Index, Indexer and Data Sources using Azure Portal.
Only this one data source has problem.

Verify that the SQL query used to retrieve data from your data source is correctly formatted and returns the expected results.

How do I checked this ? This one is indexer internal mechanism which I don't think can be accessed externally ?

Check the field mappings in your indexer to ensure that they are correctly configured to map the fields in your SQL data source to the fields in your search index.

There is no special field mapping needed for this. Just like other Index, I made.

Check if there are any duplicate records in your data source that could be causing the subquery to return more than one value.

Again. How do I know what kind of subquery that the indexer used to index ? Could you please let me know how to do that in more detail ?