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, 99%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Hi,
We are facing the issue with while copying a file (comma delimited and with a file format PVXXXXX and without extension ) from an SFTP server (LINUX) into Azure using Copy activity from SFTP to Blob.
Below is the error message
If the file is marked as a binary in Linux (I think filetype as 0 as per our SFTP counter part), we are able to copy. but if the file type is mentioned as AscII (filetype as 1) it is failing.
Failure happened on 'Sink' side. ErrorCode=SftpServerNotReturnExpectedDataLength,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error occurred when trying to fetch the SFTP file 'pv112235'. This could be a transient issue and you may rerun the job. If it fails again continuously, contact customer support.,Source=Microsoft.DataTransfer.ClientLibrary.SftpConnector,'
Can you please help here
Thanks,
Sridhar
An Azure service for ingesting, preparing, and transforming data at scale.
The issue got resolved by Microsoft Support: there is an undocumented feature "disableChunking": true that solved the problem which is yet to be released
Hi @sridhar - Thank you for sharing resolution details.
Kindly consider marking it as accepted answer? Accepted answers helps community as well.
Hi @sridhar ,
Thank you for posting query on Microsoft Q&A Platform.
Could you please try below suggestions and see if that helps.
Hi Maheer, We cannot mark them as binary as the file at source is process generated and that will be of code 101 type (which is Ascii text file).
And the other suggestions are not working for me.. Can you plz help here
Thanks,
sridhar
Hi team,
Can I get some help on this. Any additional properties do we need to set up on source and sink side. My use case is it is comma delimited text file not able to be copied to blob from SFTP when file code is 101. Below is the command for reference for the file properties on SFTP. Any help will be appreciated.
put [source file] [destination file],101,50,50,200
Thanks,
Sridhar
Hi @sridhar ,
Thank you for being patience on this.
Majorly its because of communication gap between your SFTP and ADF as discussed in below thread. I would encourage you to have a support ticket for this issue. Please feel free to share support ticket details here as well(preferably as private message) so that I can also follow up on ticket for speed resolution.