Data Factory V2错误"errorCode":"2200"，"message":"Sink"侧发生故障. [英] Data Factory V2 Error "errorCode": "2200", "message": "Failure happened on 'Sink' side.
问题描述
我将以下内容用作研讨会
Im using the following as a workshop
https://www.youtube.com/watch?v=IAqJ6nCDtGc
https://www.youtube.com/watch?v=IAqJ6nCDtGc
我在Azure SQL数据库(而不是本地数据库)中有一些销售数据
I have some sales data in an Azure SQL Database (Rather than an on premise database)
我有一个数据湖
我已经成功设置了连接器和数据集
Ive successfully set up the Connectors and Data sets
我已经根据上述视频创建了具有复制活动的管道
Ive created the pipeline with a copy activity as per the above video
当我运行它时，我得到以下信息
When I run it I get the following
{"errorCode":"2200" ，消息":在接收器"侧发生故障. ErrorCode = UserErrorFailedFileOperation，'Type = Microsoft.DataTransfer.Common.Shared.HybridDeliveryException，Message = The 对未知"的请求失败，状态代码为"BadRequest"，请求ID为". <！DOCTYPE HTML PUBLIC \-//W3C//DTD HTML 4.01//EN \" \; http://www.w3.org/TR/html4/strict.dtd \" \ r \ n< HTML>< HEAD>< TITLE>不良 请求</TITLE> \ r \ n< META HTTP-EQUIV = \"Content-Type \"内容= \" text/html; charset = us-ascii</HEAD> \ r \ n< BODY>< h2>错误请求-无效的URL</h2> \ r \ n< hr" p错误HTTP错误400.请求网址是 </p> \ r \ n</BODY></HTML> \ r \ n，Source = Microsoft.DataTransfer.ClientLibrary，''Type = System.Net.WebException，Message =远程服务器返回一个错误:(400)错误的请求.，源=系统，"，"failureType":"UserError"， 目标":将销售数据复制到数据湖" }
{ "errorCode": "2200", "message": "Failure happened on 'Sink' side. ErrorCode=UserErrorFailedFileOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The request to 'Unknown' failed and the status code is 'BadRequest', request id is ''. <!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\"\"http://www.w3.org/TR/html4/strict.dtd\">\r\n<HTML><HEAD><TITLE>Bad Request</TITLE>\r\n<META HTTP-EQUIV=\"Content-Type\" Content=\"text/html; charset=us-ascii\"></HEAD>\r\n<BODY><h2>Bad Request - Invalid URL</h2>\r\n<hr><p>HTTP Error 400. The request URL is invalid.</p>\r\n</BODY></HTML>\r\n ,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (400) Bad Request.,Source=System,'", "failureType": "UserError", "target": "Copy Sales data to data lake" }
这是我无法破解的第一个错误，我们将不胜感激.
This is the first error I havent been able to decipher, Any help would be really appreciated.
黛比
Debbie
推荐答案
Debbie，
Hi Debbie,
您是否尝试过ADL链接服务上的测试连接"按钮?您发布的错误中包含无效的URL引用，并且我能想到的唯一一个URL是ADL URL，它看起来像这样:
Did you try the 'Test connection' button on your ADL linked service? There is an invalid URL reference in the error you posted, and the only URL I can think of on the sink side is the ADL URL which looks like this:
"dataLakeStoreUri": "https://<account_name>.azuredatalakestore.net/webhdfs/v1",
即使网址格式错误，仍可以创建链接服务，但测试连接"不会成功.您可以通过查看链接服务的JSON配置代码来查看其URL.
The linked service will still be able to be created even if the URL is malformed, but the 'Test connection' should not succeed. You can view the URL in your linked service by looking at its JSON configuration code.
这篇关于Data Factory V2错误"errorCode":"2200"，"message":"Sink"侧发生故障.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
