现有Data Factory管道的连接问题 [英] Connectivity issues with existing Data Factory pipelines

问题描述

管道/步骤以前可以正常运行，现在出现此错误:

Pipeline / steps previously worked and now get this error:

{"errorCode":"2200"，"message":失败发生在源"端. 'Type = System.Data.SqlClient.SqlException，Message =找不到对象 因为它不存在或您没有权限.，Source = .Net SqlClient数据提供程序，SqlErrorNumber = 1088，Class = 16，ErrorCode = -2146232060，State = 7，Errors = [{{Class = 16，Number = 1088，状态= 7，消息=找不到对象\"PlanInfo \".因为它 }，]，]，"，"failureType":"UserError"，"target":"Copy Data1" }

{ "errorCode": "2200", "message": "Failure happened on 'Source' side. 'Type=System.Data.SqlClient.SqlException,Message=Cannot find the object \"PlanInfo\" because it does not exist or you do not have permissions.,Source=.Net SqlClient Data Provider,SqlErrorNumber=1088,Class=16,ErrorCode=-2146232060,State=7,Errors=[{Class=16,Number=1088,State=7,Message=Cannot find the object \"PlanInfo\" because it does not exist or you do not have permissions.,},],'", "failureType": "UserError", "target": "Copy Data1" }

该对象确实存在，并且权限很好.我进去并编辑了现有管道，并测试了连接/查看了示例数据，没有任何问题.但是当我运行管道时(通过触发器或调试) 我收到此失败响应.

The object does exist and permissions are fine.  I went in and edited the existing pipeline and tested connections/viewed sample data without any issues.  But when I run the pipeline (either via trigger or via debug) I get this failure response.

推荐答案

要确认，是否有最近对管道进行了更改?

To confirm, are there any changes made to the pipeline recently?

您可以检查

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

这篇关于现有Data Factory管道的连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！