2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Alteryx server and SharePoint.

prpatel
8 - Asteroid

I'm finally able to put a workflow (that contains a SharePoint connector) from my computer to my Alteryx server with no issues.

 

I resolved this by installing the SharePoint add-in on the server version of designer using this post as a guide: https://help.alteryx.com/20201/server/install-custom-tools

 

Now when I go to run the workflow I get the following issue...Failed to authenticate....see screenshot below....

prpatel_0-1655584302602.png

 

 

Does anyone out there know how to resolve this?

 

I think I have to tell our SharePoint servers not to worry about authentication of this Alteryx server when the authentication is called for, but is there a different way around this?

 

-prpatel

 

 

3 REPLIES 3
Tiffyyy
Alteryx
Alteryx

Hi @prpatel ,

 

Looks like someone had similar issue as you, you may following these steps:

 

If you're trying to run a workflow on Server that had embedded credentials (such as SharePoint Files), there is a registry setting that is needed.  

 

The SharePoint Files connector is a Python-based connector, so it will require the following registry key to exist in both the end users machine as well as each worker node on the server.   

  • Type regedit in Windows Start Menu 
  • Browse to the folder location: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SRC\Alteryx 
  • Right click and select New > String Value 

Registry Key: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SRC\Alteryx 
Value Name: PythonAllowHideEncryption 
Value Data: true 

 
Once this key has been added, the user would need to reauthenticate the tool on his workflow in Designer and republish the workflow to gallery

 

Source of article : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-Failed-to-authenticate-SharePoin...

 

Hope it helps.

prpatel
8 - Asteroid

@Tiffyyy 

 

A better way do hooking up to SharePoint is to sync the folder to your OneDrive, then then don't use the SharePoint tool but use the data input tool.  Then connect to the file as you would if were on your laptop.

 

I tried that route and even set a schedule to run every hour.  the output was a Tableau .hyper file.  so far over the past 48 hours, it has been working great.

 

the solution you provided requires me to interact with IT team who question every little thing I need to do with my computer 😭

Nithinpanicker
7 - Meteor

Hi @prpatel,

 

I have been having a similar issue. I have all my inputs saved to a teams channel which I have synced to my system. The problem I have is the workflow works fine when running it from designer from my system but when I upload to the server, I keep running into errors like cannot access the folder. I would like the outputs to be also be in the same teams channels.

 

Could you give me some more insight on what you did to have it running in server?

 

Thanks and regards,

 

Nithin Panicker