question

MuhammadShoaib-6775 avatar image
0 Votes"
MuhammadShoaib-6775 asked Imran-0776 commented

Pipeline failed to extract zip file

Hello,

I have Zip file on a blob Storage and it contains multiple zip files. I am trying to extract zip using copy data activity and got the following error:

Error code 2200 Failure happened on 'Source' side. ErrorCode=UserErrorFailedFileOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Upload file failed at path xxxxxx .,Source=Microsoft.DataTransfer.Common,''Type=System.ArgumentOutOfRangeException,Message=Number was less than the array's lower bound in the first dimension. Parameter name: srcIndex,Source=mscorlib,'

source : blob storage
compression: Zip deflate
sink: blob storage
compression: none

can anyone help me to resolve this issue.

Thanks,
Shoaib

azure-data-factory
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.

HarithaMaddi-MSFT avatar image
0 Votes"
HarithaMaddi-MSFT answered HarithaMaddi-MSFT commented

Hi @MuhammadShoaib-6775,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

I looked at similar issues from Customers in recent past and it is observed that the compression method on zip file is the root cause. Currently data factory can load zip files which have supported method, like Deflate. Please refer to the official documentation and the recommended approach is to use deflate method.

Please let us know if this helps in resolving the issue. If issue persists, please share with us further details on data factory name, region and integration runtime used to help in further investigation.



  • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification.



· 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.

Hi @MuhammadShoaib-6775,

We have not received a response from you. Are you still facing the issue? If you found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

0 Votes 0 ·

Hi @HarithaMaddi-MSFT ,

Thanks for your response.

I have seen the documentation which you referred. File type is zip and using ZipDeflate compression method on the source side But it gives the same error. However, I am able to unzip locally without any error.

can you please investigate further, required details are:

Region: Southeast Asia
IR: DefaultIntegrationRuntime (Southeast Asia)
and ADF Resource ID, I am not allowed to share on public forum.

Thanks

0 Votes 0 ·

Thanks for confirming the compression method. Below is an approach to identify compression method on source files when you open them on local using file explorer as below. You can select method column by using "Add Columns" option under view tab. Please suggest if the method used is aligned with supported ones. And to investigate further, please share pipeline run id as without that its hard to access the logs.

43640-image.png

Thanks for your patience!


0 Votes 0 ·
image.png (153.6 KiB)
Show more comments
Imran-0776 avatar image
0 Votes"
Imran-0776 answered Imran-0776 commented

Hi @MuhammadShoaib-6775 I have same issue but my zip file compression method is "Deflate" still my pipeline is failing with below error.

Any leads on this. Thanks in advance.


Failure happened on 'Sink' side. ErrorCode=UserErrorUnzipInvalidFile,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The file 'sample_file.zip' is not a valid Zip file with Deflate compression method.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.IO.InvalidDataException,Message=End of Central Directory record could not be found.,Source=Microsoft.DataTransfer.ClientLibrary,'

· 1
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.

@HarithaMaddi-MSFT can you please look into this.

0 Votes 0 ·