Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
marciomgm
Creator
Creator

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

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;
 
Labels (2)
4 Replies
Mfarias86
Contributor
Contributor

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.

AdamBS
Partner - Creator
Partner - Creator

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.

Adam Barrie-Smith
iOCO Analytics Solutions
hriquelme
Partner - Contributor II
Partner - Contributor II

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

marciomgm
Creator
Creator
Author

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