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

Question

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!

chandra_balusugure · Answer

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)

ssjl · Answer

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.

niklas_greilinger · Answer

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