This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 53%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
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.
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:
Thank you for your feedback.
Hi Müller Michael,
Thank you for posting query in Microsoft Q&A Platform.
Usually, this kind of error comes when mismatch between datatypes. Could you please check and make sure datatypes of
owneridcolumn between source and sink are same? If not, consider usingderived column transformationto change the data type to match with sink.
Please let me know how it goes. Thank you.
How to convert the ownerid from string to guid in a dataflow? In the Azure SQL DB, the datatype in the schema is uniqueidentifier. As soon as I go over the dataflow source it is string. can this be due to the datatype string?
can this have a connection with the data type? How can I solve this?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 31%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENM%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 69%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
You will have to use the field "owninguser" on the entity instead of the owner to assign a user as an owner.