Excel Reader Mountpoint xx-KNIME-Server does not exist.

tbtt · May 12, 2020, 1:08pm

When I try to deploy a workflow with an excel reader node, the excel reader not is not finding the File, I tried it with a Custom URL and with reading from mountpoint

Errors:
Excel Reader (XLS) 0:1 - ERROR: Execute failed: Mountpoint xx-KNIME-Server does not exist.
Excel Reader (XLS) 0:2 - ERROR: Execute failed: java.io.IOException: Resource associated with “knime://xx-KNIME-Server/data/filename.xlsx” does not exist

Would appreciate some help!

ztrubow · May 12, 2020, 3:40pm

Hello,

What version of Knime AP are you using?
Does selecting the file from your local file store work?
Where is the file located on your machine?
Have you attempted to click the browse button in the configuration window and pointed it directly to the file?

tbtt · May 13, 2020, 8:28am

Hey,

I tried it with version 4.1.2
Works
The file is stored on the server, path knime://xx-KNIME-Server/data/filename.xlsx
As the file is stored on the Server, and I have to use KNIME Protocol, I dont think this is possible, is it?

Best!

ztrubow · May 14, 2020, 2:09pm

Hi tbtt,

Please try the following:

Open Knime AP, and add a new mount point via the explorer on the left hand side
Connect to your Knime server
Add the excel reader node to a workflow
Configure the reader, and select read from: Mountpoint and choose the Knime server you connected to above
Then click Browse and you should be able to browse to the excel file on the Server

Please note, you will have to have added the excel file from your local machine first to the server you added.

Please let me know if this works for you for connecting to the file.

ztrubow · May 19, 2020, 1:51pm

Hello,

Just checking in to see if my suggestion worked for you?

Thanks,
Zack

tbtt · May 19, 2020, 4:05pm

Hey @ztrubow,

I don’t fully get what you want me to do. My server is already set up as a mountpoint, so steps 1&2 are already done, do you want me to add the server again?
I did the steps 3-5. which works out perfectly on the local machine, but as soon as I run the deployed version on the server, I get the Mountpoint does not exist error.

David_TT · March 9, 2021, 3:43pm

I am facing a similar problem.
I have a workflow running on knime server with an excel reader node. The excel file is uploaded to knime server. When configuring the excel reader node I cannot browse it but I can read it when I paste in the path. The node is able to read the file and shows the right preview.
When I try to execute the node I get the following error:
There are messages for workflow “test_xlsm 2021-03-09 16.21.03”
“Excel Reader (XLS) 158:1 - ERROR: Execute failed: Mountpoint knime-server does not exist.”

I use KNIME AP 4.2.3
Knime server is set up as a mountpoint
Excel reader node is configuered to access knime server via mountpoint

Would be great to be able do solve this issue.

Best
David

NDekay · March 9, 2021, 10:01pm

Hello,

Can you show your configuration for the Excel Reader node?

Thanks,
Nick

Karlygash · December 8, 2021, 5:06pm

@NDekay @ztrubow hello! i have the same issue, where says mount point is no longer valid
This is config of excel reader from Server workflow Mountpoint- Knime Server