question

MaheshKumarSSM-8330 avatar image
0 Votes"
MaheshKumarSSM-8330 asked MartinJaffer-MSFT commented

ADF -- Issue in unzipping

Hello All,

I am facing an issue where a zip file which is around 21 MB fails while unzipping. The rest all files ranging 130 KB to 2.7 MB get unzipped perfectly. This 21 MB file, when I download to my local machine, I am able unzip it without any issues.

Attaching screenshots for your reference...

The screenshot "Error_13Apr" shows the error message.

The screenshot "File List_13Apr" shows the list of the files (which are less than 21 MB) that have succeeded and the file (which is around 21 MB) that has failed.


Please advise.
Thanks.



  • Note:


I have posted this issue in a related link as below...
https://docs.microsoft.com/en-us/answers/questions/96042/adf-fails-to-unzip-files.html

But, not sure, if that is being addressed, so I have posted here as a new issue.

Regards,
Mahesh

87521-error-13apr.png

87488-file-list-13apr.png




azure-data-factory
error-13apr.png (17.1 KiB)
file-list-13apr.png (156.1 KiB)
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @MaheshKumarSSM-8330 and welcome to Microsoft Q&A.

Thank you for opening a new thread. I do not monitor old threads as closely as new threads.

A couple questions,

  • is this the largerst of the files? are there any similar or larger sized ones which unzip properly?

  • are you using a self-hosted integration runtime or Azure integration runtime or something else?

  • zip files can contain single files, or entire directories. Are all of yours the same type?

0 Votes 0 ·

Hello @MartinJaffer-MSFT,

Thanks for replying!

Please find below my responses inline....

 Is this the largest of the files? are there any similar or larger sized ones which unzip properly?

Yes. It is the largest of the files. All other files are less than 5 MB and they unzip properly.

 are you using a self-hosted integration runtime or Azure integration runtime or something else?

We are using an Azure integration runtime (Region: AutoResolve)

 zip files can contain single files, or entire directories. Are all of yours the same type?

Yes all the zip files contain only csv files.

Let me know if you need further details.
Thank you.





1 Vote 1 ·

I was able to copy a csv of 100000 rows, 9712kb compressed (zip) to 22604kb uncompressed, using blob CSV -> blob CSV.

Other things I can try, using blob binary -> blob binary, making a larger file, other compression types.

0 Votes 0 ·
Show more comments

0 Answers