Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tMongoDB in UPSERT mode.. how to do ?

I'm trying to use the tMongoDBoutput for a Json file injection.
This is my schema

In the INSERT mode, there is no problem : i found all my data with the
> db.myCollection.find()
In the UPSERT mode, the component doesn't send me any error but nothing is inserted in the collection... what was wrong ?
Any idea ?
0683p000009MEf4.jpg
0683p000009MEf9.jpg

0683p000009MEVt.jpg
Labels (3)
2 Replies
Anonymous
Not applicable
Author

Hi,
Have you checked out " Die on error" option to see if there is any error printed on console?
Best regards
Sabrina
Anonymous
Not applicable
Author

hi (sorry for this late answer due to vacation).
Effectively, i see this error
Exception in component tMongoDBOutput_1
java.lang.Exception: Must have at least one key in schema
    at etl_cres.jsonloader_0_1.jsonLoader.tFileList_1Process(jsonLoader.java:2324)
    at etl_cres.jsonloader_0_1.jsonLoader.tMongoDBConnection_1Process(jsonLoader.java:1848)
    at etl_cres.jsonloader_0_1.jsonLoader.runJobInTOS(jsonLoader.java:3782)
    at etl_cres.jsonloader_0_1.jsonLoader.main(jsonLoader.java:3618)

How can i introduce a key in schema as i load files and the only field i have is a single field named "content" for Talend ?
0683p000009MENp.jpg