Hi All,

I have a extraction that have a transformation : to get data from mongoDB,format it properly and write to mysql database.

The transaformation while executing on the biserver starts throwing following error

Please have a look on the below issue ..

"ERROR [org.pentaho.di] MongoDB Input - com.mongodb.MongoException$CursorNotFound: cursor not found on server

at com.mongodb.DBApiLayer$Result.init(DBApiLayer.java:371)

at com.mongodb.DBApiLayer$Result._advance(DBApiLayer.java:418)

at com.mongodb.DBApiLayer$Result.hasNext(DBApiLayer.java:400)

at com.mongodb.DBCursor._hasNext(DBCursor.java:489)

at com.mongodb.DBCursor.hasNext(DBCursor.java:509)

at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:61)

at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)

at java.lang.Thread.run(Thread.java:636)"

I am getting this error when ever I am trying to fetch data from mongoDB by running the transformation from an extraction. Please suggest what might have gone wrong. It works fine for upto 12000 to 14000 records then abruptly completes ( with successful message)

I need to fetch data from MongoDB and put it into mysql database.

Our mongo database have a total of 2000000 records and it hardly works for 1% of the records.

Any help will be highly appreciated.