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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Text Lookup Invalid
Microsoft Dynamics CRM (Archived)

Text Lookup Invalid

(0) ShareShare
ReportReport
Posted on by Victor Onyebuchi 410

Hi All,

I am doing migration using kingswaysoft from a CSV file to a dynamic 365 database, a created a fuction to manually add an owner, the output of the function are two variable - 1.) Owner , with an email in string and 2.) OwneridType

I mapped the Owner output to system user and manual lookup of domainname(because its an email) and the owneridtype to the field owneridtype, but I am getting the below error:

"Error: Failed to set field 'ownerid' value to 'xxxxxxxxx' for entity 'account' (field type: Owner, value type: String). System.Exception: 'ownerid' field has an invalid text lookup setting for lookup entity 'account'. (SSIS Integration Toolkit for Microsoft Dynamics 365, v11.0.0.7160 - DtsDebugHost, v13.0.4495.10)".

Someone with better experience please help. Thanks 

*This post is locked for comments

I have the same question (0)
  • bac26 Profile Picture
    bac26 2,268 on at

    It sounds like it is trying to put in an owner in that does not exist as a user.  

  • Suggested answer
    Dynamics365 Rocker Profile Picture
    Dynamics365 Rocker 7,755 on at

    Kindly check if the user you want to set as owner is in CRM or not.

  • Victor Onyebuchi Profile Picture
    Victor Onyebuchi 410 on at

    Apparent I was migrating data from a CSV files with loads of commas in between string, SSIS sees the comma as a delimiter and moves the next word after the comma to the next field. Hence, I was i was having the mapping errors. All resolved now, just incase someone else faces thesame problem in the future.

  • Suggested answer
    Victor Onyebuchi Profile Picture
    Victor Onyebuchi 410 on at

    Apparent I was migrating data from a CSV files with loads of commas in between string, SSIS sees the comma as a delimiter and moves the next word after the comma to the next field. Hence, I was i was having the mapping errors. All resolved now, just incase someone else faces thesame problem in the future

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans