topic Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please! in Alteryx Server Discussions

Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

matt2 — Fri, 14 Jun 2024 14:51:00 GMT

Version 4.0 and 4.1 of the Salesforce Input Connector doesn't work on Alteryx Server - I'm on 2019.2. I'm in the process of migrating workflows onto Server, which we recently purchased and the fact that I can't move my Salesforce ETL processes without downgrading Server is a big problem. I've been wrestling with this for two weeks - it was a big distraction during Inspire before I realized there was a known issue here.

Others are having this problem:

https://community.alteryx.com/t5/Dev-Space/Publishing-workflows-with-encrypted-password-to-the-Gallery/td-p/377324

@BlytheE , can we PLEASE prioritize this?!? Thanks!

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

BlytheE — Thu, 27 Jun 2019 13:57:08 GMT

@matt2 we totally hear you on this one and this is a high priority for me. I want to clarify the workaround for other people having this issue - it's not to downgrade your server version, it's to downgrade the Salesforce Input tool to use a pre-4.0 version.

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

zhuyyu — Thu, 27 Jun 2019 14:42:58 GMT

Not on Scheduler either. Please fix it, thanks.

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

ivy29gm — Thu, 27 Jun 2019 20:55:54 GMT

We reverted back to the deprecated non-py Salesforce input tool and it works on the server 2019.1 - also in a batch macro.

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

matt2 — Fri, 28 Jun 2019 12:25:42 GMT

Thank you for the suggestion, @BlytheE ! That helps. One thing, I had to right-click in my Tools area and "show depreciated tools" in Designer. I'm on 2019.2.

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

Coxta45 — Thu, 25 Jul 2019 19:21:47 GMT

Apologies - as my intentions are not to whine about this. However, our organization has experienced nothing but headaches with both versions 4.0 and 4.1 of the Salesforce input tool. I've been patient as this was honestly a last resort, but with Salesforce being, well, Salesforce, I feel that Alteryx should prioritize fixing the bugs in this connector that are literally stopping production for many customers. First, we found 4.1 to be such as drag on the UI (probably due to HTML GUI Set/Get Config settings, etc.) that it was absolutely unbearable to continue development on any workflow using v4.1 of the tool. It also riddles downstream tools (most commonly Selects and Joins) with the indescribably annoying "You have found a bug" errors - which seem to only be remediated via deleting, replacing, and reconfiguring.

So, we downgraded to 4.0, which significantly sped up the GUI experience, but then noticed that it prevented multi-user collaboration of workflows that use the 4.0 input due to the fact that the tool stores session info which is directly tied to a logged in user. Even when we're using a Salesforce (shared) service account for each input, the session errors exist when a different user opens the same workflow. Ideally the tool, upon instantiation (HTML GUI Set/Get Config) would detect already existing username/token/password in the tool's XML config and re-authenticate, at that point, and obtain a new session/token, correct?

Anywho, kindly asking for any progress update on a thoroughly tested new version that addresses these bugs. I'm only passionate because we do love this tool and rely it for business critical processes. It is a great tool for the most widely used CRM in world, after all!

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

kgendreau — Mon, 26 Aug 2019 16:11:28 GMT

Please fix this to run on gallery!!!!

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

dalym — Tue, 27 Aug 2019 12:45:41 GMT

I second @Coxta45 's frustrations above. I've been a big proponent of using Alteryx with Salesforce over developers wanting to write custom solutions. However, with all the issues I've encountered (e.g., proxy issues - which I still had to hack the main.py of the 4.1 connector due to our proxy requirements), I (and Alteryx) am beginning to lose credibility on the use of this tool. This needs to get fixed quickly and needs to be solid as I've encountered all of the issues @Coxta45 reported as well as others such as SOQL result parsing issues that worked fine in older versions of the connector.

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

matt2 — Mon, 07 Oct 2019 16:38:02 GMT

Per my earlier comment, my first solution was to use a depreciated version of the Salesforce tools. However, after I had trouble with the new Salesforce tools I also noticed trouble with the Python tool - output from Python programs weren't being passed back into Alteryx. While researching that, I found a post from the author of the Python tool saying that there was a bug in 2019.2 that caused trouble with Miniconda when you were working from a drive other than C: with spaces in the path (IT wants me to use the E: drive), so I reinstalled Alteryx Server in a file path without spaces ("ProgramFiles" instead of "Program Files"). I'm not 100% sure that's the reason that things are working for me now, but it might be worth trying.

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

dalym — Wed, 06 Nov 2019 19:51:43 GMT

@BlytheE Any info on a timeline to update the Salesforce connector? As I continue to use the connector (v4.1.0), I am finding some things to look at (I'm working around them by updating the Python code):

It looks like the current version is saving the session token as part of the control so when I come back into my workflow all the Salesforce connectors show errors. I just need to touch each of the controls for the error to go away
Provide the ability to change the Salesforce API version via configuration. Currently, version 42.0 is hard coded into the tool. I needed to update to version 45.0 so I had to find the variable in the Python code as well as the URL path in the bundle.js file to update this.

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

BlytheE — Wed, 06 Nov 2019 20:53:55 GMT

Hi @dalym - I believe @bora_perusic is better suited to answer that question. My area is the SDKs themselves that are used to build those connectors, so I don't know specific information around development plans for those tools. Thanks!

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

JamesP — Tue, 26 Nov 2019 13:21:48 GMT

Hi I am using v2019.1 and when downloading any of the versions of the salesforce tool, while the tool installer runs i get this error and it fails to load the tool: "No matching distribution for aiohttp==3.3.2 (from -r requirements.txt (line 1))".

What is the solution to have the install tool work correctly?

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

Nesbitt — Tue, 24 Mar 2020 19:17:29 GMT

Need this please

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

joeGade — Wed, 06 May 2020 23:59:39 GMT

looks Like Alteryx Still did not fix any of the issues that were reported here. That's So bad ..

The Older Versions of the Tool was working okay but they won't work with new sales force API's.

The issue is so bad, that if a Developer develops the Workflow using SFDC input tool v.1 we cannot upload to the server/gallery as the workflow is doing Machine Encryption. That's so Dum. Not sure why it was created like that. It's really useless if we cannot upload it to the server .

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

adendulu — Wed, 26 Aug 2020 23:48:55 GMT

Its almost been an year and none of the issues have been addressed , either we get a 401 authentication error or decrypt error and issues with SOQL queries if they are not ordered properly, is there a new version in the near future?

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

gavinott1 — Fri, 28 Aug 2020 15:11:57 GMT

Hello, the Salesforce Connector tools continue to be finicky, especially when used on the Gallery, but can be made to work with some tricks and adjustments. I configured a workflow hosted on my company's Gallery that allows users to search for people within a company and optionally push those people straight into Salesforce as leads. Below are 2 steps I took to enable the Salesforce Connectors:

1. The first error you probably run into is a credential error, where you see one of the following errors:

Error: Salesforce Input (309): 'error': 'invalid_grant', 'error_description': 'authentication failure'

Error: Salesforce Input (309): Traceback (most recent call last): File "main.py", line 71, in pi_initRuntimeError: Internal Error: DecryptPassword - buffer too small

I believe that the root of this problem is that when you enter credentials in the tools on your computer, they are encrypted, not within the workflow itself, but somewhere else within the local computer. Thus, when you upload the workflow to Gallery and try to run it, the workflow is run on your Alteryx server computer and it does not know how to decrypt the credentials.

To solve this, you just need to open the workflow on the remote desktop your Gallery is hosted on and enter your credentials into the Salesforce tools there. By saving the workflow on the same computer it will be run on when ran via the Gallery, you should get around these credential problems.

2. Additionally, I also ran into error handling problems within the Output connector. An example of one of these was when a user would accidentally attempt to push a lead to Salesforce that already existed. With the basic configuration of the Salesforce macro, this causes an error and stops the workflow. I made some adjustments within the macro to simply skip leads already in Salesforce and not throw an error; I did the same for several other errors. Below is the macro with these adjustments:

I hope this helps some of you!

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

adendulu — Fri, 28 Aug 2020 15:29:28 GMT

I am still getting a 401 unauthorized error for my workflows that is preventing me from running the workflows on my scheduler

Get Outlook for iOS

If you wish to unsubscribe from receiving commercial electronic messages from TD Bank Group, please click here or go to the following web address: www.td.com/tdoptout
Si vous souhaitez vous désabonner des messages électroniques de nature commerciale envoyés par Groupe Banque TD veuillez cliquer ici ou vous rendre à l'adresse www.td.com/tddesab

NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, please go to www.td.com/legal for instructions.
AVIS : Message confidentiel dont le contenu peut être privilégié. Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière d'aller au www.td.com/francais/avis_juridique pour des instructions.

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

Jon-Knepper — Wed, 15 Jun 2022 15:27:50 GMT

Is this error still happening or was it fixed?

Re: Salesforce Connector v. 4.1 doesn't work on Server - fix it please!

AustinNesbitt — Wed, 15 Jun 2022 15:39:54 GMT

I was not able to get this working, so we are using the Simba Salesforce ODBC driver