topic error while saving workflow in Gallery: RuntimeError: Internal Error: DecryptPassword - in Alteryx Server Discussions

error while saving workflow in Gallery: RuntimeError: Internal Error: DecryptPassword -

NicolasDestombes — Wed, 15 Apr 2020 15:44:03 GMT

Dear all,

My App works in Desktop but when I try to save it in Gallery, I have the following errors for 2 Salesforce Input Tools:

Traceback (most recent call last): File "min.py", line 71 in pi_init

RuntimeError: Internal Error: DecryptPassword - buffer too small

if I bypass the error messages, I can save my App but when I run it, I get the error messages back and con't complete the Run.

Could you help?

Thanks

Re: error while saving workflow in Gallery: RuntimeError: Internal Error: DecryptPassword

ToddLicking — Wed, 23 Sep 2020 13:19:54 GMT

Has this been fixed? Salesforce is a dominate force in the CRM/CPQ...industry and this connector will become more & more important to Alteryx users. I can get this working in Designer, both simple workflows and complex macros. However, I can't save or run any workflow to the server because of this bug.

Re: error while saving workflow in Gallery: RuntimeError: Internal Error: DecryptPassword

NicolasDestombes — Wed, 21 Oct 2020 08:10:13 GMT

Apologies for the late answer. The issue came from an old version of the SF connector while I was using a new Alteryx version. It is fixed by using the new SF connector version.

Thanks

Re: error while saving workflow in Gallery: RuntimeError: Internal Error: DecryptPassword

JuanATX — Tue, 01 Dec 2020 14:52:37 GMT

Hi Nicolas - do you happen to know which version you were working from/ moved to?

Re: error while saving workflow in Gallery: RuntimeError: Internal Error: DecryptPassword

brucedataguy — Tue, 23 Feb 2021 17:54:53 GMT

HI Nicolas,

I understand your answer to mean that you have a newer version of the SF Connector on your local machine and an older version of SF Connector on your Alteryx Server?

I have same problem after upgrading my local Designer to 2020.4 which now uses Python 3.8, while our Alteryx Server which recently upgraded to 2020.4 seems not to have upgraded and uses the SF Input Tool v4.1.0 but based on Python 3.6.

Thanks for any further insight you can offer.

Bruce

Re: error while saving workflow in Gallery: RuntimeError: Internal Error: DecryptPassword

danishimam — Mon, 29 Mar 2021 18:29:10 GMT

Hello @NicolasDestombes

I am getting exactly same issue as you have mentioned. I have Designer 2020.3 in local laptop and Server 2020.3 on remote server with same Salesforce Input tool v4.1.0.

My original workflow was build using Server Designer on the server and published to Alteryx Gallery, no issues there and workflow is scheduled to run every day, everything is working fine.

BUT, today i installed local Designer 2020.3 (same version) on my laptop and opened the workflow from Alteryx Gallery (the original workflow which was build using Server Designer) and when im running it is giving exactly the same error as you mentioned, although the versions for both designer and salesforce input tools are same.

i tried to make a POC (on my local designer), connecting with Salesforce using Input tool, configured the credentials, tested and everything worked as expected. i tried to push this new POC workflow to Alteryx Gallery and got exactly same error your mentioned, although the workflow was saved to Gallery. BUT when i opened that workflow in server designer then giving same error.

Not sure what is the issue as both local and server designer and salesforce input tool are exactly same version. Requesting some help on this.

Thank you

Danish

Re: error while saving workflow in Gallery: RuntimeError: Internal Error: DecryptPassword

brucedataguy — Wed, 31 Mar 2021 14:43:52 GMT

This error is because of the change in Alteryx Designer 2020.3 and later to upgrade from Python 3.6 to Python 3.8.

https://help.alteryx.com/current/designer/upgrade-python

There are some local (your machine) and server changes that have to be made.

Download latest version of Salesforce Input tool on both your machine and server. It is still v4.1.0, but something like Version 12 which was updated in January or February 2021. https://gallery.alteryx.com/#!app/Salesforce-Input-Tool/59b84ccbeffc2a09d4057c43
Make registry change on your machine.
Make registry change on server.
Republish workflow to server.

The registry change is explained in this document:

https://drop.alteryx.com/public/file/SczPfkD_vkmSHm2v0AGmSg/Alteryx%20Connectors%20Tools%20-%20Allow%20Encryption.docx

You can see my experience and the progression of troubleshooting in this Community post:

https://community.alteryx.com/t5/crmsupport/casepage/issue-id/00424867/issue-guid/5002R00001HDY8V/issue-provider/salesforce

It should now work.

Hope this helps!
Bruce

Re: error while saving workflow in Gallery: RuntimeError: Internal Error: DecryptPassword

brucedataguy — Wed, 31 Mar 2021 14:47:41 GMT

Hi Todd.

See my post as I experienced and got help from Alteryx Support to solve.

I hope you already fixed it as I see your post is from September 2020!

Bruce

Re: error while saving workflow in Gallery: RuntimeError: Internal Error: DecryptPassword

AaronDobbins — Thu, 01 Apr 2021 15:29:55 GMT

Thank you for the documentation on the registry key change. It worked when I made the change on the server and published the workflow to gallery as described. Getting the key added on local machines will be a different animal. I need to be able to describe what this registry change does, in practical terms for our security team. Does this expose the password for people to see? What implications does this change have beyond making the connector work? The documentation didn't have clear notes on that.

Re: error while saving workflow in Gallery: RuntimeError: Internal Error: DecryptPassword

brucedataguy — Thu, 01 Apr 2021 16:10:23 GMT

Hi Aaron.

Under prior version of Salesforce Input tool, which was macro-based, my understanding is the credentials were passed "in the clear".

With the introduction of the Python-based SF Input tool, this was changed from macro.

My understanding is this encryption parameter allows for the exchange of the credentials, but you're right -- the documentation refers to "hide encryption" -- what does "hide encryption" mean?

I suggest that you raise a support ticket to get this answer. You can find who answered my question by using the link to the Community Support ticket found in my response to your post.

Best,
Bruce

Re: error while saving workflow in Gallery: RuntimeError: Internal Error: DecryptPassword

danishimam — Thu, 01 Apr 2021 16:51:59 GMT

Thank you @brucedataguy for the details.

I installed the latest version of "Salesforce Input Tool v4.1.0" on the Server Designer 2020.3.

But when i configured the "Salesforce Input Tool" its giving below error, although the credentials were validated successfully. Any pointers what might be the issue?

Thank you,

Danish

Re: error while saving workflow in Gallery: RuntimeError: Internal Error: DecryptPassword

brucedataguy — Thu, 01 Apr 2021 18:03:09 GMT

Hi Danish,

This error I did not see before.

You might google this "Traceback" error.

It seems like you might have some mismatch either in the version of SF Input tool on your local machine vs. server, or the registry needs to be changed on *every Server worker node*, and your local machine.

If you don't find anything, raise a ticket with Support. They have been very helpful on this topic when I approached them at different steps along the way to troubleshoot what was going wrong. My guess is they will immediately know what causes this problem.

Let me know what you find out.

Bruce

Re: error while saving workflow in Gallery: RuntimeError: Internal Error: DecryptPassword

AaronDobbins — Fri, 02 Apr 2021 18:55:19 GMT

I received a response from Alteryx support re: what does "hide" encryption mean. I wanted to post to this thread for future reference:

By default, the Alteryx Products published Python SDK Data Connector Tools (Azure Data Lake, Google BigQuery, OneDrive, Salesforce Input, etc.) utilize Encrypt for Machine (follow link below for additional details) credential encryption. With this encryption applied, the decryption of the credentials can only occur on the device generating the encrypted credentials.

The PythonAllowHideEncryption registry key permits the supported Alteryx Products Python SDK Data Connector Tools to be successfully ran on the Gallery. This registry entry, required both on the local Designer machine and the Server machines(s), updates the encryption method to Hide when publishing to the Gallery.

https://help.alteryx.com/current/designer/password-encryption

Hide: This hides the password using minimal encryption.

The key to decrypt the password will reside in Alteryx so there is no loss of functionality.
A copied tool will work on any computer for any user and they will be able to read/write any SQL.
Analytic Apps and Schedules will be able to use this password.
We do not recommend using the Hide method when sharing workflows with individuals that you would not want to have access to your credentials.