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
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.
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