Migrating Data from Dynamics environment using Using Azure Data Factory

Question

I am trying to copy data from dynamics environment to another dynamics environment; we have a SQL DB for the source dynamics environment. I have connected to that DB via SSMS, and I am doing all the transformations and created views in SSMS, after that I am linking them to the pipeline and pushing data to the destination environment, and i have put incremental refresh on those pipelines. Pipelines were working fine till 23 May 2022, and suddenly, I was getting this error in one of my pipelines.

ErrorCode=DynamicsOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Dynamics operation failed with error code: -2147220956, error message: Sequence contains no elements.,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,''Type=System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]],Message=The creator of this fault did not specify a Reason.,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,'

Not sure what I am missing. I thought that while importing data, some columns have null values that why this issue is coming, but I had some null values before, and it was working fine. Any thoughts on how to resolve this issue will be great. This is the SQL statement for creating a view

Answer 1

Hi @Nithin Reddy ,

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

This kind of error will come when we try to read or fetch something which not exists or something empty.

I could suggest to have below checks and see if that helps.

• is dbo.d365_contact is exists to alter in db? Kindly check and make sure.
• In your case statement I don't see ELSE block to take some default or dummy value when no case matches. Could you please try to have it and see?

Please let us know how it goes. Thank you.

-----------

If this helps, please consider hitting Accept Answer. Accepted answers help community as well.