本文介绍了ADF复制数据问题 - Filepath中的动态内容导致错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

嗨!我是新来的,对ADF来说相当新。我已经调试了这个过程一段时间了,在网上找不到一个好的答案。 

Hi! I'm new here and fairly new to ADF. I've been debugging this process for some time now, and can't find a great answer anywhere online. 

我是尝试在Azure Data Factory v2中创建一个简单的流程,该流程将转储到Azure Data Lake Storage上的文件路径中的任何文件移动:    FILES / RAW / 2019/04/30 NBSP;    (注意此文件路径的年,月,日格式)。

I'm attempting to create a simple process in Azure Data Factory v2 which moves any files dumped into a filepath on the Azure Data Lake Storage:    FILES/RAW/2019/04/30     (notice the year, month, day format of this filepath).

文件已压缩,未知数量的具有多种文件名的压缩文件可以放入新的文件路径,每天。

The files are zipped, and an unknown number of zipped files with a large variety of filenames can be dropped into a new filepath, each day.

为了解决这个问题,我创建了一个动态内容文件路径,其中包含一个文件  通配符之类似:

To account for this, I created a dynamic content filepath with a file wildcard like such:

FILEPATH: FILES / RAW / @ {formatDateTime(utcnow(),'yyyy')} / @ {formatDateTime(utcnow(),'mm)} / @ {formatDateTime(utcnow(),'dd')}

FILEPATH: FILES/RAW/@{formatDateTime(utcnow(),'yyyy')}/@{formatDateTime(utcnow(),'mm)}/@{formatDateTime(utcnow(),'dd')}

文件: / * .zip

我会收到错误,虽然,它说:

I will get an error, though, which says:




活动TrevorTestCopy失败:失败发生在'来源'一侧。 ErrorCode = UserErrorFileNotFound,'Type = Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message =找不到& Azure Data Lake Store&文件。 。服务请求
id:60c91605-c9ce-4fd7-b1d3-f899946097ac响应详情:{" RemoteException":{" exception":" FileNotFoundException"," message":" 文件/文件夹不存在:/ FILES / RAW / 2019/57/30 [60c91605-c9ce-4fd7-b1d3-f899946097ac] [2019-04-30T13:57:17.7239117-07:00] " ," javaClassName":" java.io.FileNotFoundException"}},Source = Microsoft.DataTransfer.ClientLibrary,''Type = System.Net.WebException,Message =
远程服务器返回了错误:(404)未找到。,来源=系统,'

Activity TrevorTestCopy failed: Failure happened on 'Source' side. ErrorCode=UserErrorFileNotFound,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot find the 'Azure Data Lake Store' file. . Service request id: 60c91605-c9ce-4fd7-b1d3-f899946097ac Response details: {"RemoteException":{"exception":"FileNotFoundException","message":"File/Folder does not exist: /FILES/RAW/2019/57/30 [60c91605-c9ce-4fd7-b1d3-f899946097ac][2019-04-30T13:57:17.7239117-07:00]","javaClassName":"java.io.FileNotFoundException"}},Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (404) Not Found.,Source=System,'

为什么动态内容会创建如下文件路径:FILES / RAW / 2019/57/30 [serial] [serial]? 

Why would the dynamic content be creating a filepath like: FILES/RAW/2019/57/30 [serial][serial]? 

序列号是否属于输出? 

Are the serial numbers part of the output? 

我应该为此使用更好的解决方案吗? 

Is there a better solution I should be using for this? 

谢谢! 

推荐答案

@ {formatDateTime(utcnow(),' mm )}

@{formatDateTime(utcnow(),'mm)}

到 

to 

@ {formatDateTime(utcnow(),' MM )}

@{formatDateTime(utcnow(),'MM)}

应该
解决问题 

should fix the issue 


这篇关于ADF复制数据问题 - Filepath中的动态内容导致错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-30 13:45