Error while promoting the workflow to an Alteryx server

Question

Hi Alteryx Users,

I am facing the below issue while promoting the workflow to an Alteryx server in our environment.

DBA team granted the required permission to access the tables.

Even after proper access rights to tables, I get the attached error messages for two workflows.

SELECT p.ITEM_NBR, p.PRICING_EVENT_CD, p.CHANGE_EFF_DATE, p.CHANGE_EXP_DATE, p.Cust_RETAIL_AMT, t.TRAIT_NBR FROM GBPRICMG.ITEM_FUTURE_CHANGE p LEFT JOIN GBRULES0.KEY_SELECTION_RULE t ON t.RULE_ID = p.RULE_ID WHERE ~SELECTSQL~

No Columns Returned.

Error: Dynamic Input (2): Unable to translate alias

Could you please let us know how to resolve this error.

Regards,

Rajesh.

Daily Checks_Error.jpg

RPT Set Complete_170924.jpg

cpet13 · Accepted Answer

@Rvelan12 It seems you have two errors, is that correct? No Columns Returned, and Error: Dynamic Input (2): Unable to translate alias. Do you have the connection setup on your server, and are you using that when you build the workflow instead of a local ODBC connection?

andremello · Accepted Answer

The errors "No Columns Returned" and "Unable to translate alias" can be caused by several factors.

Try the following:
Check SQL Syntax: Ensure columns and aliases are correct, and that ~SELECTSQL~ is resolved properly.

Dynamic Input Tool: Simplify the query or check alias handling.

Test as Static Query: Run the query in the Input Data Tool to check results.

Permissions: Confirm correct access rights to the tables.

Driver Compatibility: Verify the correct database driver is installed locally and on the server.

Workflow Configurations: Ensure proper database connection setup for both environments.

If the issue persists, provide more details about the dynamic SQL setup.