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.
on 10-22-202112:54 PM - edited on 10-22-202112:54 PM by gtorres8
When trying to connect to an Athena database connection, the following error occurs:
ERROR: Failed to decrypt data: Key not valid for use in specified state.
Alteryx Designer / Alteryx Server
Input Data Tool
Output Data tool
Amazon Athena Database
Athena ODBC Driver
The key used for connecting to Athena will not work when other users attempt to execute workflows if the worker machine does not have the ODBC authentication option configured to encrypt the password for all users of the machine.
Enable the setting to encrypt passwords for all users of the machine.
Open ODBC Data Source Administrator.
Find the Athena Data Source in question.
Click on Configure.
Click on Authentication Options.
Click on Password Options.
Select the "All Users of this Machine" radio button and click OK.