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

[gouthamiunnava]

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

 

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



 

Additional Resources

 

• Example Alteryx Designer Help
• Designer - MongoDB tools
• Mongo Docs ​ - Iterate a Cursor