topic Re: Gallery down for everyone or just us? in Alteryx Server Discussions

Gallery down for everyone or just us?

Gina2021 — Tue, 05 Oct 2021 16:09:01 GMT

Hi Community!

My company has had issues with gallery going down daily for the past two weeks.

Sometimes it will look like it's working, but when I click on collections (we have many), it just spins.

IT dispelled the only two fixes I've found on the community....

1. Has a network scanner software been installed on the Alteryx server in the last two weeks?

2. Do we have enough hard drive space? How often are temp folders deleted?

"Network scanner is not installed back on the server. There is ample space available in the drive and Temp folder is also 128MB free. The issue RCA (root cause analysis) is still unknown."

We use SQLite.

Is this happening for all companies?

Does anyone have any fix brainstorms?

Thanks so much!

Gina

Re: Gallery down for everyone or just us?

No-Sass — Wed, 06 Oct 2021 06:03:05 GMT

If you are utilizing the Gallery, you really want to be using MongoDB as your Persistence layer. SQLite is suited for a designer only or a server instance where only the scheduler is being used. Not sure how long you have had your server deployed, but you are going to need to change to MongoDB if you want to continue to use the Gallery. Worst case you download all your workflows that are on the gallery now, then reconfigure to MongoDB and reload the workflows again.

Re: Gallery down for everyone or just us?

Gina2021 — Wed, 06 Oct 2021 14:26:30 GMT

@No-Sass Thank you so much for this response!!! We have at least a hundred workflows on gallery, some scheduled and some adhoc. Do you think this setting is enough to cause the server go down?

@MarqueeCrew have you seen anything like this happen? Thank you!

Re: Gallery down for everyone or just us?

Chandler_Bing — Wed, 06 Oct 2021 19:55:21 GMT

Hi @Gina2021

Did you upgrade ur server recently?

Can you see the error in the gallery logs? Next time when it goes down or collections don't work as u mentioned check the latest log file

The location of the logs is usually at : \ProgramData\Alteryx\Gallery\Logs\

This log file might tell you what is causing the error, if you can post that error here you might get more help to resolve the issue

Thanks

Re: Gallery down for everyone or just us?

No-Sass — Wed, 06 Oct 2021 20:49:31 GMT

I'm not aware of the ramifications of using a SQLite database instead of MongoDB in the way that you are using it. I just know that it's recommended to not use it if you are using the Gallery and/or getting significant use from your server.

(There's many different resources that speak to this, here is one. About halfway down the page...)

Database Type

The controller maintains data in either SQLite or MongoDB databases. Server offers embedded SQLite or MongoDB options, as well as a User-Managed MongoDB option. If you are configuring the machine for a gallery, you must use MongoDB or User-Managed Mongo DB.

SQLite: Creates an instance of the SQLite database. Recommended for lightweight and local deployments that use the scheduler.
MongoDB: Creates an instance of the MongoDB database. Recommended for heavier usage.
User-Managed MongoDB: Allows you to connect to your implementation of MongoDB.

You can also try cleaning/limiting your Persistence data? Set it 30 days? Less?

The logs will have some details to what may have caused this for you or at least steer you in a direction if this continues.

Re: Gallery down for everyone or just us?

Gina2021 — Wed, 06 Oct 2021 21:23:47 GMT

@Chandler_Bing hahaha, love your handle.

Thanks much for the hints! Looks like I don't have permissions for those folders. I'll have to hand this back to IT.

Re: Gallery down for everyone or just us?

Gina2021 — Wed, 06 Oct 2021 21:25:11 GMT

Thanks so much @No-Sass for the extra details! I don't have permissions to see the logs. IT created a support case with Alteryx today to find the root cause. I'll post that back here when we find out. Thanks again!

Re: Gallery down for everyone or just us?

jrgo — Thu, 07 Oct 2021 14:10:52 GMT

To expand on @No-Sass comment, using SQLite is not compatible if Gallery is enabled.

It's an option that actually greyed out if the "Setup Type" include Gallery. And looking at the screenshot you shared, the Gallery section looks like there's no options to configure,

It would show the below if Gallery was enabled.

To me, it seems as if someone started tinkering with the Alteryx System Settings making changes that they shouldn't have.

Re: Gallery down for everyone or just us?

Gina2021 — Fri, 08 Oct 2021 20:32:05 GMT

Thanks much for your two-cents @jrgo ! I think you're right. My co-worker's is set up like mine as well, but IT insisted we were on Mongo. I think I have some conversions in my future. However, the issue isn't user specific.

It really seems like a web-based issue. IT keeps having to 'recycle' something every 5 min some days to get us out of an http 404 not found state. Other times, we can see gallery, but when we click on collections, it will just spin and spin.

IT still hasn't gotten a resolution from the ticket they opened with Alteryx.

Re: Gallery down for everyone or just us?

jrgo — Fri, 08 Oct 2021 21:59:03 GMT

@Gina2021 I have experienced in the past where certain Gallery pages fail to load or load incorrectly and its usually after Alteryx Server has been upgraded to a new version.

Problem is when the upgrade resulted in code changes to a specific page in Gallery and your browser tries to load a cache that is no longer compatible.

Clearing your browsers cache usually fixes the issue.

Worse case... contact support!

Best of luck!!

Jimmy