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.
Publishing to Gallery fails with a database authentication error. However, the workflow runs fine in Designer. Example error message:
Error SQLDriverConnect: [Simba][ThriftExtension] (2) Error occurred during authentication.
Access to supported Database
Diagnosis There are a variety of root causes for database authentication issues. This articles covers the usage of Saved Data Connections also known as Aliases in Designer and it applies when changes to the database connection information. A common example would be a change of the database password . The workflow runs fine in Designer, but errors when publishing to gallery.
To exclude other issues please go through the below diagnosis steps.
Determine the User that is overwriting the SystemAlias. This can be done using the above mentioned KB article.
Check that the UserAlias.xml file contains the same connection as the SystemAlias. The UserAlias.xml files can be found under %APPDATA%\Alteryx\Engine\UserAlias.xml. Make sure to check the UserAlias.xml file of the Run As User or Workflow Credentials User. Check whether the same database connection as in the SystemAlias also exists in it. It can be found in the AliasId tag.
Remove the UserAlias.xml file of the user identified above.