Workflow Failing in Server After password reset in every Quarter

Question

The issue: We are  running ~20 workflows each day on Alteryx server. These workflows rely on a user’s .indbc file that sends login and password information (securely) to the server in order to run the workflows. Each quarter, it is required that users update their password and it is when their password updates that it causes these workflows to fail because the indbc file cannot be updated automatically without going in an adjusting each workflow independently.

Question: Do you have any thoughts on how we overcome this dilemma and avoid having to manually fix workflows every 3 months?

fmvizcaino · Answer

Hey @varun511 ,

The solution is similar to working with inputs from a shared folder in the gallery. You will still need to recreate the file every 3 months, but you will not need to update every workflow with the new connection file.

1. Use a shared folder that designer users and Alteryx server itself have access to

2. Configure your indb input tools to work with UNC path: https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Workflow-Dependencies/ta-p/49696

3. When publishing your workflow, uncheck the box so Alteryx will always read from the shared folder instead of packaging the indb file together.

4 Done!

Best,

Fernando Vizcaino