Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

In-database - "Unable to find connection 'x' " when workflow is scheduled

Alteryx
Alteryx
Created

"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

 

  • Alteryx Designer
    • Designer with Automation
  • Windows Operating System
  • In-Database Connection

 

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 under Options > Advanced Options > System Settings. On the Setup Type page you will see Designer and Scheduler Only selected.

 

Spoiler
designer plus scheduler setup type system settings.png
2. Confirm the In-Database connection is setup as a User connection. You can check this from Designer by navigating to Options > Advanced Options > Manage In-DB Connections and choosing the Data Source and Connection name you are using. It will show next to the name of the Connection:

 

user indb connection.png

 

Alternatively, you can check in the drop-down for the Connection Name Connect In-DB tool or the Data Stream In tool:

 

connect INDB connections.png

 

 

Cause

 

The In-Database connection in use is a User connection; scheduling requires a System connection or a File connection.

 

 

Solution A - System Connection

 

  1. Follow the steps in this article to set up a System connection: How To: Create an In-Database Connection
    1. This will require admin permissions. Please see the following article for more information: Unable to create System Connection/System Connection type missing

 

Solution B-  File Connection

 

  1. Follow the steps in this article to set up a File connection: How To: Create an Alteryx In-DB Connection File
  2. The .indbc file will need to be available to the Run As User or the user running the Alteryx Service. To avoid any issues, you can package the workflow, then schedule as follows:
    1. Package the workflow by going to Options > Export Workflow, making sure you check the box to include the .indbc file
    2. Go to Options > View Schedules
    3. On the Workflows tab, click the + icon
    4. add workflow to schedule.png
    5. Navigate to the .yxzp file you created above and set the schedule frequency

 

 

Additional Resources

 

Comments
5 - Atom

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?

5 - Atom

Use "Hide" instead of "Encrypt for user" for Password Encryption and the issue has been solved.

6 - Meteoroid

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