topic Re: Gallery search doesn't work in Alteryx Server Discussions

Gallery search doesn't work

FreeRangeDingo — Mon, 22 Jul 2019 15:50:07 GMT

Is there a trick to getting the Gallery search function to work properly? I have a workflow entitled "Completions Output Workflow 04-17 BULK". Searching "Completions" doesn't find it. Neither does searching "bulk" or "BULK". Searching "output" does find it? Can someone explain this? Thanks!

Re: Gallery search doesn't work

jamielaird — Tue, 23 Jul 2019 07:16:16 GMT

Just to add that this is something I frequently encounter as well - the search function is definitely in need of some work.

Re: Gallery search doesn't work

Treyson — Tue, 23 Jul 2019 22:29:38 GMT

@danielbrun2 I mentioned this problem at Inspire and you had mentioned that it might be a problem with Mongo? Are you familiar with anyone else having this issue?

Just to note, I am also having this problem @FreeRangeDingo

Re: Gallery search doesn't work

FreeRangeDingo — Tue, 23 Jul 2019 22:31:02 GMT

We aren't using Mongo at all in our environment, so I don't think it's related.

Re: Gallery search doesn't work

danielbrun2 — Wed, 24 Jul 2019 12:29:08 GMT

Hi,

This is usually due to broken indexes on the Alteryx Gallery. I would recommend contacting support in order to have the proper instructions. Btw. Alteryx Server is using mongoDB, so you have at least one in your environment.

However if you feel confident you can do the following:

Backup mongoDB (just to be on the safe side) - https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Alteryx-Server-Backup-amp-Recovery-Part-2-Procedures/ta-p/22642
Check the following table: commandQueueItems in mongoDB - it should be empty. I normally use Robomongo to connect. See how to connect here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/What-databases-are-available-in-MongoDB-of-the-Alteryx-Server/td-p/117819
Repair indexes with the attached flow - you need to input you controller token

Hope this solves your issue.

Best regards,

Daniel

Re: Gallery search doesn't work

FreeRangeDingo — Wed, 24 Jul 2019 15:41:15 GMT

Thanks for that info. Our admin just left the company. As soon as we get a new one, we'll try to implement this solution. Much appreciated.

Re: Gallery search doesn't work

danielbrun2 — Thu, 25 Jul 2019 08:15:04 GMT

You are welcome - let me know if you need additional help with server or in general.

Best regards,

Daniel

Re: Gallery search doesn't work

Newstart2020 — Thu, 23 Jan 2020 01:35:40 GMT

Hi @danielbrun

I am quite new to the Alteryx Gallery.

Can you let me know how the app helps to recreate the indexes??

Is it just the controller token we need to input??

Also do we run this workflow as an app with the option Rebuid??

Whats is check locks and Free locks?

Would be very helpful if there is a documentation to describe what the workflow does..

Thanks again

Re: Gallery search doesn't work

SophiaF — Thu, 23 Jan 2020 14:04:10 GMT

@Newstart2020 as this requires direct changes to the backend database of your server, we suggest that you work with one of the Support Engineers to confirm this is the cause of your issue and provide steps to resolve. You can contact support here.

Re: Gallery search doesn't work

danielbrun2 — Wed, 29 Jan 2020 19:34:12 GMT

Hi,

There can be many reasons why the indexes are not working and as Sophia suggest I would consider working with someone to resolve the issue. Did you get the issue resolved? If not I would be happy to jump on a call and have a look.

Locks - there are 2 tables in the MongoDB that can cause locks. Theses can be cleaned out (Again I would suggest having someone experienced on your side while doing it)

No official documentation on the issue, unfortunately - fortunately, AYX Support are really good at helping out.

Re: Gallery search doesn't work

raychase — Fri, 31 Jan 2020 00:37:25 GMT

When I've encountered search issues, I noticed a lock file had been generated within the AlteryxGallery_Lucene database. After removing that, cleaning up the commandQueueItems collection, and running the Lucene Database Reindexer, the search functionality was back to normal. Support should be able to walk you through it, as it's a very simple process.

Re: Gallery search doesn't work

Newstart2020 — Tue, 04 Feb 2020 22:54:08 GMT

Thanks @sofia @Daniel @Asteroid.

I have raised a support job with alteryx and waiting for their response so that i can work along with our server admin here

Thank You

Re: Gallery search doesn't work

CharlesW — Thu, 25 Jan 2024 16:25:21 GMT

2024 this is still an issue.

I don't understand after 6 years of working in the gallery this is still an issue.

We're not all server admins with access directly to the Mongo DB. No software should ever need direct access to the DB to clean, unlock, re-index anything.

This seems like a early software issue that should have been resolved a long time ago.

So why hasn't the software been updated to either not cause the issue at all or at least if you can't fix it, auto re-index the mongo db nightly by now?

Why is manually re-indexing the mongo DB the solution still in 2024?