Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

DCM connections no longer available

Jacobgallegos00
6 - Meteoroid

Jacobgallegos00_0-1682540076856.png

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

10 REPLIES 10
caltang
17 - Castor
17 - Castor

Does this help? 

 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Why-does-Alteryx-lose-connecti...

 

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

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Jacobgallegos00
6 - Meteoroid

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
6 - Meteoroid

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()

Jacobgallegos00
6 - Meteoroid

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 

Jacobgallegos00_0-1682629467729.png

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.

 

 

 

SergioR
5 - Atom

Thank you for this solution!

sadesatishbabu
5 - Atom

Hi ,

 

getting the below error while i am synchronizing. Please find the attachment.

 

The request has failed (0).

 

Could you please check and help us to fix this issue.

 

 

Thanks,

Satish.

 

 

 

Jacobgallegos00
6 - Meteoroid

I no longer have an Alteryx License. I moved out of the department that was using that. I cannot assist with troubleshooting due to not having that anymore.

dvortsis
5 - Atom

Thank you so much! Works like a charm. 

Treyson
13 - Pulsar
13 - Pulsar

this immediately fixed my problem

 

@Jacobgallegos00 you rock.

Treyson Marks
Senior Analytics Engineer
Labels