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

[RanjithMeda]

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

[Anonymous]

What's your talend studio version?

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

[RanjithMeda]

7.3.1

[Anonymous]

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