topic Data Connections in Gallery only working after updating the password in Alteryx Server Discussions

Data Connections in Gallery only working after updating the password

meenu1995 — Thu, 11 Feb 2021 19:10:53 GMT

I am trying to create an Oracle data connection in Gallery. Whenever I create and try to use it in my workflows it won't work and I get the ORA-01017 error :invalid username/password; logon denied error. But if I edit the password in the Gallery by replacing "__EncPwd1__" in the connection with the same password and save it again ,it's working. Is this expected behavior ? I am using Alteryx server 2019.3.

Re: Data Connections in Gallery only working after updating the password

JagdeeshN — Wed, 17 Feb 2021 17:08:51 GMT

@meenu1995

Are you trying to connect to the Gallery Data Connection from Alteryx Designer on your desktop?

Also when you created the connection on Gallery, did the 'Test Connection' work?

Best,

Jagdeesh

Re: Data Connections in Gallery only working after updating the password

meenu1995 — Wed, 17 Feb 2021 16:17:00 GMT

Answers to your questions @JagdeeshN :

Are you trying to connected to the Gallery Data Connection from Alteryx Designer on your desktop?

Yes and I get the visual Query builder pop-up but I am getting the error as below when I test the query in SQL Editor:

Error: Input Data (125): OCILogon2 Error: ORA-01017: invalid username/password; logon denied

Also when you created the connection on Gallery, did the 'Test Connection' work?-Yes it is successful in Gallery

Re: Data Connections in Gallery only working after updating the password

JagdeeshN — Wed, 17 Feb 2021 17:10:15 GMT

@meenu1995

Thanks for the clarification.

Can you also confirm if you are using a service/database account on the server to create the connection?

Best,

Jagdeesh

Re: Data Connections in Gallery only working after updating the password

meenu1995 — Thu, 18 Feb 2021 07:41:11 GMT

@JagdeeshN

I am using my service account that has access to the database for the setup.The same service account work when I setup it in credentials.

Re: Data Connections in Gallery only working after updating the password

CristianoJ — Thu, 18 Feb 2021 18:20:21 GMT

@meenu1995,

Replacing the string ""__EncPwd1__" in the connection string of the data connection in the Gallery is the right thing to do in order to update the password of your existing data connection. Make sure you save it.

After you save it, also make sure to synchronize your connections in designer with the Gallery by going to Designer > Options > Advanced Options > Manage Data Connections > click Sync All

Re: Data Connections in Gallery only working after updating the password

meenu1995 — Fri, 19 Feb 2021 14:21:38 GMT

@CristianoJ I am not trying to update the password but my data connection is working only when I update the connection string with the same password after creating it.

Re: Data Connections in Gallery only working after updating the password

CristianoJ — Fri, 19 Feb 2021 15:17:39 GMT

@meenu1995,

Clear cache on your browser or open a Incognito window (chrome)

May also try to to into C:\Users\<username>\AppData\Roaming\Alteryx\Engine and rename the file galleryallias.xml to galleryalias.xml.old. Close designer and open again.

Re: Data Connections in Gallery only working after updating the password

meenu1995 — Mon, 22 Feb 2021 11:57:25 GMT

@CristianoJ I have tried that and it didn't resolve the issue.I also tried to connect from other users designer ,and it behaves the same way for them as well when they tried to connect to the data connection.