This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 20%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Hi,
A copy activity is configured to extract data from the DataLake to the first layer in Synapse. The activity is set up with PolyBase in Sink side with staging funcionality due to the load was set up with Wildcard file path.
COPY ACTIVITY CONFIGURATION:
Due to there are not new data in the delta, load files are 0 , in that case no data is added in BlobStorage (Staging) and the process is [SUCCEEDED] , but then when the activity try to copy the data from BlobStorage (Staging) to Synapse the result is [FAIL]. And the error is the following one.
Operation on target CopyActivity1 failed: ErrorCode=UserErrorSourceBlobNotExist,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The required Blob is missing. Folder path: stagingpolybasetmp/8166f184-a2c6-4c57-a078-981d2d31a53f/Polybase/.,Source=Microsoft.DataTransfer.ClientLibrary,'
NOTE: The process is OK if there are delta data.
Does anyone know what is happening and could you tell me the possible solution?
Thank you in advance,
MG
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Hello @MaGr-4043 and welcome to Microsoft Q&A. Thank you for the implementation details.
I am working to reproduce the issue.
I have a hunch it has to do with the particular expectations of polybase.
Do you still run into the issue when staging is disabled?
Do you still run into the issue when, instead of using polybase, you use bulk insert of copy command?
Hi MartinJaffer-MSFT,
Thank you for your interest in this topic.
This issue only appears when PolyBase copy is enable, there are no problems for bulk insert. According Polybase mandatory set up for Wildcard file path loads, the configuration have to be set up with staging option.
SOLVED
A Metadata activity and If avtivity was added in the pipeline in order to execute or not the copy activity.
It is very odd to do that. It should be correct in future versions, because of is an usual behaivour to have no data in a delta extractions.
If expression: @hamed1374 (empty(activity('New Data File').output.childItems))
Thank you for sharing your solution with the community, @MaGr . Much appreciated!