Questions Not Appearing in Alteryx Gallery

[Labhesh]

Hello Alteryx Community,

I have built a workflow using Interface Designer tools, and when I run it on my desktop, all the interface questions appear correctly in the interface view. However, after uploading the same workflow to Alteryx Gallery, the questions do not appear when running the workflow.

I have already enabled Workflow Management Assets, and all checkboxes under it are selected, but the issue persists.

Has anyone encountered this issue before, or does anyone have insights into what might be causing this? Any guidance would be greatly appreciated.

Additionally, I noticed that the YXDB file used to get the values for the list box was corrupted. After creating a new YXDB file, the issue was resolved. However, this corruption happens frequently. Does anyone have any ideas on how to prevent this from happening?

The file is saved as Analytic App (.yxwz) and not a macro. I created a new yxdb file and the issue got resolved. However, the yxdb files gets corrupted frequently. 

If I come back after few days and run the app that is present on gallery, the interface questions wont appear, if I re-create the yxdb data that is populating the values of the interface (Listbox) it will work. 

Thank you in advance for your help!

[OTrieger]

@Labhesh 

Maybe you should save the YXDB file in a different folder and not the Alteryx server. Does Alteryx have access to any of your Shared drives? Try to save the file there and set an Absolute dependency to it, as an absolute path.

[Labhesh]

@OTrieger 

Does Alteryx have access to any of your Shared drives?
Yes it has the access to shared drive. My all workflows has the same absoule path some are working totally fine no matter what how many time we refreshed the List box YXDB's..

Questions were appearing earlier as expected.
However, I have encountered this similar issue in some of my workflows where they tend to disappear.
This is a weird scenario and I don't see any specific pattern for RCA.

Please see the attached IMG..

[OTrieger]

You are saying that this similar solution is working well in other workflows. Therefore it means that something in this specific WF is causing it to get corrupted. 

How many times and when Alteryx writing to this XYDB file? As at these events the file will get corrupted. The file will not get corrupted from sitting on your server.

I would investigate in that direction, what is happening when the XYDB file is been updates or written to.

[Labhesh]

@OTrieger 

How many times and when Alteryx writing to this XYDB file? 

1 time everyday in morning thru schduled worflows...

If updating those YXDB will get crouppt then what is the use of using those in LIST Box my project requirement is this only, listing file will get update eveyday.. Is there any other possible way to do these thing