We are in the final days to enter our Data and Analytics - "What's your why?" raffle with SparkED!

Reply with your "why" in text/video format to our forum post by January 28 to be entered! 

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Getting "Error finding connection" with (.indbc) file after publish to Server

PaulFields2
8 - Asteroid

Hi All,

 

WRT this other post, I've decided to go with In-DB connections using (.indbc) connections instead of standard Input and Output nodes (see first image). I'll go ahead and indicate this on that post and close it if I can.

 

What's happening now is that I'm getting an "Error finding connection" error (see second image below) after publishing this workflow to Server. I don't think it's an issue with the workflow finding the (.indbc) file, but don't understand enough about (.indbc) connections to confirm.

 

The dynamic replace of the initial DB connection setting is working fine, since the file noted in the error message (DEV_RULES.indbc) is the right one to use. I've also verified that this file is in the correct path on the server, and is the same as in my local environment, with the correct connection info.

 

Any assistance is greatly appreciated.

 

PaulFields2_0-1641923649446.png

 

PaulFields2_1-1641923750784.png

 

 

1 REPLY 1
PaulFields2
8 - Asteroid

Update - I created a very simple workflow (below) whereby the In-DB Connection node just reads from my DB using the configured (.indbc) file.  I published to Server and it worked just fine and output the records I was expecting to a (.xlsx) file, no problem.

 

So the ONLY difference between this and the workflow in my original post above is that I'm passing the reference to a different (.indbc) file through the Control Parameter and Action nodes when running on Server.  This seems to be what is precipitating the error.

 

Any ideas?

 

PaulFields2_0-1641929091156.png