数据工厂触发器失败，因为它无法找到Blob存储，但调试正常 [英] Data Factory Trigger Fails because it cant find blob storage but Debug Works Fine

问题描述

我当前遇到错误

活动Copycsvtosqldb失败:"Source"上发生了失败边. ErrorCode = UserErrorSourceBlobNotExist，'Type = Microsoft.DataTransfer.Common.Shared.HybridDeliveryException，消息= 必需的Blob丢失. ContainerName: https://twitterstoragev2.blob.core.windows.net/twitteranalyticsfiles

Activity Copycsvtosqldb failed: Failure happened on 'Source' side. ErrorCode=UserErrorSourceBlobNotExist,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The required Blob is missing. ContainerName: https://twitterstoragev2.blob.core.windows.net/twitteranalyticsfiles,; ContainerExist: True, BlobPrefix: , BlobCount: 0.,Source=Microsoft.DataTransfer.ClientLibrary,'

I pull through files from my blob storage, Ive checked the Linked Services and this seems fine. When I debug there are no issues. I cant currently understand why the trigger fails when it works on a Friday night

还有什么我可以看的，以尝试并使事情正常工作

Is there anything else I can look at to try and get things working

Debbie

推荐答案

Debbie，

Hi Debbie,

这可能是由于以下原因.

This could be possibly due to the below reasons.

->   这是由于复制运行时源blob文件不存在引起的.请注意，文件名区分大小写.

->  It is caused by the source blob files don't exist when copy runs. Notice that the file name is case sensitive.

检查一次folderPath或fileName，如果指定不正确，则进行相应更改.

 Check the folderPath or fileName once and change accordingly if it is specified incorrectly.

->   如果您要复制一个空文件夹(未设置文件名)，则复制"活动也会引发此类错误.您可以在UX的代码页中指定以下内部属性:

->  If you are copying an empty folder (without setting file name), Copy activity would throw such error as well. You can specify the following internal property in the UX's code page:

在复制活动中单击代码"页面. (请参阅以下屏幕截图)

Click the Code page in the copy activity. (Refer to the following screen shot)

在代码页中添加以下设置.

Add the following setting in the code page.

"source": { 
                        "type": "BlobSource", 
                        "recursive": true, 
                        "throwExceptionWhenNavigateEmptyFolder": false 
                    }, 
 

这篇关于数据工厂触发器失败，因为它无法找到Blob存储，但调试正常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！