DCM connections no longer available

Met with this site this morning after using DCM connections since Feb with no issue. The DCM's I created and shared to the server are there, but I cannot access the DCM connections locally anymore. Any thoughts?

Screenshot from file > manage connections

Error Message

Accepted answers

Jacobgallegos00

After much digging, pretty much the last 5 hours. Crawling through the file structure. I found a solution.

If you run into this issue follow these simple steps

1) close alteryx

2) navigate to C:\Users\<username>\AppData\Local\Alteryx

i) where <username> is replaced with your username

3) delete the following files

4) open alteryx and re-establish your connections by syncing with the server / re-creating the connections.

NOTES:
using Version: 2022.3.1.450 NON-admin version

admin version files may be located under program data and not appdata, however I cannot confirm.

All comments

caltang

Does this help?

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Why-does-Alteryx-lose-connections/td-p/446927

Did you change any configuration in between the time you last checked and today?

Jacobgallegos00

Tech support did a bios flash on my computer. What drivers would make this issue occur?

I have multiple types of DCM's set ups, email server, IBM DB2 ODBC, Postgresql, Oracle.

Jacobgallegos00

found this log

-- removed some info that looked sensitive

Alteryx Designer x64 - 2022.3.1.450
Type: Dcm.Net.RequestFailed
Message: Database call has failed.
Source: AlteryxDcm.Net
OS Version: Redacted
OS Is x64 Capable: True
Selected Plugin: None
Processor: Redacted
Private Memory: 356147200
--------------------------------------------
at Dcm.Net.AlteryxDCM.HandleFailedRequest(String responseJson)
at Dcm.Net.AlteryxDCM.GetResponse(String responseStr)
at Dcm.Net.AlteryxDCM.<DispatchRestCallImpl>d__57.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Dcm.Net.RestHandler.<DcmRestCall>d__3.MoveNext()

SergioR

Thank you for this solution!

dvortsis

Thank you so much! Works like a charm.

BharathKG

Goto file--> Manage connections--> synchronize

you 'll get you credentials on dcm

CatheyH

IF this happens after upgrade, and the above solution doesn't work, try this:

On the DCM Credentials - go into Gallery and DCM credentials and re-enter ALL you passwords. If you can't remember any then you will need to delete them. Once all your passwords have been re-entered, Alteryx recognises that these are the most up-to-date credentials and will use these to create credentials on your desktop when you synchronise. You will continue to get errors until ALL credentials have been updated.

The principle is the same with Gallery connections if you are getting errors - go through ALL of your connections and reenter/save any passwords where they have been hardcoded into the connection string. Once they have all been done you should notice that the sync button starts working again. You might get a lot of red exclamation marks - click on any one of these to make them go away. If there is still a problem, one thing I have noticed helps (but no idea why) is to File/Open Workflow/Server/Select your gallery then CLICK on any one of your apps/workflows. No need to open it - close the window then try syncing again.

For emphasis: You WILL continue to get errors until ALL credentials have been updated - Alteryx refuses to synchronise unless ALL credentials/connections are error-free.

Note that if you have deleted / recreated any credentials in trying to fix the issue, they will need to be re-entered into your workflows/apps.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703