cancel
Showing results for 
Search instead for 
Did you mean: 

Can't connect to MongoDB error - Alteryx Server - service won't start

SOLVED
Highlighted
Claje
Bolide

Hi,

I'm having a rather critical issue currently.  Our AlteryxService is stopped and i'm attempting to restart it, but am receiving the following error:

 

Alteryx Service <Mongo connection failed, please ensure server address and credentials are correct.

 

I looked in the path specified in the configuration and it looks like the files are there, so i'm not entirely sure what is going wrong.  Any help would be fantastic.

Claje
Bolide

This is resolved - thank you very much Alteryx!

BGoode
Atom

I cannot see the solution and am having the same problem.  Someone please post the solution. 

I have the same issue, how can I resolve? MongoPool.cpp: 159. couldn't connect to server localhost:27018

sagar_agarwal
Asteroid

You can try out the steps here in order to troubleshoot the problem. These steps worked for me too:

 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/ERROR-Mongo-Connection-failed-please-ensure-...

cgusa
Atom

I have tried that, it solves the issue temporarily, after a couple of days the error is back

aMac
Asteroid

Hi @Claje would you share the solution you and Alteryx used to resolve?  Noticing similar issues on our end.

Claje
Bolide

Hi,

 

I want to start by saying that you should follow all of the steps listed In Andrew Lloyd's post (https://community.alteryx.com/t5/Alteryx-Knowledge-Base/ERROR-Mongo-Connection-failed-please-ensure-...) Before attempting anything else, and also that working with Alteryx Support will be a better bet if you can do so.


Below is the information that I have available from the issue we encountered back in March.  If you have further questions I will do my best to answer them.

 

Our issue was related to mongoDB Journal files, in particular, a locking issue on a journal file.  documentation discussing this feature of mogoDB is available here: https://docs.mongodb.com/v3.0/core/journaling/

 

We resolved this issue with the following command:

mongod.exe --dbpath "D:\Alteryx\Service\Persistence\MongoDB" --auth --port 27018 --repair --repairpath D:\MongoBackup

 

Hope this helps!

aMac
Asteroid

Got it, thanks for the quick and thorough response @Claje! Would give more stars if I could :-)