topic Re: Refresh yxdb on Alteryx Server in Alteryx Server Discussions

Refresh yxdb on Alteryx Server

LeonLu — Wed, 26 Sep 2018 19:44:15 GMT

Hi there,

Question: I have an Alteryx App that's saved to the server. There are a couple of inputs that are .yxdb files (to increase app performance).

How do I setup a schedule to refresh those input yxdb files? Does putting them into a shared drive work?

Thanks!

Leon

Re: Refresh yxdb on Alteryx Server

AmeliaG — Wed, 26 Sep 2018 20:34:43 GMT

Hi @LeonLu,

Thanks for your question! In order to get the most up-to-date file:

1. Put the file on a net work drive

2. Change the file path to UNC (Options > Advanced Options > Workflow Dependencies). Push the "All UNC" button

3. Save the workflow to the server. When saving, make sure the files are NOT checked under 'Workflow Assets'

Let me know if you have any additional questions!

Amelia

Re: Refresh yxdb on Alteryx Server

LeonLu — Thu, 27 Sep 2018 15:40:51 GMT

Thank you Amelia! This works!

Re: Refresh yxdb on Alteryx Server

MichaelPilz — Wed, 19 Dec 2018 02:18:01 GMT

Hi @AmeliaG

I'm not entirely sure I'm in the right place to ask this question. I thought this might be the solution to my issue but it doesn't appear to be.

My problem is. I have two apps that are saved to the server. The output of App #1 is the “####.yxdb” file that is the input in App #2…(pictured). “####.yxdb” is saved on my company network drive. For both apps, I have set all the dependencies as UNC.

In App #2, the user selects from a list of file options (‘User Selection from Columns’) that is then used to create a raft of reports. My problem is that the “####.yxdb” input file does not refresh when App #1 is completed. Therefore the list of file options is not complete.

I have tried to research everything I can think of, and can’t seem to find a solution. I thought the UNC setting would fix it but it doesn’t. Any suggestions would be gladly welcomed.

Michael

Re: Refresh yxdb on Alteryx Server

mbarone — Wed, 19 Dec 2018 17:05:16 GMT

Hi Michael,

If I'm understanding you correctly, you have a chained app - App1 then App2. When app 1 completes, it results in a YXDB, and you want that exact YXDB that was just created to be used as an input for App2. Is that correct?

If so, the trick is that when you send App1 to the Gallery, include the YXDB1 as an asset. When App1 is run in the gallery, it will create YXDB1 in temp space created just for that user, just for that run. App2, which is chained, will pick up that temp YXDB as it's input.

Re: Refresh yxdb on Alteryx Server

MichaelPilz — Thu, 20 Dec 2018 01:10:49 GMT

Hi mbarone

Thank you very much for your response.

I might not have explained myself properly. App 1 and App 2 are not chained as such. App 1 is used by multiple users to append updated data to the final outcome, which is the "####.yxdb" file. Then the user of App 2, typically not the same as an App 1 user, takes this YXDB file to create a variety of reports.

App 1 may be run multiple times throughout a month, and then App 2 is typically run once a month at month end.

Hopefully, I am being a bit clearer now.

Michael

Re: Refresh yxdb on Alteryx Server

mbarone — Thu, 20 Dec 2018 12:42:53 GMT

Do you have it "unchecked" as an asset when you send up the apps? Meaning when you send up App1 and App2 to the Gallery, make sure the YXDB in question is not sent up with it. That will allow the apps to reach back down to the file on the network drive.

Re: Refresh yxdb on Alteryx Server

MichaelPilz — Thu, 20 Dec 2018 22:30:54 GMT

Hello,

Thank you again for helping here.

Yes, all assets are unchecked. See attached screenshots.

In the App 1 shot, the bottom file is the output "####.yxdb" file.

In the App 2 shot, the bottom file is the input "####.yxdb" file.

Michael

Re: Refresh yxdb on Alteryx Server

mbarone — Fri, 21 Dec 2018 12:21:36 GMT

That looks right to me. I have no explanation. From what you describe, it should be working.

When App1 completes, is it updating the output correctly? And then App2 just doesn't seem to be reading in the updated YXDB?

Re: Refresh yxdb on Alteryx Server

MichaelPilz — Mon, 07 Jan 2019 00:08:38 GMT

Hi @mbarone,

Happy New Year. Sorry for my late reply, I have been on leave.

Yes, when App 1 completes, it is updating correctly. Its almost like I need to create an in-between App that refreshes the data fro App 2. I'll look into whether it is possible.

Thank you for your assistance.

Re: Refresh yxdb on Alteryx Server

Jithendra — Wed, 06 May 2020 20:25:45 GMT

Hi,

Are you able to resolve this issue?

Re: Refresh yxdb on Alteryx Server

MichaelPilz — Mon, 18 May 2020 04:38:23 GMT

Hi,

Sorry for the slow reply. No, unfortunately. I was never able to resolve this. My work around solution is that I have to manually run the update everytime. Luckly for me, it is a process that only happens quarterly

Re: Refresh yxdb on Alteryx Server

Jithendra — Mon, 18 May 2020 04:52:46 GMT

Ok. Thank you for the update.