This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm new to Alteryx. I need to create a process to obtain a date value from a table in my database and use the date value to pass in the filter inside a Salesforce Input tool. Hence, first I created a Batch Macro that contains a Control Parameter, an Action Tool that connects to the Salesforce Input tool (please see the attached "Figure1"). I then created a Workflow that contains a Data Input Tool to grab the actual date value in my database and connects the Data Input Tool to the Batch Macro (please see the attached "Figure2"). Whenever I tried to run the Workflow, I got the error message below:
Error: Batch_Macro_Eric (9): Record #1: Tool #1: Traceback (most recent call last): File "main.py", line 73, in pi_init RuntimeError: DecryptPassword only works with User and Machine encrypted passwords.
However, the Alteryx support created the same Batch Macro and Workflow on his machine and was able to run the Workflow successfully. We suspected there's some specific environment or security setting on my machine / Alteryx Designer. I have not been able to locate the setting. Can you please advise?
The error you see is triggered by the Salesforce input tool - when using this connector, your access credentials (username, password and token) will be encrypted on the machine where the workflow/macro was build and when you move it to a different computer, this will be unable to decrypt these.