topic Re: Microsoft Share Point Connector error: Error during download: Unable to read data from the transport connection: Connection reset by peer in Data Movement & Streaming

Microsoft Share Point Connector error: Error during download: Unable to read data from the transport connection: Connection reset by peer

marciomgm — Wed, 19 Mar 2025 23:02:17 GMT

I'm using data load with XLS and CSV files contained in my site in Microsoft Share Point.
The problem is intermittent, sometimes I can complete the charge and other times I don't it stops at different times.
Is there any way to handle this error?

(Connector error: Error during download: Unable to read data from the transport connection: Connection reset by peer.)

LIB CONNECT TO 'Sharepoint'; LOAD Name as [ListFiles.Name]; SELECT UniqueId, Name FROM ListFiles WITH PROPERTIES ( subSite='/sites/meusite/', folder='/sites/meusite/Documentos Compartilhados', maxResults='' ); for each File in FieldValueList('ListFiles.Name') trace $(File); tabela: LOAD dataPostagem, codigoServico, descricaoServico, quantidadeItens, peso, valorUnitarioServico, valorServico, numeroDocumento, etiqueta as codigo_rastreamento, valorDeclarado, valorDesconto, unidadePostagem, cepOrigem, municipioCepOrigem, ufCepOrigem, cepDestino, municipioCepDestino, ufCepDestino FROM [lib://Office_365_Sharepoint/Documentos Compartilhados/tabela/$(File)] (XmlSimple, Table is [FATURA/itemCorpo]); next File;

Re: Microsoft Share Point Connector error: Error during download: Unable to read data from the transport connection: Connection reset by peer

Mfarias86 — Fri, 04 Aug 2023 13:27:32 GMT

I´m having the same issue, tried with 2 different sharepoint sites, different conexions too. It happens with single files and FOR statements as in Marcio example. Its pretty random, I had the error a few times in the past, but for the last few weeks it got way worse, nothing is running properly now.

Re: Microsoft Share Point Connector error: Error during download: Unable to read data from the transport connection: Connection reset by peer

AdamBS — Fri, 04 Aug 2023 13:40:04 GMT

I put some code in to test if the xlsx was modified in the last 3 days. Result is I read less files. My metadata connector never errored, but the code similar to @marciomgm would error. It was odd to me because the failing file kept changing - almost like SharePoint was hitting some limit. I did not get the connection reset by peer - just a blank error. Have stability since reducing the number of files.

Re: Microsoft Share Point Connector error: Error during download: Unable to read data from the transport connection: Connection reset by peer

hriquelme — Tue, 28 May 2024 13:38:27 GMT

Hello mariomgm, Did you get a solution to this problem?

Re: Microsoft Share Point Connector error: Error during download: Unable to read data from the transport connection: Connection reset by peer

marciomgm — Tue, 28 May 2024 15:26:36 GMT

Infelizmente não.
Só consegui resolver migrando para o Google Drive