Alteryx Server Knowledge Base

Gallery Data Connections for Greenplum throws LDAP authentication failure message

In developing workflows our users need to push workflows to server or scheduler that contain database connections.  This is a common source of errors if not configured properly.

Error: "You have found a bug" when saving a workflow to Gallery that involves a MySQL connection

We hope that you are as excited about this new feature as we are! The new Database Connection Share is a feature that will allow ease of access for your Alteryx users to your databases. The feature also allows the Alteryx Gallery and Database Administrators more governance over what connections are being made as well as who are making the connections. The Admin of the Gallery can create and manage their users' data connections.

Error: "failed: CURLerror (curl_easy_perform() failed) - code=60 msg='SSL peer certificate or SSH remote key was not OK'" when running a workflow.

Error: "[SQLState 08S01] fe_sendauth: no password supplied" when using Amazon Redshift and publishing to the Gallery.

Error: "SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031" when connecting to DB2 z/OS

Issue    When publishing a workflow to Gallery with user credentials and you run into the following: Entering credentials has been disabled   When configuring a new Gallery Data Connection the below error comes up when attempting to test or save the connection:   Credential usage is disabled as a result of encryption configuration. Please contact your server administrator.     Environment   Alteryx Designer Alteryx Server   Diagnosis    You can verify this issue in the AlteryxService logs after a service restart. During the startup you will see a message like the following: ERROR,8912,AlteryxService,,,,,,,,"AlteryxService_InitLocalEncryptedStorage_Error: Error importing keys to Microsoft\Crypto\RSA\MachineKeys\ directory in ProgramData: Access is denied. (5)"   Cause   The Alteryx Service account has insufficient permissions to the server's machine key directory (%ProgramData%\Microsoft\Crypto\RSA\MachineKeys) or specifically the Alteryx Machine Key which is used to encrypt/decrypt user credentials and Gallery data connections.    Solution   Check your Service Log On As Account. The user set as the Log On As user (the default is Local System account) will need to have specific permissions.   Run services.msc (CTRL+R, enter services.msc, and click OK) Locate the Alteryx Service and check the Log On As account Per the server help documentation, ensure the Service Account has Full Control over %ProgramData%\Microsoft\Crypto\RSA\MachineKeys** **If giving permissions to the full directory is not possible due to security reasons you can give it to just the Alteryx Machine key which starts with "3312". Also allowing Full Control over this machine key may fix the issue of the directory access does not. After granting permissions to the service account, restart the Alteryx Service  

Issue   When trying to enter Workflow Credentials from the Administration section of the Gallery, the credentials do not save and the message 'Validating' shows perpetually. The credentials are not saved.   You may also see this issue when trying to update the password for an existing credential.   Environment   Alteryx Server   Diagnosis   You will find the below errors in the logs:   Gallery logs: ERROR,,ErrorHandler,HandleError,,,::1,xxx-xxx,,,GET,/gallery/api/apps/pubKey/,400,14,Exception caught by ErrorHandler and marshalled to client,"AlteryxService_Client.Net.AlteryxServiceException: Credential usage is disabled as a result of encryption configuration. Please contact your server administrator.-> at AlteryxService_Client.Net.EncryptedStorageWrapper.GetPublicKeyParams(String server, String secret, String sValue)-> at Alteryx.Cloud.Server.Services.AppService.GetPublicKey()-> at SyncInvokeGetPublicKey(Object , Object[] , Object[] )-> at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)-> at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)-> at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)-> at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)-> at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)"   Service logs: ERROR,,AlteryxService,AlteryxService_GetPublicKeyParams,,,,,,,"CredentialHandler_ReadBody_Error: <Credential usage is disabled as a result of encryption configuration. Please contact your server administrator.>"   Cause   The Alteryx Service account has insufficient permissions to the server's machine key directory (%ProgramData%\Microsoft\Crypto\RSA\MachineKeys) or specifically the Alteryx Machine Key which is used to encrypt/decrypt user credentials and Gallery data connections.    Solution   Please see the solution in this article.   Additional Resources   How Workflow Credentials Work on a Private Gallery Troubleshooting "Invalid Username or Password" Error - Setting Up Workflow Credentials Access is Denied on the Alteryx Server