Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

MongoDB Input : cursor id xxxxxxx not found: generic server error when reading a larger mongoDB collection using mongo Input tool

gouthamiunnava
Alteryx Alumni (Retired)
Created

Issue


When  accessing the MongoDB that is backing the Alteryx server using the MongoDB Input tool reading in  AS_Schedules, AS_Queue, AS_Applications, AS_Results collections for analysis in a workflow, it throws the below error for larger collections

 
MongoDB Input: cursor id not found: generic server error
image.png
 

Environment Details

 
  • Alteryx Designer, Server 
    • Version 2020.4 +
  • Additional Tools 
    • MongoDB input tool


Cause

 

The cursor error that was returned is coming from MongoDB. When the result set that is being read is quite large and the cursor could possibly be timing out before reading. 
When having tested limiting the record size while reading a MongoDB collection and below are the results:
  • 1000 Records - 10:14 minutes - Success
  • 2000 Records - 19:32 minutes - Success
  • 3000 Records - Error - Error: MongoDB Input (28):Cursor id 400581627165 not found: Generic server error


Resolution


To remove the timeout, the below code line needs to be configured in the mongo DB input tool as shown in the below screenshot:
{},no_cursor_timeout=true

image.png

 

Additional Resources

 
No ratings