Originally posted in "Server"
Our client has set up an Alteryx Server in which several different users upload their own workflows and schedule as need be. Things run smoothly for the most part, but there are two specific workflows that each write data to different tables within SAP HANA (which has been set up as a Gallery connection within the server). Whenever I try to publish these workflows to the Gallery and subsequently run them, I get an "Unable to translate alias..." error for that output tool. I also can't select that output in the Manage workflow assets option when saving to the Gallery. Another user also encountered the same issue as me.
However, the owner of the workflow can publish these two workflows to the Gallery without any error messages. I should also note that there are other workflows on the Server that use the same Gallery connection and those run without any alias errors (and I'm not the owner of those workflows either).
Any ideas on what might be causing this issue, and why they are only pertinent to these two workflows? It's strange to me that a Gallery connection would work for some workflows and not for others.
When the workflows were built, was the connection already shared from the server to the user and then built into the workflow?
Or was the same Alias name used that existed on the server?
Does the system/application Windows account have the same permissions to that connection?
I didn't create the workflow initially, but I believe your first line is the case. There are other workflows that run on the same server (which is hosted on an AWS instance) that don't encounter this issue. And this doesn't happen to the owner of this workflow, just me and (at least) one other user.
You might be using the pre-configured connection string in the output tool. Try replacing the exiting output tool with a new one and manually enter the connection string.
I tried that but I still get the same alias error
Does your own account have the same level of access to HANA?