web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Cannot Insert GUID to Contact ownerid when migrating from Salesforce to Dynamics using Kingswaysoft SSIS Integration Toolkit

(0) ShareShare
ReportReport
Posted on by 15

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!

I have the same question (0)
  • Suggested answer
    Saad Kabarousse Profile Picture
    734 on at

    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

  • MRic Profile Picture
    15 on at

    Thanks for the reply, however I have already done this and it still gives me the same error

  • Suggested answer
    bialix Profile Picture
    370 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 70 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 33 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans