Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Download Tool - Chunked Request Error

nataliamiteva
8 - Asteroid

Hello community!

 

I have a workflow which uploads files to a Microsoft SharePoint site with the Download tool. It runs successfully intermittently and it occasionally errors with:

{"error":{"code":"invalidRequest","message":"The size of the provided stream is not known. Make sure the request is not chunked, and the Content-Length header is specified"}}

 

Here's my set-up:

nataliamiteva_0-1614809430898.png

 

nataliamiteva_1-1614809591623.png


Any ideas on how I can prevent the errors?


Many thanks in advance!!!

5 REPLIES 5
TrevorS
Alteryx Alumni (Retired)

Hello @nataliamiteva 

Is there any more to the error message by any chance? Also, is this hitting the uploadURL column? If so, can you provide us some more context for that data to better understand what's happening?

Thanks!

TrevorS

Community Moderator
nataliamiteva
8 - Asteroid

Thanks for the reply 

 

There's more in the DownloadHeaders column:

nataliamiteva_0-1615150344411.png

 

Full message: 

 

HTTP/1.1 100 Continue

HTTP/1.1 400 Bad Request
Cache-Control: no-cache
Pragma: no-cache
Transfer-Encoding: chunked
Content-Type: application/json;odata.metadata=minimal;odata.streaming=true;IEEE754Compatible=false;charset=utf-8
Expires: -1
P3P: CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI"
X-SharePointHealthScore: 0
X-SP-SERVERSTATE: ReadOnly=0
ODATA-VERSION: 4.0
SPClientServiceRequestDuration: 47
X-AspNet-Version: 4.0.30319
SPRequestGuid: 52c3b09f-f01e-2000-9b15-eaa2dbd07009
request-id: 52c3b09f-f01e-2000-9b15-eaa2dbd07009
MS-CV: n7DDUh7wACCbFeqi29BwCQ.0
Strict-Transport-Security: max-age=31536000
X-FRAME-OPTIONS: SAMEORIGIN
Content-Security-Policy: frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.stream.azure-test.net *.microsoftstream.com;
X-Powered-By: ASP.NET
MicrosoftSharePointTeamServices: 16.0.0.21017
X-Content-Type-Options: nosniff
X-MS-InvokeApp: 1; RequireReadOnly
X-MSEdge-Ref: Ref A: A18C3A6A1F7B43088007C18AF4A704B8 Ref B: LON21EDGE1017 Ref C: 2021-03-03T21:39:43Z
Date: Wed, 03 Mar 2021 21:39:43 GMT

JoshML
Alteryx
Alteryx

@nataliamiteva  - Have you attempted to utilize the identity value for the Transfer-Encoding header?

nataliamiteva
8 - Asteroid

Thanks for the reply

 

Unfortunately, that results in error 'HTTP/1.1 501 Not Implemented' in the DownloadHeaders

nataliamiteva
8 - Asteroid

The issue with the Download tool persisted and I ended up building a workaround which involved syncing the Sharepoint files through OneDrive on the remote Alteryx server machine. The process is explained here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Connect-to-Sharepoint-with-A...

Labels