DCM Connections fail after Host Recovery

EdP

Issue

DCM Connections fail after Host Recovery

Example errors

 

Error SQLDriverConnect:[Microsoft]ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'CSUser'.(ToolID: 1)

Error for AWS: The request signature we calculated does not match the signature you provided. Check your key and signing method.(ToolID: 1)

Error for Snowflake: Error SQLDriverConnect: [Simba][Snowflake] (31) Password not found.

 

Environment Details

• Alteryx Server
  • 2021.4.2.47792 (Patch 5)+
  • 2022.1.1.42590 (Patch 3)+
  • 2022.3.1.430 (GA)+
• MongoDB
  • All supported embedded and user-managed versions (See MongoDB Schema Reference for supported version compatibility)

Cause

 

Defect TGAL-7256

 

 

Resolution

IMPORTANT: DO NOT sync your DCM connections from Designer prior to following the steps below or you may break the connections stored in Designer.  See Common Issues section for details.

 
The following steps must be repeated for every DCM Credential.

Option 1 (Recommended):

1. Login to your Server UI.
2. Click on 'DCM Credentials'.
3. Click on Credential Name.
4. Click 'Edit' in the top right corner.
5. Reenter the password in the 'Password' field.
6. Click 'Save' in the top right corner.

Option 2:

1. Open Designer.
2. Navigate to File > Manage Connections.
3. Click 'Credentials' in the left column.
4. Click on Credential Name.
5. Click 'Edit' in the top right corner.
6. Reenter the password in the 'Password' field.
7. Click 'Save' in the top right corner.
8. Click 'Synchronize" in the left column.
9. Click the name of the Gallery where DCM connections are failing.
10. Click 'Done' after the sync completes.

In scenarios where each user has numerous DCM Credentials to be updated, it is possible to modify the MongoDB so each user only needs to sync their DCM Connections from Designer back to Server.  This method is only recommended if the options above are not feasible.  Please contact support@alteryx.com for assistance with this method.
 

Common Issues

After performing the Server Host Migration, be careful when syncing DCM connections between your local instance of Designer and Server.  You do not want to sync DCM connections from Server until after one of the above workaround has been applied.  When performing the DCM sync, if you see the following icon next to any of your connections, it will sync the broken connection from Server on to your local machine which will result in those connections failing when used on your local instance of Designer:

*If the arrow is pointing up and the DCM connection is currently working, it is safe to sync to Server which will repair that connection on Server.  If you have a combination of icons with arrows pointing up and down, it is not recommended to sync as it will repair some of the connections on Server (arrow pointing up) and break some of the connections in Designer (arrow pointing down).

Additional Resources

• Server Host Recovery Guide
• DCM - Server
• DCM - Designer