Azure AI Search
An Azure search service with built-in artificial intelligence capabilities that enrich information to help identify and explore relevant content at scale.
1,225 questions
Azure AI Search - Indexer Error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 87%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Lyncheese
105
Reputation points
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 ?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 59%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SnehaAgrawal-MSFT 22,346 Reputation points2024-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 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 ?
- Verify that the SQL query used to retrieve data from your data source is correctly formatted and returns the expected results.
Sign in to comment
Sign in to answer