Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Knowledge Base

Definitive answers from Server experts.

Troubleshooting "data connection is no longer available" error

miguelm
Alteryx
Alteryx
Created

Issue

A red exclamation icon is seen along with the following message in the Manage Data Connections window of Designer. This error can also been seen in Gallery.

This data connection is no longer available

SophiaF_0-1573118287521.png

Environment

  • Alteryx Designer
  • Alteryx Server

Diagnosis

One possibility for this error to occur is when all affected data connections are created in Gallery only and the connection has been lost for any reason.

Please attempt solution A first, if no success go to solution B.

Solution A

In Gallery data connections, remove the affected user from the data connection, then re-add the user:

1. Login to Gallery as an Admin (aka Curator).

2. On the left pane, go to Data Connections.

3. Select the "edit" link (pencil icon) for the affected data connection.

data_connection1.png

4. Go to the Users and Studios tab and remove the affected user(s).

5. In the same tab, re-add the same user by searching for him/her in the search field.

data_connection2.png

Solution B

1. Successfully perform a re-indexing by using the re-indexing app. Please reach out to Customer Support to ensure a re-indexing is needed and to follow the proper steps for it.

2. Perform the steps in Solution A.

Additional Resources:

    1. Gallery Data Connections FAQ
    2. Troubleshooting "Unable to translate Alias" with Gallery Data Connections
    3. How To: Create a Database Connection Share Through Gallery Admin