Sporadic "Error during http request" on Excel Reader/Excel Reader (XLS) (deprecated) with Sharepoint Online Connector

Hello,

After upgrading to KNIME 4.3.1, I’ve been getting sporadic “Error during http request” on workflows that use these nodes:

Excel Reader or Excel Reader (XLS) (deprecated)
Sharepoint Online Connector
Microsoft Authentication

Here is the detailed error message:

Execute failed: com.microsoft.graph.core.ClientException: Error during http request
org.knime.core.node.InvalidSettingsException: com.microsoft.graph.core.ClientException: Error during http request
at org.knime.ext.poi2.node.read4.ExcelTableReader.createDataTableSpec(ExcelTableReader.java:200)
at org.knime.base.node.io.filehandling.FileHandlingUtil.createDataTable(FileHandlingUtil.java:103)
at org.knime.ext.poi2.node.read4.XLSReaderNodeModel.execute(XLSReaderNodeModel.java:154)
at org.knime.ext.poi2.node.read4.XLSReaderNodeModel.execute(XLSReaderNodeModel.java:1)
at org.knime.core.node.NodeModel.executeModel(NodeModel.java:576)
at org.knime.core.node.Node.invokeFullyNodeModelExecute(Node.java:1245)
at org.knime.core.node.Node.execute(Node.java:1025)
at org.knime.core.node.workflow.NativeNodeContainer.performExecuteNode(NativeNodeContainer.java:558)
at org.knime.core.node.exec.LocalNodeExecutionJob.mainExecute(LocalNodeExecutionJob.java:95)
at org.knime.core.node.workflow.NodeExecutionJob.internalRun(NodeExecutionJob.java:201)
at org.knime.core.node.workflow.NodeExecutionJob.run(NodeExecutionJob.java:117)
at org.knime.core.util.ThreadUtils$RunnableWithContextImpl.runWithContext(ThreadUtils.java:334)
at org.knime.core.util.ThreadUtils$RunnableWithContext.run(ThreadUtils.java:210)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.knime.core.util.ThreadPool$MyFuture.run(ThreadPool.java:123)
at org.knime.core.util.ThreadPool$Worker.run(ThreadPool.java:246)
Caused by: com.microsoft.graph.core.ClientException: Error during http request
at com.microsoft.graph.http.CoreHttpProvider.sendRequestInternal(CoreHttpProvider.java:471)
at com.microsoft.graph.http.CoreHttpProvider.send(CoreHttpProvider.java:220)
at com.microsoft.graph.http.CoreHttpProvider.send(CoreHttpProvider.java:200)
at com.microsoft.graph.http.BaseStreamRequest.send(BaseStreamRequest.java:88)
at com.microsoft.graph.requests.extensions.DriveItemContentStreamRequest.get(DriveItemContentStreamRequest.java:52)
at org.knime.ext.sharepoint.filehandling.fs.SharepointFileSystemProvider.newInputStreamInternal(SharepointFileSystemProvider.java:193)
at org.knime.ext.sharepoint.filehandling.fs.SharepointFileSystemProvider.newInputStreamInternal(SharepointFileSystemProvider.java:1)
at org.knime.filehandling.core.connections.base.BaseFileSystemProvider.newInputStream(BaseFileSystemProvider.java:270)
at java.nio.file.Files.newInputStream(Files.java:152)
at org.knime.ext.poi2.node.read4.ExcelTableReader.settings(ExcelTableReader.java:209)
at org.knime.ext.poi2.node.read4.ExcelTableReader.createDataTable(ExcelTableReader.java:120)
at org.knime.ext.poi2.node.read4.ExcelTableReader.createDataTableSpec(ExcelTableReader.java:198)
… 16 more
Caused by: java.lang.IllegalStateException
at okhttp3.internal.connection.Transmitter.prepareToConnect(Transmitter.java:129)
at okhttp3.internal.http.RetryAndFollowUpInterceptor.intercept(RetryAndFollowUpInterceptor.java:79)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:142)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:117)
at com.microsoft.graph.httpcore.RedirectHandler.intercept(RedirectHandler.java:123)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:142)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:117)
at com.microsoft.graph.httpcore.RetryHandler.intercept(RetryHandler.java:140)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:142)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:117)
at com.microsoft.graph.httpcore.AuthenticationHandler.intercept(AuthenticationHandler.java:31)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:142)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:117)
at com.microsoft.graph.httpcore.TelemetryHandler.intercept(TelemetryHandler.java:37)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:142)
at okhttp3.internal.http.RealInterceptorChain.proceed(RealInterceptorChain.java:117)
at okhttp3.RealCall.getResponseWithInterceptorChain(RealCall.java:229)
at okhttp3.RealCall.execute(RealCall.java:81)
at com.microsoft.graph.http.CoreHttpProvider.sendRequestInternal(CoreHttpProvider.java:398)
… 27 more

Workaround:
Sync the Excel file with OneDrive using its desktop app. Set the file to “Always keep on this device” . Load the file locally using the Excel Reader node.

Thanks,

@atiorile

1 Like

Hello atiorile,
with KNIME 4.3.1 we updated the Microsoft Sharepoint library because of another issue. We will investigate the problem to see if there is a problem with the new library version.
Bye
Tobias

1 Like

Hello @tobias.koetter,

do you have any news on this issue? I’m running into these “Error during http request” messages as well with the newest Excel Reader node. At the moment, I cannot at all execute a workflow that worked fine last week. The workaround is difficult, as I want to execute the workflow on the server.

Thanks,
Daniela

1 Like

Hi @daniela_digles,

I haven’t tested it since my KNIME processes now depend on files synced by the OneDrive desktop app, but KNIME 4.3.2 changelog includes a bug fix for AP-16186: SharePoint Online Connector: Reading a file occasionally fails with “Error during http request”

Thanks,

@atiorile

3 Likes

Hi @atiorile,
I have updated KNIME, and so far it works without any problems!
Thank you for checking!

3 Likes