Sharepoint plugin - connection succesfull but fails anyway

[SanderVW]

Hello,

I am trying to set up a connection between Dataiku and SharePoint using the SharePoint plugin. I want to use the SharePoint Online Site App Permissions method and have configured a preset with the (as far as I can tell) correct settings. When I attempt to build a SharePoint dataset using this preset however, it gives the following error after attempting to connect for 3 minutes:

 Error while connecting to dataset PROJECTNAME.DATASETNAME, caused by: SocketBlockLinkKernelException: Failed to init FS provider : <class 'json.decoder.JSONDecodeError'> : Expecting value: line 1 column 1 (char 0)

I also see the following in the activity log while trying to connect:

[14:14:10] [INFO] [dku.utils]  -   arg_count = len(inspect.getargspec(clazz.__init__).args)
[14:14:10] [INFO] [dku.utils]  - WARNING:robust_session:Status code 403. Attempting reconnection (1)
[14:14:10] [INFO] [dku.utils]  - WARNING:robust_session:Safely closing session
[14:14:10] [INFO] [dku.utils]  - WARNING:robust_session:Error while closing session: module 'requests' has no attribute 'close'
[14:14:41] [INFO] [dku.utils]  - WARNING:robust_session:Status code 403. Attempting reconnection (2)
[14:14:41] [INFO] [dku.utils]  - WARNING:robust_session:Safely closing session
[14:14:41] [INFO] [dku.utils]  - WARNING:robust_session:Error while closing session: module 'requests' has no attribute 'close'
[14:15:11] [INFO] [dku.utils]  - WARNING:robust_session:Status code 403. Attempting reconnection (3)
[14:15:11] [INFO] [dku.utils]  - WARNING:robust_session:Safely closing session
[14:15:11] [INFO] [dku.utils]  - WARNING:robust_session:Error while closing session: module 'requests' has no attribute 'close'
[14:15:41] [INFO] [dku.utils]  - WARNING:robust_session:Status code 403. Attempting reconnection (4)
[14:15:41] [INFO] [dku.utils]  - WARNING:robust_session:Safely closing session
[14:15:41] [INFO] [dku.utils]  - WARNING:robust_session:Error while closing session: module 'requests' has no attribute 'close'
[14:16:12] [INFO] [dku.utils]  - WARNING:robust_session:Status code 403. Attempting reconnection (5)
[14:16:12] [INFO] [dku.utils]  - WARNING:robust_session:Safely closing session
[14:16:12] [INFO] [dku.utils]  - WARNING:robust_session:Error while closing session: module 'requests' has no attribute 'close'
[14:16:42] [INFO] [dku.utils]  - WARNING:robust_session:Status code 403. Attempting reconnection (6)
[14:16:42] [INFO] [dku.utils]  - WARNING:robust_session:Safely closing session
[14:16:42] [INFO] [dku.utils]  - WARNING:robust_session:Error while closing session: module 'requests' has no attribute 'close'

I'm unsure as to why this happens as I can see the connection is succesful and authorized within the Azure application sign-in logs. 

What could be the cause of this? And how would I be able to establish a connection correctly? I already talked with our Azure administrators and confirmed that it is set up correctly on the Azure/SharePoint side so I think it can only be something with the way it is configured at the Dataiku side but am at a loss...

---

Operating system used: Windows

[AlexB]

Hi ,

Looking at the logs, it would seem you are using a rather old version of the plugin (1.0.9 or earlier ?). The first thing to do would be to update it. If the problem remains, I would strongly suggest to open a ticket with the support. They will guide you on how to retrieve the appropriate log files and send them to us securely, so that we can investigate the issue.

[SanderVW]

Hello, the plugin version was indeed quite old (1.0.8) but updating it to the most recent version unfortunately did not help. 

We are getting a new message now (also just prior to updating, so it's unclear what changed):
Failed to stat path '' : <class 'sharepoint_client.SharePointClientError'> : Error (get_files): Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

Checking with Azure administrators showed that access is still sucessfull so it seems to still be Dataiku related (which wuold be weird but it really seems like it)