Talend job - Issue in tMongoDBInput

Hi All,
I've created a flow to read from mongoDB to load into Mysql. Attached is my mongoDB input configuration,
Job is running fine and data is loaded into Mysql. But the below error message is generated eventhough the job completes successfully.
"tMongoDBInput_1 - The query does not contain any reference an index.  "
Please advice why this error message is generated.
Is this because the Query field in Mongodbinput in empty? If so, what I've to specify to select all records from mongoDB.
Thanks,
Satheesh
4 REPLIES
Moderator

Re: Talend job - Issue in tMongoDBInput

Hi,
This situation is normal. If the query that contains reference an index, will be faster.
The error message indicates that an index should be set. Please try this query:db.collection_name.find();
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Re: Talend job - Issue in tMongoDBInput

Thanks Xdshi!
But when i use this query, talend mapping throws parse error. So i left the mapping with initial status, as it is not harming as process.
Thanks and Regards,
Satheesh B
One Star

Re: Talend job - Issue in tMongoDBInput

Hi,
I have exactly the same problem.
I just want to select all records from my collection in a tMongoDbInput.
But I have the error : "tMongoDBInput_1 - The query does not contain any reference an index.  "
I also have an error with : db.collection_name.find(); in the query
Four Stars

Re: Talend job - Issue in tMongoDBInput

Hello 
has there been any additional findings on this issue?