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,