每天的管道故障:“源"侧的故障 [英] Pipeline failure on daily basis: Failure on 'Source' side

问题描述

大家好，

我有一个反复出现的问题，现在已经有几个星期了. Azure Data Factory中很少有预定的管道每天都会失败.它引发的错误消息:

I have a recurring issue for few weeks now. few scheduled pipelines in Azure Data Factory keeps on failing on daily basis. Error message it throws:

源"端发生了故障. '类型= Microsoft.DataTransfer.Common.Shared.HybridDeliveryException，消息= Odbc操作失败.，源= Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector，''类型= System.InvalidOperationException，消息= 连接已被禁用.，Source = System.Data，''Type = System.Data.Odbc.OdbcException，Message = ERROR [08S01] [Microsoft] [ODBC Oracle Wire Protocol驱动程序] [Oracle] Connection Dead.，Source = msora28 .dll，'

Failure happened on 'Source' side. 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Odbc Operation Failed.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.InvalidOperationException,Message=The connection has been disabled.,Source=System.Data,''Type=System.Data.Odbc.OdbcException,Message=ERROR [08S01] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead.,Source=msora28.dll,'

有关如何解决此问题的任何想法? (不过，手动触发器可以成功加载管道)

这是Azure复制自Oracle的查询和相关表

This is the query and the relevant table in Oracle that Azure copy from

在管道中查询:

来源DATE_TIME

谢谢！

推荐答案

对是否进行了任何更改管道?您的资源已部署在哪个区域?

Are there any changes made to the pipeline? In which region your resource has been deployed?

您可以检查

You can check Troubleshoot Data Factory issues and see if it helps to identify the root cause.

这篇关于每天的管道故障:“源"侧的故障的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！