Create a sink record with owner specification with Dynamics CRM connector error code 0x80048d19

Müller Michael 0 Reputation points
2023-03-30T07:45:24.8566667+00:00

We have created a dataflow in which I have a source that is an Azure SQL DB and a sink that references Dynamics CRM. In this flow we match the records of the source and the sink. Now we would like to pass the owner of the data set from the source to the sink, but this is not possible, we get the following error.

Job failed due to reason: Error response from server: Some({"error":{"code":"0x80048d19","message":"Error identified in Payload provided by the user for Entity :'orb_objects', For more information on this error please follow this help link https://go.microsoft.com/fwlink/?linkid=2195293 ----> InnerException : Microsoft.OData.ODataException: A 'PrimitiveValue' node with non-null value was found when trying to read the value of the property 'ownerid'; however, a 'StartArray' node, a 'StartObject' node, or a 'PrimitiveValue' node with null value was expected.\r\n at Microsoft.OData.JsonLight.ODataJsonLightPropertyAndValueDeserializer.ValidateExpandedNestedResourceInfoPropertyValue(IJsonReader jsonReader, Nullable`1 isCollection, String propertyName, IEdmTypeReference typeReference)\r\n at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.ReadPropertyWithValue(IODataJsonLightReaderResourceState resourceState, String propertyName, Boolean isDeltaResourceSet)\r\n at Microsoft.OData.JsonLight.ODat

We have created a pipline with a copy activity data and have implemented "Writing data to a lookup field" according to the instructions and it works.

User's image

Now we want to map the same in a dataflow and there we always get the error message mentioned above. I suspect that the connector in the Dynamics CRM sink does not allow this. Does anyone have a tip on how to give your other owner to the data set?

Dataflow:

User's image

Thank you for your feedback.

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

2 answers

Sort by: Most helpful
  1. Nikita Mahnitsky 0 Reputation points
    2023-06-14T08:12:59.14+00:00

    Hi Guys!

    I faced same issue yesterday
    Lookup fields can be uploaded to Dynamics sync, but i got the error considered above trying upload fields with relation to systemuser table

    Any news on this?

    Kind regards

    0 comments No comments

  2. Soham Jethara 0 Reputation points
    2023-09-29T15:54:24.8433333+00:00

    You will have to use the field "owninguser" on the entity instead of the owner to assign a user as an owner.

    0 comments No comments