Alteryx Server

Find answers, ask questions, and share expertise about Alteryx Server.

Gallery search doesn't work

Highlighted
8 - Asteroid

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!

Highlighted
Alteryx Certified Partner

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

Highlighted
12 - Quasar
12 - Quasar

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

Highlighted
8 - Asteroid

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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:

 

  1. Backup mongoDB (just to be on the safe side) - https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Alteryx-Server-Backup-amp-Recovery-Pa...
  2. 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-MongoD...
  3. Repair indexes with the attached flow - you need to input you controller token

Hope this solves your issue.

 

Best regards,

Daniel

Highlighted
8 - Asteroid

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.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

 

Best regards,

Daniel

Highlighted
5 - Atom

Hi @

 

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

 

Highlighted
Alteryx
Alteryx

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

Sophia Fraticelli
Premium Support Advisor
Alteryx, Inc.
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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.