copy data from MongoDB to blob (json file)

Reut Cohen 6 Reputation points
2023-03-14T16:53:45.51+00:00

Hi,

I'm trying to copy data from MongoDB to Azure blob

the process failed and I'm getting this error:

The failure happened on the 'Source' side. ErrorCode=MongoDbOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=>Failed to operate data via MongoDB client.,Source=Microsoft.DataTransfer.Runtime.MongoDbAtlasConnector,''Type=System.InvalidOperationException,Message=Duplicate element name 'score'.,Source=MongoDB.Bson,'

can it be resolved on the Azure side?

I don't see any Duplicate elements on the MongoDB collection

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
    2023-03-20T09:52:54.2366667+00:00

    Hi Reut Cohen,

    Thank you for posting query in Microsoft Q&A Platform.

    From the error message it seems problem is in source only. Kindly recheck if any duplicate element name called score in your mangoDb database.

    However, in copy activity, under mappings tab see if any duplicate mapping happened and if yes, clear it and see if that helps.

    Please let me know how it goes. Thank you.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.