community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
New Data Science Blog

Check out the latest post: All Models Are Wrong

READ MORE
Announcement | We'll be doing maintenance between pm 4- 6pm MT, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

Alteryx Scheduler unable to run when connecting to In DB

Highlighted
Atom

My issue is that when I run my workflow with Alteryx open the workflow competes with no errors or issues.  However, when I create a schedule to run the same workflow I get errors.

 

I am trying to connect to my local SQL express database. The error message reads:

 

"Unable to find conncetion sql express connection"

 

The credentials appear to be correct as I can connect to the database when Alteryx is open.

 

Does anyone know the potential causes of such a problem which I can investigate?

 

Thanks

Alteryx
Alteryx

@Rfallis As per my email the error message you are encountering indicates that scheduler is unable to locate the connection referenced in the connection string of your input tool. The most common causes for this to occur are that the ODBC DSN or alias referenced doesn’t exist on the workstation/server running scheduler, that the ODBC DSN or alias name are not exact matches, or that the ODBC DSN or alias are defined as a User DSN or User alias instead of as System. Please note that User defined DSN’s and aliases are only available to the user that defined them. As such they would not be available to the scheduler process.

 

In order to further isolate the cause of the issue I will need some additional information regarding your workflow, ODBC settings, and Alias configuration. As this information is likely sensitive please provide the information I requested in response to my email instead of via community.

 

Labels