For starters I created a field in the Users object in Salesforce where I can input the ownerid from Dynamics. Then I also created a field to get the respective ownerid in the Contacts object. I then map the same field to the ownerid in the Contact entity of Dynamics CRM. I also have a custom field wherein I have specified the owneridtype.
Now when I try to migrate the data I get these errors:
[Dynamics CRM Destination [12]] Error: An error occurred with the following error message: "System.Exception: An exception has occurred when processing the input value of 'ownerid' field: Error: Failed to set field 'ownerid' value to '[example GUID here]' for entity 'contact' (field type: Owner, value type: Guid). System.ArgumentNullException: Value cannot be null.
Parameter name: entityType (SSIS Integration Toolkit for Microsoft Dynamics 365, v11.1.0.7311 - DtsDebugHost, v14.0.3002.145) (SSIS Integration Toolkit for Microsoft Dynamics 365, v11.1.0.7311 - DtsDebugHost, v14.0.3002.145)System.Exception
: Error: Failed to set field 'ownerid' value to '[example GUID here]' for entity 'contact' (field type: Owner, value type: Guid). System.ArgumentNullException: Value cannot be null.
Parameter name: entityType (SSIS Integration Toolkit for Microsoft Dynamics 365, v11.1.0.7311 - DtsDebugHost, v14.0.3002.145)".
I've also tried using the lookup option but to no avail. I can also ignore the ownerid altogether but it defeats the purpose of trying to assign the Contacts to the right owners. Any help would be appreciated!
Hello,
Actually, I've created 2 custom columns before upserting a record.
First contains team/user guid, second - 8 for systemuser and 9 for team.
First was used as ownerid, second as owneridtype.
It couldn't work for a long time. Then I realized, that I'm missing few privileges on integration account. After adding possibility to create records of certain entity it worked like a charm.
Thanks for the reply, however I have already done this and it still gives me the same error
Hello,
In order to set the owner, you have to set OwnerIdType field too, it's an integer that contains 1 if the owner is a System user and 2 for Team and 4 for BusinessUnit
Daivat Vartak (v-9d...
225
Super User 2025 Season 1
Eugen Podkorytov
106
Muhammad Shahzad Sh...
106
Most Valuable Professional