Error when saving workflow with Dynamic Input tool to Alteryx Server

brucks

I have created an Alteryx workflow that uses the Dynamic Input tool to modify parameters from a SQL Server Stored Procedure (basically allows me to update date parameters every time the workflow is run so that the date passed to the stored proc to tomorrow and two days from tomorrow).  Works fine when I run the workflow in Designer, but when I go to save it to our Gallery I get the attached error message.  I am calling three different stored procs in my workflow and I get an error message for all three of the Dynamic Input tools that I am calling the stored procs from.  I do have both standard connections as well as In-DB settings configured on my local machine as well as on Alteryx Server.  Any ideas that I should try?  Thanks in advance.

BenMoss

Irrespective of the error have you tried actually running the workflow from the server? I know in theory it should retrieve the same error but that doesn't always translate to practice. 

This would be the first thing I would check.

Presuming you still get the error I would be checking the connection names to ensure the server machine can make the connection to the DB; but you've mentioned this shouldn't be an issue, I would always double check.

After that, not too sure where to point you!

Ben