on 10-22-2021 12:54 PM - edited on 03-31-2022 03:00 PM by gtorres8
When trying to connect to a data source, the following error occurs:
ERROR: Failed to decrypt data: Key not valid for use in specified state.
The key used for connecting to the data source 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.
Same error could happen with HIVE connection:
Tool 8 - Error SQLDriverConnect: [Hortonworks][DriverSuppport] (1030) Failed to decrypt data: Key not valid for use in specified state.{Microsoft][ODBC Driver Manager] Driver's SQLConnectAttr failed
The same solution works for HIVE connection.
Hi, This same error occurs for google big query data connection while publishing the workflow. But there is no options in Simba Google big query driver for password encryption as it uses Service Authentication as OAuth authentication using the json file.
Kindly please help how to overcome this issue.
Having error with Simba ODBC Driver for Google BigQuery using Service Authentication with email and .json key file. It run successfully locally; I can also run it in Designer on the Gallery server, but receive error when publishing or attempting to run from Gallery. Thank you!