Skip to main content
Solved

Running a Sharepoint Excel in my workbench results in OSError: [WinError 10093] Either the application has not called WSAStartup, or WSAStartup failed

  • October 31, 2024
  • 2 replies
  • 152 views

hayley.lam
Contributor
Forum|alt.badge.img+1

Hi there, 

 

I have connected to a Sharepoint Excel file in my workbench. I am able to read the rows and values when inspecting the Excel. 

 

However, when I connect the Sharepoint Excel reader into any transformer, I get the error below:

 

Exception ignored in: <finalize object at 0x13bf76a0; 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: [WinError 10093] Either the application has not called WSAStartup, or WSAStartup failed
Exception ignored in: <finalize object at 0x13bf7cc0; 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: [WinError 10093] Either the application has not called WSAStartup, or WSAStartup failed
Error running translation.
 

 

When I try open the Python file linked the error log, it does not open (not sure if this is expected or not). 

 

I have tried getting around this by first creating a copy of the Sharepoint Excel with no luck. 

 

Any pointers on how to fix this? Thanks

Best answer by jobvdnoort

Morning Hayley,

 

Do you use the SharePointOnlineConnector to connect to the sharepoint, and the excel?

When I want to read and use an excel file from sharepoint, I have the SharePointOnlineConnector download the file to a temp folder (using the Request action “download”) to be able to open, and work with it.

 

SharepointOnlineConnector → Download to temp folder

FeatureReader(Excel) → Read from downloaded folder.

 

Maybe this helps in your case?

View original
Did this help you find an answer to your question?

2 replies

jobvdnoort
Supporter
Forum|alt.badge.img+10
  • Supporter
  • Best Answer
  • October 31, 2024

Morning Hayley,

 

Do you use the SharePointOnlineConnector to connect to the sharepoint, and the excel?

When I want to read and use an excel file from sharepoint, I have the SharePointOnlineConnector download the file to a temp folder (using the Request action “download”) to be able to open, and work with it.

 

SharepointOnlineConnector → Download to temp folder

FeatureReader(Excel) → Read from downloaded folder.

 

Maybe this helps in your case?


hayley.lam
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • October 31, 2024

@jobvdnoort that worked perfectly, thank you! 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings