开发者社区 > 数据库 > 数据库管理工具 > 正文

数据传输DTS中sqlserver同步ods前缀报错,帮忙看看?

数据传输DTS中sqlserver同步ods前缀报错? CODE:-
错误概述:-
解决方案:-
帮助文档:-
详细报错信息:common: DTS-100047: retry 0 times, 5004 seconds, which exceed the supposed 43200 seconds
cause:
CriticalAnyAllException: dts-k-src: DTS-52111: Increment Context Is Not Running..:
CriticalAnyAllException: sqlserver-reader: DTS-52410: Sqlserver log fetch failed
CriticalAnyAllException: capture-sqlserver: DTS-52410: java.util.concurrent.ExecutionException: java.io.IOException: com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server returned an incomplete response. The connection has been closed.
IOException: java.util.concurrent.ExecutionException: java.io.IOException: com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server returned an incomplete response. The connection has been closed.
ExecutionException: java.io.IOException: com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server returned an incomplete response. The connection has been closed.
IOException: com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server returned an incomplete response. The connection has been closed.
SQLServerException: SQL Server returned an incomplete response. The connection has been closed.
【URL】:https://dtsnew.console.aliyun.com/sync/cn-hangzhou
【当前时间】:2024-01-31 08:39:29
【Region】:cn-hangzhou

【UID】:274039521239744232
【Job ID】:h9ns1qow314q8z7
【任务名称】:sqlserver同步ods前缀
【所有报错信息】:
CODE:-
错误概述:-
解决方案:-
帮助文档:-
详细报错信息:bisId【h9ns1qow314q8z7】run fail by 【创建或刷新Topic下reader信息】,errorMsg:Could not find any available broker. Check your NodeCommandClientConfig setting 'bootstrap.servers'. This error might also occur, if you try to connect to pre-0.10 brokers. Kafka Streams requires broker version 0.10.1.x or higher.
【URL】:https://dtsnew.console.aliyun.com/sync/detail/record/t85a6pin107f342
【当前时间】:2024-01-31 08:41:10
【Region】:cn-hangzhou

展开
收起
真的很搞笑 2024-02-08 12:04:46 48 0
1 条回答
写回答
取消 提交回答
  • 面对过去,不要迷离;面对未来,不必彷徨;活在今天,你只要把自己完全展示给别人看。

    检查网络连接是否正常,确保源数据库和目标数据库之间的网络通信畅通。同时,检查源数据库的防火墙设置,确保允许DTS服务访问。

    2024-02-17 08:29:01
    赞同 展开评论 打赏

阿里云提供了一系列数据库管理工具,可以满足您在云上进行数据库管理的各种需求。包含数据传输服务DTS、数据库备份 DBS、数据库自治服务 DAS、数据管理 DMS。

相关电子书

更多
DTS助力企业快速复制阿里巴巴异地多活架构 立即下载
蚂蚁聚宝虫洞项目技术方案介绍 ——云与端之间数据传输的桥梁 立即下载
DTS控制台一本通 立即下载