Error "Attribute: ownerid cannot be set to NULL".

  • 34Views
  • Last Post 18 January 2019
  • Topic Is Solved
Jonathan Killen posted this 08 January 2019

You are supposed to be able to use Lookup mapping with the "Set null when no match found" option to set the OwnerId (Owner) of items in Daynamics CRM when importing items from SugarCRM. In this case, if Lookup finds Dynamics CRM user with the same name as SugarCRM user, this owner will be assigned for the corresponding record. If corresponding Dynamics CRM user is not found, a NULL value should be sent by Skyvia to Dynamics CRM and the necessary OwnerId will be assigned automatically based on the user assiciated with the used Dynamics CRM connection.
But, currently it will give an error "Attribute: ownerid cannot be set to NULL".

I have it setup like this:

Target Lookup:
Object - systemuser
Result column - systemuserid
lookup key column - fullname
Source lookup:
Object - User
Result Column - user_name
Lookup Key Column - Id
Column - assigned_user_id

I also have the  "Set null when no match found" option turned on for both the Target Lookup and the Source Lookup.  Is this the correct way to set this up?  Please help me figure out why this is not working as expected.

Order By: Standard | Newest | Votes
Mariia Zaharova posted this 10 January 2019

We have contacted you by email, please check it.

Jonathan Killen posted this 18 January 2019

Support told me that it is supposed to give this error.  So, I had to do a workaround by doing a Mass Update in Sugar CRM to change the owner of the items to a user what exists in Dynamics.  This fixed it.