Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

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

Alteryx Server Usage Report - Cant identify host or db credentials

mkav9893
8 - Asteroid

HI All,

 

We are attempting to monitor our alteryx server usage to have better tracking. However, when we are attempting to enter in the database host, the instructions tell us to navigate to systems settings > controller > persistence page to find the credentials. We dont have the system settings drop down available to us (we are running server 2018.4 and have the admin version (we are using the gallery to schedule workflows)).

 

This is the error that we are getting when we use the default host (localhost:27018), plus the admin username and password

 

Error: Alteryx Server Usage Report (8): Tool #569: Mongo Error (getCollectionNames) : { msg:"No suitable servers found (serverSelectionTryOnce set): [connection refused calling ismaster on 'localhost:27018']: generic server error" code: No suitable servers found (serverSelectionTryOnce set): [connection refused calling ismaster on 'localhost:27018']: generic server error }

 

 

https://help.alteryx.com/server/current/admin/ServerUsageReport.htm

4 REPLIES 4
DanM
Alteryx Community Team
Alteryx Community Team

@mkav9893 

 

You have two ways to get to the system settings.

 

1. In the Options menu under Advanced Options

2. Through the desktop icon for system settings.

 

If you do not have either of these, you either do not have the Alteryx Server version installed or you are not looking on the Server machine that has the Server version installed.

 

Screenshot 2019-09-19 09.06.17.png

 

 

dhanjitgiri
5 - Atom

I am having hard time , running the workflow, getting error
Alteryx Server Usage Report (8): Tool #534: Record #1: Tool #11: Mongo Error (getCollectionNames) : { msg:"No suitable servers found (`serverSelectionTryOnce` set): [connection refused calling ismaster on 'localhost:27017']: generic server error" code: No suitable servers found (`serverSelectionTryOnce` set): [connection refused calling ismaster on 'localhost:27017']: generic server error }

smysnbrg
8 - Asteroid

I've got the settings placed in my MongoDB input tool and still receive the error mentioned by the OP.  Any ideas?

Manojyellinte
5 - Atom

What if we are using User managed mongo DB and whats the host name we need to give?