[source-mssql] Syncs fail with invalid timeout string (works in 4.2.6)
- 主要语言
- Python
- 星标
- 22.1k
- 派生
- 5.3k
- PR 合并指标
- PR 指标待抓取
描述
### Connector Name
source-mssql
### Connector Version
4.3.3
### What step the error happened?
During the sync
### Relevant information
Effectively when using newer versions, I can't sync to certain servers. I can run a connection check just fine, but then the sync fails to start and throws one of these two forms of the same error:
```
ERROR main i.a.c.AirbyteConnectorRunnable(run):38 Failed class io.airbyte.cdk.discover.DiscoverOperation operation execution. com.microsoft.sqlserver.jdbc.SQLServerException: The timeout 300;socketTimeout=0;cancelQueryTimeout=0 is not valid.
```
. . . or this one (which seems to happen on subsequent attempts):
```
ERROR Failing job: 923287, reason: Could not connect with provided configuration. Error: Message: The timeout 300;socketTimeout=0;cancelQueryTimeout=0 is not valid.
```
Regardless it appears that the issue is the timeout value being provided being malformed. I'm not certain if this is specific to SQL server version, as I've seen failures on several different connections to various third-party SQL servers (some of which I don't know the version of).
I've had to pin my connector version to `4.2.6` due to this issue, in which case the sync completes just fine.
### Relevant log output
```shell
ERROR main i.a.c.AirbyteConnectorRunnable(run):38 Failed class io.airbyte.cdk.discover.DiscoverOperation operation execution. com.microsoft.sqlserver.jdbc.SQLServerException: The timeout 300;socketTimeout=0;cancelQueryTimeout=0 is not valid.
```
### Contribute
- [ ] Yes, I want to contribute
---
**Internal Tracking:** https://github.com/airbytehq/oncall/issues/11187
贡献指南
评估
这个 Issue 还没有评估数据。