tMongoDBInput doesn't read DocumentDB collection

fcolagiacomo — Thu, 07 Nov 2024 18:52:56 GMT

My job uses MongoDB components to connect and read DocumentDB connection but when I run the job I receive an error from DocumentDB about noCursorTimeout feature not available. DocumentDB installed with MongoDB compatibility.

Re: tMongoDBInput doesn't read DocumentDB collection

fcolagiacomo — Thu, 07 Nov 2024 19:02:44 GMT

I found the solution!

Whether you receive this kind of error you have to check item file of the job. You should to find this elementParameter "QUERYOPTION_NOTIMEOUT" set "true", this setting cause into the Java code the statement <mongodb_client>.find(...).noCursorTimeout(true).... (the feature is not supported by Amazon DocumentDB).

So you can change the value of "QUERYOPTION_NOTIMEOUT" to "false" and your job will work like a charm.

N.B.: you have to set the tMongoDBConnection component by connection string and you have to add the parameter "retryWrites=false", in example:

mongodb://<DocumentDB_ARN>:27017/?replicaSet=rs0&readPreference=secondaryPreferred&retryWrites=false

topic tMongoDBInput doesn't read DocumentDB collection in Talend Studio

tMongoDBInput doesn't read DocumentDB collection

Re: tMongoDBInput doesn't read DocumentDB collection