KingswaySoft, Account does not exist on Lookup Contact for Listmember

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I am trying the import Marketing events using SSIS and Kingswaysoft and the CRM destination. My CRM is online Office 365.

I already succeeded to import contacts and accounts and successfully link them. I also imported Marketing Lists. Now I want to link the Marketing list to a contact, and i setup the CRM destination as follows:

3581.CRM-Destination.png

The fields EntityTyp and EntityTypeCode have the value "contact' for all imported rows, while fullname contains the fullname of the contact to be linked.

In the Text Lookup Editor for the entityid field I chose Target Fields and Primary Lookup for all Target Entities:

When I run the package it fails:

with the following error:

[Dynamics CRM Destination [2]] Error: An error occurred with the following error message: "System.Exception: Error(s) occurred when processing the batch: [1] CRM service call returned an error: account With Id = cd66ae3b-9840-e711-80fc-5065f38a5a01 Does Not Exist [2] CRM service call returned an error: account With Id = d266ae3b-9840-e711-80fc-5065f38a5a01 Does Not Exist [3] CRM service call returned an error: account With Id = d766ae3b-9840-e711-80fc-5065f38a5a01 Does Not Exist [4] CRM service call returned an error: account With Id = 93e6fe41-9840-e711-80fc-5065f38a5a01 Does Not Exist [5] CRM service call returned an error: account With Id = 98e6fe41-9840-e711-80fc-5065f38a5a01 Does Not Exist (SSIS Integration Toolkit for Microsoft Dynamics 365, v8.1.0.6275 - DtsDebugHost, v11.0.6020.0)

It succeeded o lookup the fullnames of the contacts, the mentioned ID's are the correct contactid's, but then apparently the component checks if theses ID's are accounts? They are not of course, they are contacts!

What is going wrong here? This is a very simple example!

When Itry to link accounts it works perfect!

Who can help me? Tha

*This post is locked for comments

All responses (16)

Answers (3)

Community Member Microsoft Employee on at

Like (0)

Report

RE: KingswaySoft, Account does not exist on Lookup Contact for Listmember

Hi guys!

You were right! After defining the Marketing events as Contact Type (createdfromcode=2) the import succeeded.

Probably a moredescriptive error code would help here...

Thanks!
Daniel Cai 935 on at

Like (0)

Report

RE: KingswaySoft, Account does not exist on Lookup Contact for Listmember

Hi Herman, please do check how your list was setup as Andrii has suggested above. The list might have been set up for "account" instead of "contact" which could cause this type of error.
Community Member Microsoft Employee on at

Like (0)

Report

RE: KingswaySoft, Account does not exist on Lookup Contact for Listmember

Uncheck Skip Record when lookup fails did not solve the problem

Unfortunately. It is probably the Marketing List setting

Thanks,

Herman
Community Member Microsoft Employee on at

Like (0)

Report

RE: KingswaySoft, Account does not exist on Lookup Contact for Listmember

Hi!

Try uncheck Skip Record if Lookup Fails

Dynamica Labs http://dynamicalabs.com/

Disclaimer:

Any post on this page provided "as is" without warranty of any kind and is for educational and information purposes only. We disclaim any liability arising from any reliance placed on any post.
Community Member Microsoft Employee on at

Like (0)

Report

RE: KingswaySoft, Account does not exist on Lookup Contact for Listmember

Thomas, you are probably right.

I have to discuss it with my CRM designer, but he already left for the weekend.

So I guess I will check this on monday

Thanks to you both

erman
Community Member Microsoft Employee on at

Like (0)

Report

RE: KingswaySoft, Account does not exist on Lookup Contact for Listmember

Hi Aleš,

Yes I did, I also tried entittypecode with ignore, and tried using the integer value (2) instead of "contact".

In general I tried all combinations.

The result is the same error: >The retrieved (contact)-ID is not a valid accountid.

Is there somewhere a setting in CRM restricting the entries on a Marketing list to account only?
Verified answer

a33ik 84,323 Most Valuable Professional on at

Like (0)

Report

RE: KingswaySoft, Account does not exist on Lookup Contact for Listmember

Hello,

What's the target entity of your Marketing List? Can you please confirm it's a contact?
Verified answer

ashlega 34,475 on at

Like (0)

Report

RE: KingswaySoft, Account does not exist on Lookup Contact for Listmember

Actually, just following Thomas's idea.. if it's targetted at "Accounts" and you are trying to add a contact.. maybe that's where it gets confused since it's expecting an account
Thomas David Dayman 11,323 on at

Like (0)

Report

RE: KingswaySoft, Account does not exist on Lookup Contact for Listmember

Or possibly excluding accounts and leads?
Verified answer

Thomas David Dayman 11,323 on at

Like (1)

Report

RE: KingswaySoft, Account does not exist on Lookup Contact for Listmember

Is you're Marketing List of type 'contact'?