Setting DB String via Macro Control Param / Action Doesn't Work on Server

I have a workflow that uses a batch macro to dynamically set the DB connection string on a Data Output node as in the image below. I set up a "dummy" DB connection (which is a valid one), then pipe in the real one I want to use (environment specific) via the macro's Control Parameter at runtime. Everything works great locally, but when I publish to Alteryx Server I get an Unable to translate alias message also shown below.

Any ideas of what I can try?

Server

Accepted answers

All comments

atcodedog05

Hi @PaulFields2

By seeing this post of yours (link) I am guessing this issue is solved.

The issue here is I can see you are using saved data connection alias which was configured on your desktop. Now when you move the workflow to gallery and try to run it Gallery doesn't have the saved data connection alias hence you are getting the below issue. The workaround is to use actual connection string or you can ask the gallery adim to configure this saved data connection alias

Hope this helps : )

PaulFields2

Thanks for your reply. Not sure how I implied the issue was fixed . . . it isn't.

I did ask my server admin to create a saved db connection, but unfortunately because of the sensitivity of the environment (bio-pharma) I am not allowed to share the DB password for production with him.

I'm going to shift to using an (.indbc) connection and see if that works.

Thanks

apathetichell

can you share the config of your action tool? It should be repalceable. There may be a second parameter in the same input data that you need to change as well though. Quotes can be fairly specific on string replace as well - especially with DSN...

points to @atcodedog05 for noticing that this was Oracle.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703