Do you use the sharepoint online connector in your workspace? I think I can remember having problems with this transformer but not necessarily in FME 2024. If this is the transformer you are using can you remove the transformer from your workspace, save, open an empty workspace, uninstall the sharepoint library (tools>FME Options>FME Packages), open your broken workspace and add the transformer again and check if it's working now?

Thanks for the reply. I tried your suggestion but it made no difference.

It’s a Feature Reader in a brand new workspace trying to read in an Excel from a SharePoint library. The SharePointOnlineConnector transformer works fine. There’s nothing else in it at all.

Hi @jacintasomers have you tried re-authenticating your SharePoint connection? Has anything else in your environment changed since the upgrade? (permissions, security settings, SharePoint admin settings, etc.?)
If this issue persists, perhaps you can submit a support ticket with us so that we may investigate further. https://support.safe.com/hc/en-us/p/Support

@evieatsafe thanks for your reply. Yes I re-authenticated but had no joy. Everything is the same and the connectors continue to function in previous versions of FME. I can see the preview of the Excel sheets when setting up the transformer and also open it with no issues in the Inspector.

There seems to be a successful translation with the error coming afterward.  I’ll log a ticket thank you. 

Did you upgrade your reader, writers and/or transformers when moving to v2024.1?
Do you still have the problem when running it with a non-upgraded workbench, i.e. still using the 2023 readers, writers and transformers?

I am seeing the exact same thing. Before upgrading to 2024.1, a workflow that I use frequently functioned without issue. Since the upgrade, I too see a Python-related error when reading from an XLSX file that is stored on SharePoint. 

Even with a vanilla workflow that contains only the reader, it still fails to run. 

Traceback (most recent call last):
  File "weakref.py", line 590, in __call__
  File "C:\Program Files\FME\python\urllib3\connectionpool.py", line 1135, in _close_pool_connections
    conn.close()
  File "http\client.py", line 1020, in close
  File "socket.py", line 505, in close
  File "ssl.py", line 1311, in _real_close
  File "socket.py", line 499, in _real_close
OSError: /WinError 10093] Either the application has not called WSAStartup, or WSAStartup failed
Exception ignored in: <finalize object at 0x10bf8ae0; dead>
Traceback (most recent call last):
  File "weakref.py", line 590, in __call__
  File "C:\Program Files\FME\python\urllib3\connectionpool.py", line 1135, in _close_pool_connections
    conn.close()
  File "http\client.py", line 1020, in close
  File "socket.py", line 505, in close
  File "ssl.py", line 1311, in _real_close
  File "socket.py", line 499, in _real_close
OSError: lWinError 10093] Either the application has not called WSAStartup, or WSAStartup failed
Error running translation.
 

I've been in contact with SAFE and if you upgrade the connector then your workspace might work, it didn't for me. I'm still in contact with them though and hopefully will get to sort it soon in my case. 

Strangely I have found that even though you don't use a SharePoint online connector in your workspace, of you add one to the workspace or a bookmark in the workspace where the reader is, if you're running it in pieces, then the reader works. Something to do with how the connection works in the backend if I remember correctly.