HI
Using Alteryx Server 11.7, I've set up a shared connection.
I see that connection in designer (11.7 as well), and I'm able to use it.
However when I try to publish that to the gallery, I get a mysterious error
While trying to find out what's going on, I tried to check the workflow dependencies, and then I get:
What's causing this?
I've already tried restarting atleryx, clearing the connection history, etc ...
Thanks for any insights!
I have solved this issue by closing designer, removing my access to the connection, and sharing it with myself again. If anyone knows the actual cause of the issue or a better solution though I would be curious.
Hi @Nate1
thanks for the suggestion but that doesn't solve the issue. I've raised a support ticket, will post here if that leads somewhere.
Hi @JoBa,
One other time when I get a similar error I know the cause was that I renamed the connection but didn't update the password on the gallery from the encrypted value "__EncPwd1__". When I saved the connection again with the proper password it started working.
I also think in my case the cause might be changing studios. It seems whenever I change the connection doesn't work anymore even though it is shared at the user level. I am on 2018.1 and when I try to connect I get this message.
Please keep me updated on the support ticket outcome. Thanks!
So after a very useful call with support , the main issue is solved and other problems were confirmed to be known bugs:
There was nothing wrong with the data connection defined in the gallery. The fact that I could create new workflows in designer using that connection is the simple evidence of that.
First some other findings:
Finally, how to correctly use gallery connections:
By the way, only after understanding this process, the last sentence "Lastly, make sure that the server machines are 'signed in' to the gallery so they can receive the shared connections." which I found on this post made sence to me...
Quite a hassle, and badly documented, all of this. If you ask me the gallery connection are a good idea and certainly an improvement from connection management point of view (no more sharing all those connectivity details with users, creating DSNs everywhere,...) but if you ask me, the implementation is quite sloppy and the usage is overly complicated...
Hope this helps those with the same problems ...
I am experiencing what sounds to be a similar issue. Has any of this been resolved?