Troubleshooting guide for Azure SQL and Microsoft SQL Microsoft Graph connector
1. The following is a common error observed while configuring the connector, and its possible reasons.
Configuration step | Error message | Possible reasons |
---|---|---|
Full crawl | Error from database server: A transport level error has occurred when receiving results from the server. |
This error arises due to network issues. It is recommended to check network logs using Microsoft network monitor and reach out to Microsoft customer support. |
Full crawl | Column column_name returned from full crawl SQL query contains non-alphanumeric character |
Nonalphanumeric characters (like underscores) are not allowed in column names in SELECT clause. Use aliases to rename columns and remove nonalphanumeric characters (Example - SELECT column_name AS columnName). |
If you have any other issues or want to provide feedback, write to us aka.ms/TalkToGraphConnectors.