"Unable to translate alias" when trying to connect to DB using dynamic input tool

Attaching below screenshot of my SQL string (nothing wrong with it) and Dynamic Input configuration.

I can connect to the table just fine and pull data using a normal input tool. I can also see the table's contents just fine from WITHIN the Dynamic Input tool's preview pane. So why is it that when I run the workflow the Dynamic Input tool gives the error: Error: Dynamic Input (3): Unable to translate alias aka:5f7c2d23f560990303d9a679 ?

Edit: It's worth mentioning that I don't get this error if I use a different connection. The admins set up the connection strings as "galleries". Attaching screenshot below to explain what I mean.

What could be causing connection 1 to be working fine but connection 2 giving unable to translate alias error, even though it works with the simple input tool? Can you give me some pointers to tell the database admins what changes they need to make to the string?

dynamic error.PNG

Galleries.PNG

Workflow

Accepted answers

BrandonB

Instead of "Replace a specific string", can you try the "SQL: Update WHERE Clause" instead?

All comments

joshuaburkhow

Curious to know if you could reformat your connections to use DSN-less strings like this https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-format-common-ODBC-DSN-less-connection-strings/ta-p/467506 and see if that helps you

BrandonB

Instead of "Replace a specific string", can you try the "SQL: Update WHERE Clause" instead?

AkisM

Hi @BrandonB . I have no idea why, but that worked. Can you elaborate as to why? Also, in the future I might indeed need to replace a specific string rather than just the where clause. How do we solve the issue of "unable to translate alias" popping up when the "replace a specific string" option is selected?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703