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.
- Alteryx Designer
- 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.