In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

SharePoint files error: The server cannot process the request due to a high load.

robertditonno
6 - Meteoroid

Hi All,

 

I am getting the following error for the Sharepoint Files Input tool:  SharePoint Files Input (19) The server cannot process the request due to a high load.

 

I am on the most up-to-date designer and the issue is coming from my local machine. Is there any suggestions on what could be done? All I am trying to do is grab the file paths of a particular folder.

 

Thanks!

4 REPLIES 4
ssjl
8 - Asteroid

I have this issue from a macro reading SPO file content from 119 files. I just introduced the throttle tool in an attempt to not slam the server.

niklas_greilinger
10 - Fireball

Did you ever find a solution for this? Facing the same issue in 2024.1 with the 2.7.0 Sharepoint Input. Anybody?

 

ssjl
8 - Asteroid

Solution was to use SPO tool to download file locally for later processing then pass the path into a dynamic input tool to read from the local file. In another version I used PowerShell to pull all the files to a network directory in stage 1, and then the usual read multiple files using standard input tool. 

Hi @robertditonno,

 

SharePoint List Output issue with creating/appending/overwriting a large list record count.  This is a defect being investigated in TDCE-699/GCSE-2944

 

Resolution: GCSE-2944
We believe this has to do with the load caused by SharePoint trying to handle the metadata requests for that existing list when it's over a certain size.
Although in replication we see a high load error consistently, the customer sees the issue more intermittently with behavior where the final record count is not as expected, and intermittent failure with various modes (eg, overwrite/append/create)

Labels
Top Solution Authors