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

11 REPLIES 11
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
Managing Partner
DCG Analytics
Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels