:wave: Hello, team!
I tried to create a connectio...
# ask-community-for-troubleshootingo
Opeyemi Daniel
09/15/2022, 3:18 PM👋 Hello, team!
I tried to create a connection between mongodb and postgres database and I got this error
2022-09-15 112814 INFO i.a.w.i.DefaultAirbyteStreamFactory(lambda$create$0):61 - com.mongodb.MongoCommandException: Command failed with error 40353 (Location40353): 'Invalid $project :: caused by :: FieldPath must not end with a '.'.' on server. The full response is {"ok": 0.0, "errmsg": "Invalid $project :: caused by :: FieldPath must not end with a '.'.", "code": 40353, "codeName": "Location40353"}
what could be the issue here
✍️ 1
s
Sunny Hashmi (Airbyte)
09/15/2022, 4:42 PMIt looks like a field specified in your mongo query ends with a
.Sunny Hashmi (Airbyte)
09/15/2022, 4:46 PMI don't have a ton of experience with building mongo pipelines but maybe there is a clever way to work around this? some answers in this thread on a similar issue, not sure if it will work for your query https://stackoverflow.com/a/42433950
o
Opeyemi Daniel
09/15/2022, 5:08 PMThanks @Sunny Hashmi (Airbyte)
I am not writing a query, just trying to replicate data from mongodb to postgres
s
Sunny Hashmi (Airbyte)
09/15/2022, 5:17 PM@Opeyemi Daniel I found a similar issue in our community forum if this helps: https://discuss.airbyte.io/t/source-mongodb-failed-to-fetch-mongodb-of-digitalocean-managed-db-schema/1931/6?u=sh4sh
I'm not sure if the workaround will help in this case as it's a slightly different error, but there are troubleshooting steps at the bottom of the page that may give us more information to look into
z
Zendesk
09/15/2022, 5:43 PMA ticket has been created by Marcos Marx
o
Octavia Squidington III
09/16/2022, 1:23 PM@Marcos Marx (Airbyte) turned this thread into a ticket to ensure timely resolution!
o
Opeyemi Daniel
09/20/2022, 5:51 PMimage.png
Opeyemi Daniel
09/20/2022, 5:52 PMThe issue is a case of an object having sub-objects. Airbyte is not handling this well
s
Sunny Hashmi (Airbyte)
10/19/2022, 1:20 AMHey @Opeyemi Daniel sorry for the delay in response, if this is still happening could you please create a bug report in github?
3 Views