topic Re: Getting tMongoDBOutput_1_Out java.util.ArrayList cannot be cast to org.bson.Document error when trying to insert data into MongoDB in Talend Studio

Getting tMongoDBOutput_1_Out java.util.ArrayList cannot be cast to org.bson.Document error when trying to insert data into MongoDB

RanjithMeda — Fri, 15 Nov 2024 21:32:33 GMT

Hello,

I am trying to upsert data into MongoDB using tMongoDBOutput. Inserted JSON should look like this:

{

"_id": "PID:123:1234",

"type": "PID",

"lctNbr": 123,

"itmNbr": 1234,

"itemDetails": [

{

"vbu": "515",

"uId": "22622"

}

"lastUpdatedDate": "2020-10-31T16:24:18.466Z",

"locations": [

{

"lctSeqId": 1,

"lvlTxt": "7",

"prdLctTypCd": 1,

"AId": "3",

"BId": "11"

}

]

}

Below is how I configured JSON tree

Error I am getting : Getting tMongoDBOutput_1_Out java.util.ArrayList cannot be cast to org.bson.Document error when trying to insert data into MongoDB

Re: Getting tMongoDBOutput_1_Out java.util.ArrayList cannot be cast to org.bson.Document error when trying to insert data into MongoDB

Anonymous — Wed, 26 Jul 2023 02:27:39 GMT

What's your talend studio version?

I can't reproduce the issue by using 8.0.1 version of talend studio in my side.

Re: Getting tMongoDBOutput_1_Out java.util.ArrayList cannot be cast to org.bson.Document error when trying to insert data into MongoDB

RanjithMeda — Wed, 26 Jul 2023 02:50:38 GMT

7.3.1

Re: Getting tMongoDBOutput_1_Out java.util.ArrayList cannot be cast to org.bson.Document error when trying to insert data into MongoDB

Anonymous — Wed, 26 Jul 2023 03:40:16 GMT

It's recommended to upgrade to 8.0.1 version to fix the issue if you are using TOS edition. thanks