Issue with Server Data Connections after Updating to Version 2024.1.1.49

Question

Hello,

I recently updated the server to the latest version 2024.1.1.49 and Designer to Version: 2024.1.1.49 Patch: 1.

Since the update, I have encountered an issue with updating Data Connections from the server. The DCM shows the following error: "Incorrect decryption parameters" on the Desktop side.

Additionally, there are errors in the Manage Data Connections window, and the Sync All function does not perform any actions.

Data Connections are showing like this in the Server, but if I try to open any of them, there is just a blank area.

Can anyone assist with resolving this issue?

Thank you in advance!

CatheyH · Answer

@pcieslak  If they are using the same credentials, hopefully the coded solution above will work for you.

Otherwise this is probably worth raising as a ticket (please come back afterwards and tell us the result!) For us it wasn't possible to simply update whichever ones that were corrupt - it is more fundamental than that. It is almost as if Alteryx won't allow you to use any of the connections until every single one has been either verified or removed.

pcieslak · Answer

We recently updated from 23.2 to 24.1 and are experiencing this same issue. We have over 150 credentials so manually updating each individually is not feasible. Are they any other troubleshooting options or workarounds to fix these the corrupt parameters or at least help identify which credentials are corrupt?

MikeFranklin · Answer

@CatheyH - thank you for your reply.  Adding to your solution steps below with the steps to complete the same via command prompt.  Referencing @esar 's last screen shot, attempting to update the data connection through the gallery resulted in a blank, grey, screen, so we could not immediately complete this online.

Command prompts to execute:

* Navigate to the Alteryx\bin file path

cd "D:\Program files\Alteryx\bin"

* Navigate to the mongo shell

mongosh -u user -p password -host localhost:##### AlteryxGallery

- replace password with the password (not the admin password) in your system settings: controller > persistence> database > host

- replace localhost:##### with the host name in your system settings: controller > persistence> database > host

* Update all passwords

db.getCollection("dataConnections").updatemany({},{$set : {PasswordSecured:''}})

- note, we only have 5 data connections with 1 encrypted password causing the issue, so 'updatemany' was acceptable for us.  If you have more connections and want to attempt to target the update, you can run the script below instead by targeting the specific connection to update:

db.getCollection("dataConnections").update({},{$set : {PasswordSecured:''}})

You can now access the data connections through the gallery to update all necessary passwords.