This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 09-13-202102:25 AM - edited on 09-13-202103:02 AM by MarkelioH
If you are trying to publish your workflow on your Alteryx Gallery (assuming the Alteryx Server is not hosted on the same machine), you will get this error message:
Can't run the workflow there is no connection to the designer. There is no file cached on the system, the workflow can not be run.
ODBC data source
The behavior seems to be intermittent and creates an extra XML tag to prompt the user to enter their credentials when a connection is established to a database via DSN using an Input Data tool.
While trying to validate the workflow, the Alteryx Engine won't be able to find either the cached file (if you have ticked the box) or reach the credential stored within the DSN hence the error occurs.
You would need to remove the XML tag "<AskAQuestion>...</AskAQuestion>" prior to publishing your workflow, run it locally to verify you do not get errors or prompts, and then publish your workflow.
If you are not able to see the XML feature in Designer, you can follow the steps in this article to enable it.