Dropdown-enabled Analytic App fails in Gallery

[BharathKumaran]

We are facing an issue when publishing an Analytic App with a dropdown interface tool to our Alteryx Gallery (Server version 2024.2).

Issue Summary:

- The analytic app runs successfully in Alteryx Designer.

- When the same app is published to Alteryx Gallery and executed from the browser, it fails immediately after selecting a value in the dropdown.

- If we remove the dropdown interface tool and publish the same workflow as an app, it runs successfully in Gallery.

Requesting to kindly help us identify the cause of this issue and resolve this error.

[abacon]

@BharathKumaran How is the dropdown configured? It is hard to say why this is failing without seeing the dropdown configurations.

Bacon

[BharathKumaran]

Thanks for the reply.

The dropdown is configured as an External Source with a file input (.yxdb).
The file contains two columns — NAME and VALUE. 
Also please find attached the analytic app.

[abacon]

@BharathKumaran I will take a look when I can but off the top of my head - does the server have access to the YXDB file used? I would look where the YXDB file is located - does the server machine have access to the file? If so, is the file path used the UNC path? Meaning the fully path, no mapped drives.

I will take a look though here soon and let you know if I have any other thoughts.

Bacon

[abacon]

@BharathKumaran Just looked, when you pushed up the workflow to the server, did you package the yxdb file with the workflow? If you save to the server and select manage workflow assets, you will see the options in the screenshot. Make sure the YXDB file is selected.

Bacon

[BharathKumaran]

Thanks for the support.

Yes, I have packaged the yxdb file with the workflow. This app runs perfectly in the gallery browser within the VM. But when I run this outside of the VM, it fails.

Also I'm attaching a simpler workflow where the dropdown is directly connected to a text input, but it still fails with the same error when processed outside of the VM.

[abacon]

@BharathKumaran What is the error you are getting? I don't see anything other than 'workflow has failed' in your original screenshot.

Bacon

[BharathKumaran]

this is the only error its showing, not able to see anything in the workflows results as well, its empty

[abacon]

@BharathKumaran There is no workflow result? If it failed there should be a log created with some form of error.

Bacon

[BharathKumaran]

yes, it fails and there are no entries in workflow results