Sharepoint Connector "Graph Service Exception - item not found" since installing version 5.1.0

Hello community,

I can’t access certain sharepoint group sub-folders since installing version 5.1.0. Worked fine before the update.

Best regards,

Alex

2 Likes

I have the same problem.

Just look into my logs and get this from my KNIMELog

2023-07-21 10:01:18,330 : WARN : Basic L&F File Loading Thread : : NioFile : : : Could not list files in ‘/Dokumente/Upload_Forderungsmanagement/Auswertung Forderungen’: Error code: itemNotFound
Error message: The resource could not be found.

GET https://graph.microsoft.com/v1.0/drives/b!5zx2zk5fFkOmW9m15z7MRADcbvbDlzZNqQ9--UHN_tqRAf_bQe1KSZVgK0TDFQRO/root:/Upload_Forderungsmanagement%2FAuswertung%2520Forderungen:/children
SdkVersion : graph-java/v5.49.0

404 : Not Found
[…]

[Some information was truncated for brevity, enable debug logging for more details]
2023-07-21 10:06:57,118 : DEBUG : main : : WorkflowEditPartFactory : : : Deactivate org.knime.workbench.editor.context
2023-07-21 10:06:57,119 : DEBUG : main : : WorkflowEditPartFactory : : : Deactivate org.knime.workbench.editor.context
2023-07-21 10:06:57,119 : DEBUG : main : : WorkflowEditPartFactory : : : Deactivate org.knime.workbench.editor.context

Any solution?
Before updating KNIME to 5.1 it was working fluent.

Best regards
Christopher

3 Likes

Hi @b-ar-c and @Christopher_Lozano

we will try to reproduce the issue you are facing on our side. Could you share the settings when the error does occur? Is it only when you are using the “Group site” option within the SharePoint Online Connector Node?

Best regards
Lars

My setup is as followed:

And afterwards I use the List/Files and Folders Node to list the files and folders within this Sharepoint Group and I do not get an error but this is maybe due to my setup or maybe the structure of this folder or the files within.

Hello @laaaarsi

thanks for your reply.

At this time i have only used the Group Site with the Sharepoint Connector.
After this node i have connected an Excel Writer, because i have some output for different departments of our company.
In the Excel Writer Node itself, i could change the path and dive in to the subfolders in the past. That it now not possible…

Hope i could describe my problem.

Best regards
Christopher

Hello and also thank you,

I tried both “Group site” and “Web URL”. The error occurs as soon accessing certain folders in “Working directory”.

Best regards,

Alex

We may found the culprit of the issue you are facing. It is most likely because of the spaces within the path. Does it work for paths without spaces or does it also occur in this case?

3 Likes

I tested it right now and it seems to be the problem if the path has spaces.
Other subfolders where the path has no spaces in it works fine.

3 Likes

Unfortunately I cant propose a good workaround at the moment, other than get rid of the spaces within a path. We will now do further investigations where does this come from. Will keep you updated and apologies for the inconvenience caused.

Best regards
Lars

2 Likes

The problem was caused by an update of the underlying Graph API library. The problem is already fixed and will be shipped with the next bug-fix release. Until then you should use a an older KNIME Version or remove the spaces from the folder names. We apologies again for the caused inconveniences.

I wish you a nice weekend!

Best regards
Lars

6 Likes

Thank you, Lars! I will be waiting for the bug-fix release. What is the best way to be informed about the new version in time while the old version is installed?

If I’m not wrong, once you open up your KNIME, there’s informations about updates on their first screen.

BTW, I got the same erros when I upgraded to 5.1.0 and the workaround was to get rid of spaces on my directories. sad but true.

Waiting the buf-fix release.

Hey there,

i had the same issue while using the List Files / Folders Node for reading from the Sharepoint.
There are some files with spaces in it and the node said that it can´t read the Files.

Execute failed: The resources coul not be found
That´s the exact Error message i got.

Tested it with a folder which has no files with spaces in it and it worked.

@laaaarsi
Do you know when there will be an update with the bug-fixes?

We can not change all the files and folder structures in all of our departmentes in our companie. There are many dependencies of some files, so the “easy” workaround to get rid of the spaces is no option in our company.

Best Regards
Christopher

@Christopher_Lozano I’am afraid as I can’t give you an exact date but we are currently in preparation for a 5.1.1. release

Best regards
Lars

2 Likes

@laaaarsi
do you know by any chance is there a way to access sharepoint with knime even if corporate id does not support it / it’s kind of blocked probably due to some proxies or sth like this?
br

Thanks for the update in 5.1.1.
Confirmed patch fixed issue with spaces in names as per above thread.
Was receiving graph api errors traversing folder structures with spaces previously.
Patched to 5.1.1 and issue is resolved, able to navigate the structure and read files from such folders now. Appreciate the update and prompt attention to the issue.

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.