Workflow only errors when scheduled.

[alalko]

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?!

[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,

M.

[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

[atcodedog05 · Accepted solution]

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.

[alalko]

This solved it! Thank you very much