Gallery connection works in Designer but not in the Gallery
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have two workflows. One workflow called Main has a Crew Runner tool and calls a sub-workflow called Step1. I run Main which in turn kicks off Step1. Step1 has an input tool using a Gallery connection to SQL server. All runs fine from Designer on my PC. When I save it to the Gallery and try to run it I get connection alias can't be translated when I run the Main workflow. I can run the Step1 workflow from the Gallery on its own. So the difference is running the Main workflow from Designer locally versus running it from the Gallery. I don't understand why when I run the Main workflow from Gallery the connection in Step1 can't be translated. Can you help me with some troubleshooting hints? I'm thinking it may be a permissions issue?
- Labels:
- Connectors
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @shavar ,
One thing that could be happening is an issue related in the topic below and it was the exact issue I was experiencing in a workflow of mine.
If your connection is inside a macro, this macro needs to be in the same folder as your workflow to be able to translate the alias.
Let me know if that works for you.
Best,
Fernando V.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
We are facing the same issue, but it does not involve Macros. Any thoughts on how to troubleshoot / correct the issue?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The most common use case for this issue your database connection has not be setup with the system dsn and or the gallery does not contain the right drivers or possibly the correct drivers. You must use the system DSN in the setup for the Gallery to use since you are sharing it with the server.
Hope that helps
DanM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The connections that are failing in the Gallery now, used to work prior to an upgrade to 2018.3.
