Is anyone facing this Issue?

Matillion ETL
1

Hi,

Today We updated our Matillion ETL version to Version: 1.77.4 (build b31c472-11095) AMI Version: 1.77.4 in that we are facing this error in mongo component,

*Error code: [16,410] - "FieldPath field names may not start with '$'. Consider using $getField or $setField."*

still yesterday this component ran fine. Is anyone facing this error can please take look on it

Screenshot 2025-02-05 151701
Screenshot 2025-02-05 151701997Ă—355 28.4 KB

1 Like
2

Hi @HariRamK, are you still getting this error? I’ve had a check in with the team and they’ve suggested the error is reflected from mongo db itself, so it’s possibly a syntax error in the query. If you’d like to share your SQL query we could take a look, if you’d like?

Many thanks,
Claire

3

Hi @ClaireSeniorCommunityManager thanks for taking a look, we have fixed with the issue Its not syntax issue its driver issue from mongodb side,So we changed some syntax in our api script ,it got fixed, and also from matillion upgrade also leads to fix for this issue.

2 Likes
4

Hi @HariRamK, thanks so much for coming back and letting us know how you fixed it!

thanks again,
Claire

5

We not faced this issue in all mongo components we faced few mongos. So only in that issue mongos we changed api scripts
For example
before change:<attr name=“UpdatedOn” xs:type=“string” columnsize = “2000” readonly = “false” isNullable = “true” other:datasourcedatatype = “bson:Document” other:bsonpath = “$.UpdatedOn”/>
after change:<attr name=“UpdatedOn” xs:type=“string” columnsize = “2000” readonly = “false” isNullable = “true” other:datasourcedatatype = “bson:Document” other:bsonpath = “UpdatedOn”/>
just removed the **$.**UpdatedOn to UpdatedOn just removed the $ symbol I don’t its a permanent fix or not, if you anything about you can correct me.

2 Likes
6

Hi @HariRamK, thanks so much for coming back and sharing that with us! We’ll mark this as a solution so that others can see what you did, expect to see a new Solved badge in your profile shortly.

Thanks again!
Claire

7

Hi @ClaireSeniorCommunityManager

You’re very welcome! I’m glad I could help. Thanks for marking it as a solution—I’m happy to contribute. Looking forward to the new badge!

Best,
Hari

1 Like