Workflow only errors when scheduled.

Hello,

I get these weird errors when i have my workflow scheduled but when i run manually it's fine. I will get "Unable to translate alias" for all of my inputs when i look at the scheduler "error outputs" and then when i go into workflow dependencies and test them i get this "Format of the initialization string does not conform to specification starting at index 0."

any ideas?!

Workflow

Accepted answers

atcodedog05

Hi @alalko

Scheduler might need you to set complete absolute path for the resources(inputs/macros). Orelse it might fail to get the resources(inputs/macros) and fail. Since you are saying recently you changed the alias and then its failing, you might want to revisit the path set in workflow dependencies and change/edit them to absolute path. By clicking on edit you can again set the path and check.

All comments

mceleavey

Hi @alalko ,

When you are running it manually you're running it locally from your machine, but I assume when scheduled you're running it on the server?

If so, your connection strings when running from the server can't translate the alias of the server location, and so the server name on the connection string may need to be replaced with the IP address.

You can test this by trying to reach the alias of the server of the data source from your Alteryx server. If that fails, try to ping the IP.

Hope this helps,

alalko

Hi,

Actually it is scheduled to run on a desktop that is always on. I've been doing it this way for years. Recently I've changed the alias but it still works just fine when i run it manually.

-Austin

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703