Hi I am trying to fetch schemas from MSSQL 0.4.24 ...
# replication-troubleshooting
c
Hi I am trying to fetch schemas from MSSQL 0.4.24 connection which is Azure Synapse and get the following message taken from the logs:
Copy code
2022-10-27 21:25:11 [32mINFO[m i.a.p.j.e.LoggingJobErrorReportingClient(reportJobFailureReason):23 - Report Job Error -> workspaceId: 28f8bfd5-ac55-4717-812f-1152ebf0eed2, dockerImage: airbyte/source-mssql:0.4.24, failureReason: io.airbyte.config.FailureReason@269e6540[failureOrigin=<null>,failureType=system_error,internalMessage=com.microsoft.sqlserver.jdbc.SQLServerException: Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.,externalMessage=Something went wrong in the connector. See the logs for more details.,metadata=io.airbyte.config.Metadata@5c3bff1d[additionalProperties={attemptNumber=null, jobId=null, from_trace_message=true, connector_command=discover}],stacktrace=com.microsoft.sqlserver.jdbc.SQLServerException: Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.
s
Hello, can you please include the full sync log? Also, which airbyte version are you running?
Possibly related to this issue, if you think it is please leave a comment and thumbs up to help with prioritization: https://github.com/airbytehq/airbyte/issues/4546