I have an identical workflow in KNIME Desktop v4.7.6 and v5.1. I cannot connect to a specific SharePoint folder in v5.1, but it works fine in v4.7.6. The error manifests in the CSV reader node that is pointing to a specific file in SharePoint. If I disable the variable and try to browse in the node, I get the error as well. I can navigate to the root of the SP site and down 2 levels, but no further.
Here is the debug error in the log:
2023-08-31 13:57:30,710 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : WorkflowManager : CSV Reader : 3:1 : CSV Reader 3:1 doBeforePreExecution
2023-08-31 13:57:30,710 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : NodeContainer : CSV Reader : 3:1 : CSV Reader 3:1 has new state: PREEXECUTE
2023-08-31 13:57:30,710 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : WorkflowDataRepository : CSV Reader : 3:1 : Adding handler 10d35f43-8469-43ef-82c4-2ba4e3b86e84 (CSV Reader 3:1: <no directory>) - 18 in total
2023-08-31 13:57:30,710 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : WorkflowManager : CSV Reader : 3:1 : CSV Reader 3:1 doBeforeExecution
2023-08-31 13:57:30,710 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : NodeContainer : CSV Reader : 3:1 : CSV Reader 3:1 has new state: EXECUTING
2023-08-31 13:57:30,710 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : LocalNodeExecutionJob : CSV Reader : 3:1 : CSV Reader 3:1 Start execute
2023-08-31 13:57:30,940 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : Node : CSV Reader : 3:1 : reset
2023-08-31 13:57:30,940 : ERROR : KNIME-Worker-16-CSV Reader 3:1 : : Node : CSV Reader : 3:1 : Execute failed: The specified file MyPGS Service Insights Dashboard Files/Shared Data/Directory.csv does not exist.
org.knime.core.node.InvalidSettingsException: The specified file MyPGS Service Insights Dashboard Files/Shared Data/Directory.csv does not exist.
at org.knime.core.node.util.CheckUtils.checkSetting(CheckUtils.java:272)
at org.knime.core.node.util.CheckUtils.checkSetting(CheckUtils.java:222)
at org.knime.filehandling.core.defaultnodesettings.filechooser.FileChooserPathAccessor.getRootPath(FileChooserPathAccessor.java:297)
at org.knime.filehandling.core.defaultnodesettings.filechooser.FileChooserPathAccessor.getFSPaths(FileChooserPathAccessor.java:204)
at org.knime.filehandling.core.node.table.reader.paths.PathSettings$1.getItems(PathSettings.java:105)
at org.knime.filehandling.core.node.table.reader.TableReaderNodeModel.getPaths(TableReaderNodeModel.java:195)
at org.knime.filehandling.core.node.table.reader.TableReaderNodeModel.execute(TableReaderNodeModel.java:158)
at org.knime.core.node.NodeModel.executeModel(NodeModel.java:558)
at org.knime.core.node.Node.invokeFullyNodeModelExecute(Node.java:1274)
at org.knime.core.node.Node.execute(Node.java:1036)
at org.knime.core.node.workflow.NativeNodeContainer.performExecuteNode(NativeNodeContainer.java:595)
at org.knime.core.node.exec.LocalNodeExecutionJob.mainExecute(LocalNodeExecutionJob.java:98)
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:367)
at org.knime.core.util.ThreadUtils$RunnableWithContext.run(ThreadUtils.java:221)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at org.knime.core.util.ThreadPool$MyFuture.run(ThreadPool.java:123)
at org.knime.core.util.ThreadPool$Worker.run(ThreadPool.java:246)
2023-08-31 13:57:30,940 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : WorkflowManager : CSV Reader : 3:1 : CSV Reader 3:1 doBeforePostExecution
2023-08-31 13:57:30,940 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : NodeContainer : CSV Reader : 3:1 : CSV Reader 3:1 has new state: POSTEXECUTE
2023-08-31 13:57:30,940 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : WorkflowManager : CSV Reader : 3:1 : CSV Reader 3:1 doAfterExecute - failure
2023-08-31 13:57:30,941 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : Node : CSV Reader : 3:1 : reset
2023-08-31 13:57:30,941 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : Node : CSV Reader : 3:1 : clean output ports.
2023-08-31 13:57:30,941 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : WorkflowDataRepository : CSV Reader : 3:1 : Removing handler 10d35f43-8469-43ef-82c4-2ba4e3b86e84 (CSV Reader 3:1: <no directory>) - 17 remaining
2023-08-31 13:57:30,941 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : NodeContainer : CSV Reader : 3:1 : CSV Reader 3:1 has new state: IDLE
2023-08-31 13:57:30,942 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : Node : CSV Reader : 3:1 : Configure succeeded. (CSV Reader)
2023-08-31 13:57:30,942 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : NodeContainer : CSV Reader : 3:1 : CSV Reader 3:1 has new state: CONFIGURED
2023-08-31 13:57:30,942 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : Node : String Manipulation : 3:3 : Configure succeeded. (String Manipulation)
2023-08-31 13:57:30,943 : DEBUG : KNIME-Worker-16-CSV Reader 3:1 : : NodeContainer : CSV Reader : 3:1 : Manager Hierarchy PROD 3 has new state: IDLE
2023-08-31 13:57:43,133 : DEBUG : main : : WorkflowEditPartFactory : : : Deactivate org.knime.workbench.editor.context
I get the same results in classic UI and new UI. This is on an Apple Silicon MacBook Pro with the ARM-specific build of KNIME in both cases.
