Forum Discussion

vivien57's avatar
vivien57
Icon for Super User rankSuper User
1 year ago
Solved

Error Data Pipeline -> Dynamics Plugin with Dataverse connector

Hello Everyone,

I've had an error that I don't understand.

I have a "Copy Data" component that connects to a dataverse data model (CRM Dynamics) and copies the data to another DB.

The configuration of the component is fine, as is the authentication.

 

However, during the pipeline run I got an error that I don't understand

 

Error detail :

"'Type=System.IO.FileNotFoundException,Message=Could not load file or assembly 'Microsoft.IdentityModel.Clients.ActiveDirectory, Version=3.19.8.16603, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,'"

 

Do you have any ideas?

Thank in advance,

 

Have a nice day,

Vivien

Need Help
Pipeline
  • fudoki22's avatar
    fudoki22
    1 year ago

    Hi Vivien,

    I have been using copy data to push data from SQL to Dynamics and have found the errors generated when copy data fails often to be obscure.

    For example - 
    ErrorCode=DynamicsOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Dynamics operation failed with error code: -2147204784, error message: Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 515.,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,'

    Generic SQL error in this case turned out to be a timeout when trying to pull data from a large entity in dataverse into SQL (attachment I think from memory)

    In your case given you seem to simply be trying to push connection data from dataverse to a DB, I would suggest trying to use a query and restrict the query to a handful of rows (connection can be quite large in my experience)
    e.g. (change the entity to whichever is relevant for you)

    Hope it helps
    --Mike