08-16-2019 06:33 AM - edited 08-03-2021 02:06 PM
"Unable to find connection 'x' " when workflow is scheduled
When running a workflow via the Scheduler (for Designer with Automation), the following error is observed:
Unable to find connection "x"
Environment
Diagnosis
1. Confirm that you are using Designer with Automation and not Alteryx Server. You can confirm this by opening the Alteryx System Settings from Designer underOptions > Advanced Options > System Settings. On theSetup Type page you will seeDesigner and Scheduler Onlyselected.
Alternatively, you can check in the drop-downfor the ConnectionNameConnect In-DBtool or theData Stream In tool:
Cause
The In-Database connection in use is aUserconnection; scheduling requires aSystem connection or a Fileconnection.
Solution A - System Connection
Solution B- File Connection
Additional Resources
After taking Solution B- File Connection, I have error message below when running workflow in Gallery(Workflow run well in Alteryx designer):
OCILogon2 Error: ORA-24960: the attribute OCI_ATTR_PASSWORD is greater than the maximum allowable length of 255 (Tool Id: 3)
Do you have any suggestions on how to fix this issue?
Use "Hide" instead of "Encrypt for user" for Password Encryption and the issue has been solved.
Hi all,
I am trying to save my Analytical app workflow to the Gallery, but i am unable to do that,
I am facing the issue like Unable to find the connection "abcd" , so the reason i am unable to save my
workflow, Any help on this would be highly appreciated.
Thanks in Advance!!!