Talend job - Issue in tMongoDBInput

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
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
Five Stars

Re: Talend job - Issue in tMongoDBInput

Hello 
has there been any additional findings on this issue?

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download