Gallery down for everyone or just us?

Gina2021

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

Gallery

Server

Accepted answers

All comments

No-Sass

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.

Gina2021

@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!

Chandler_Bing

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

Gina2021

@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.

jrgo

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.

Gina2021

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.

jrgo

@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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703