Inconsistency between Alteryx Application on server vs Alteryx Application on designer

Hi,

I have ran into one problem in which we would like to resolve. The problem seems to only arise when using the Alteryx Application on the gallery. I am trying to have the Interface tools pick up its “NAME” AND “VALUE” from a External Source. This external source is a database connection we have set up on the gallery. This data in the database will change over time and I want the Alteryx application on the galley to pick up these changes. If I run the application locally I get what I expect. However, when I upload this to the gallery and run it, the interface tools do not populate and they are blank.

I have also tried Fields from a connected tool. Where I utilize a Input tool which connects to the database. However this still does not update dynamically on the gallery when the source data in the database is changed. So this workaround does not work either.

Regards,

Oisin

Bug

Apps

Accepted answers

All comments

JoeS

Hi @OisinMC

What user do you have set up as the Run As on the Server System Settings?

My first check would be to see that user and double check that it has access to the data source

OisinMC

Hi @JoeS,

Thanks for your reply.

As I am saving my workflow to the gallery, I set my workflow credentials to use a service account we have set up which has access to this Database. The workflow would not run without this svc account having access (which it does when interface tools use a static table).

Regards,

Oisin

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167