Salesforce Tool error on Alteryx server

[Akhand_Singh]

Hi, 

We have a workflow that has salesforce input tool to run API. When we run it on Alteryx designer it works well. Also, we have created DCM connection for Username & Password and for Token which helps us to connect easily. Now when we save this workflow on Alteryx server it goes fine but the moment, we run this from server itself, there is this error: " Error code 401: No permission -- see authorization schemes. (ToolId: 1) ". This workflow works fine on designer on server machine.

Credentials are saved and synced on server as well. There are few articles which I followed but still no luck. 

> How to: Set up DCM for Designer and Server (alteryx.com)

> Alteryx Designer, Server: Error: "<class 'AttributeError'>:'NoneType' object has no attribute 'get' ...

> Solved: SF input issue No permission--see authorization sc... - Alteryx Community

Thanks

[fmvizcaino]

Hi @Akhand_Singh ,

Fistly, I would try a newer or older version of the connector, just in case. I have seen many cases where a simple upgrade/downgrade 'fixed' the problem.

Moreover, you are not using the desktop automation license, but your issue is stated here. https://knowledge.alteryx.com/index/s/article/Error-Failed-to-authenticate-happens-when-using-Python...

It states an issue with the encryption part that shouldn`t be your case. Do you have a service account or run as credential running all workflows on the gallery? This is a question for your Gallery and Server admin.

Best,

Fernando Vizcaino

[Akhand_Singh]

Hi, thanks for your response!

I'm using latest versions of salesforce (5.1.0) and Alteryx (2023.2). I think this should not be the case.

And I'm using service account which is connected to tool to run on gallery and designer. I'm the Admin for server and gallery.

Thanks for sharing this article, i will follow it and let you know.

Thanks,

Akhand

[fmvizcaino]

Hi @Akhand_Singh ,

Sometimes, downgrading can help solving it. I had a different issue in the past and downgrading was the quick fix for it. 

Best,

FErnando Vizcaino

[briar_carlisle]

Hi, was this ever solved? I'm experiencing the same issue :/

[Akhand_Singh]

Hi, I tried to downgrade my tool but still its same and also i have followed the article you shared to Run as different user but no luck.

[Akhand_Singh]

Hi, I have found a workaround to call the API using python tool. Its just you need to write few syntax and it will be done. No separate authentication required once we put those values on notebook. Thanks

[briar_carlisle]

Nice! Are you able to share the details? 

[CE_5085781]

I'm having the same issue. Are you able to share the details of your workaround?