community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx server Knowledge Base

Definitive answers from Server experts.

Alteryx Service will not Start: No suitable servers Error found in LastStartUpError.txt

Moderator
Moderator
Created on

Issue:  Alteryx Service will not Start and LastStartUpError.txt contains "No suitable servers found: `serverSelectionTimeoutMS` expired: [connection refused calling ismaster on 'localhost:27018']: generic server error" code: <mongodb:13053>

 

By Default, the LastStartUpError text file can be found at C:\ProgramData\Alteryx\Service

 

 

Error Code: No suitable servers found: `serverSelectionTimeoutMS` expired: [connection refused calling ismaster on 'localhost:27018']: generic server error" code: <mongodb:13053>

 2018-12-18_13-06-43.png

Environment

 

  • Product - Alteryx Server
    • Version(s) 11.8+

Diagnosis

 

Check Last StartupError.txt for above error 

 

  1. Identify where the MongoDB is installed from the System Settings->Controller->Persistence
  2. Open a Windows Folder Browse and navigate to that folder
  3. Check to see if the mongod.lock file is anything but 0k in size

Cause

 

Alteryx Server had an unclean shutdown.

 

Solution

 

If the mongod.lock file does have data inside (1k usually), we recommend to first  backup your persistence database (in case of corruption) before proceeding to the steps below

  1. Delete or rename the mongod.lock file
  2. Right-click in the window and select New->Text Document
  3. Rename the document mongod.lock (make sure show extensions is on for the folder, otherwise this file will actually be mongod.lock.txt)
  4. Open a Windows Command Prompt and navigate to the \Alteryx\bin directory (e.g. cd "\Program files\Alteryx\bin")
  5. Start up the MognoDB service just to make sure everything is clean:

 mongod --dbpath "folder path from system settings" --auth --port 27018

 

  1. With an unclean shutdown it may take a few minutes to reallocate the data.  Look for a line that says "Waiting for connections on port 27018"  When it appears hit Ctrl+c on your keyboard to shutdown the service
  2. Start up the AlteryxService.  You can do this in the Command Prompt with: sc start AlteryxService
  3. Check the Task Manager->Details (or Processes) to verify that the AlteryxService processes are staying up

 

Next Steps if the Mongod.Lock file was empty. 

  1. Open a Windows Command Prompt and navigate to the \Alteryx\bin directory (e.g. cd "\Program files\Alteryx\bin")
  2. Run the AlteryxService in test mode to identify the actual error: AlteryxService test
  3. If you are unable to easily identify what is causing the error, send us the service log files (path found in System Settings->Controller->General)