问题描述
嗨!我是新来的,对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中的动态内容导致错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!