Can't insert activities into CRM365

Avatar

Avatar

menno_74

Avatar

menno_74

menno_74

30-01-2018

We are in the process of upgrading from  Microsoft Dynamics CRM 4.0 to Microsoft Dynamics 365.

External account is configured  and I am able to synchronize entities from CRM to Adobe campaign. 

1406416_pastedImage_2.png

Next I am able to export contacts and/or leads form Adobe campaign to CRM.

But when I try to insert an appointment, Email or Campaign response, I receive an error:  Error while inserting the object with local ID '399974922', cause: 'An unexpected error occurred.'

By trial and error filled the minimum of required fields, untill the point no errors on missing data are reported  in the logs. Resulting in the unexpected error (http error 500 is logged prior to this message.)

Generic CRM connector:

1406423_pastedImage_3.png

And when I use the Specific Dynamics connector (this is based on a simple synchronization: import responses from CRM to campaign via connector, update subject and local change dates and synchronyze these changes back to CRM):

1406425_pastedImage_5.png

I get this error:

Error while updating object (local ID: '400048217', remote ID: '691CEA8E-2FF5-E711-A82A-000D3AB4B471'), cause: 'When updating an activity, regarding object id has been provided, but regarding object type was missing'.

adding/removing regardingobjecttpecode does not effect the outcome.

Can't find anything when searching the net regarding these errormessage(s).

Does anyone recognize this ?

Kind Regards

Menno.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

menno_74

Avatar

menno_74

menno_74

16-11-2018

Hi glvarrichio,

As a matter of fact I found some kind of workaround for this.

First of all: You have to  change some settings in the defenition of the dataschema.

This involves some editing of XML, so please stay with me on this one

Once you configured an external account for a certain msCRM connection, the definition of the entities you chose to use with the account is saved in a dataschema. (Administration\Configuration\Data Schemas).

Screenshot - 11_16_2018 , 9_44_19 AM.png

You can find the schema in the namespace 'MSCRM' and it will contain the name (internal name) of the account you configured (the name is preceded by 'mscrmSchema', in my case).

Screenshot - 11_16_2018 , 9_45_01 AM.png

Screenshot - 11_16_2018 , 9_50_47 AM.png

In this schema you will have to find the activity (entitiy) that you want (need) to insert an activity for with a certain regarding (ie. contact) and change the defenitions of the "regardingobjectId" element to do so.

For example Letter:

Screenshot - 11_16_2018 , 9_55_03 AM.png

Find the element defenition for "regardingobjectId":

<element desc="[lookup](account) Do not erase or modify this field." label="Regarding(optional)"
               length="36" name="regardingobjectid" type="string"/>

And change the defenition to

<element desc="[lookup](contact) Do not erase or modify this field." label="Regarding(optional)"
               length="36" name="regardingobjectid" type="string"/>

That's it!

Now save the schema, disconnect and reconnect to accept the changes, you should now be able to save a letter with a contactId as a regarding.

The specific changes to save a campaign response for a campaign as a regarding ,are to simply change

<element desc="[lookup](bulkoperation) Do not erase or modify this field."

label="Parent Campaign" length="36" name="regardingobjectid" type="string"/>

to

<element desc="[lookup](campaign) Do not erase or modify this field." label="Parent Campaign"

length="36" name="regardingobjectid" type="string"/>

Again: save the schema, disconnect and reconnect to accept the changes, you should now be able to save a campaign response with campaign as a regarding.

A word on the effectiveness of the workaround: We've been using this workaround for 'campaign response' , 'phonecall' and letter since go-live on september 1, 2018.

That said: I am confident that this workaround as such is suitable for 'Email', 'Task' and other activitiy-based entitites the like.

Kind Regards,

Menno

Answers (12)

Answers (12)

Avatar

Avatar

menno_74

Avatar

menno_74

menno_74

14-03-2018

Hi Florent,

We've asked Adobe PS to help out. They in turn asked assistance with Microsoft via the Adobe-Microsoft partner program.

They have been able to reproduce the error. After that they investigated if this happens on a clean install of Adobe campaign connected to a clean install of CRM365. Both v6 and v7 of campaign encounter the same error.

In parallel I've tried to insert an activity to CRM via SoapUI and via visual studio. SoapUi -for now- is unsuccesfull in making connection so far ("An error occurred when verifying security for the message"). Via visualstudio the insert of a letter activity with regarding object contact works fine (using only three prameters: regardingobjecttype, regardingobjectId and subject). Trying to do the same via Adobe Campaign results in the error "Account with id ... does not exist"

Also inserting a letter activity from our campaign instance to crm 365, linked (regardingobject) to an existing account in CRM works just fine. If, however we change the parameters to any other CRM entity, we get the mentioned error; always on account.

So it seems that for the 365 version of Dynamics CRM somehow the translation of the given regarding type for entity gets ignored between Adobe campaign and Dyamics 365 CRM.

To be continued...

Menno

Avatar

Avatar

menno_74

Avatar

menno_74

menno_74

18-04-2019

Hi varrichio,

I hope you found a solotion already.

EDIT:

The "To" and "From" fields are of the CRM type  "activityparty"  and Activityparty is a multi-part field and as such is not supported by Adobe Campaign

We solved this specific problem by filling the "to" field by means of a CRM workflow (we copy it from a custom fleld added to the entitiy phonecall, which in turn is filled with the corresponding guid selected in the adobe Campaign process).

Kind regards,

Menno

Avatar

Avatar

glvarrichio

Avatar

glvarrichio

glvarrichio

20-12-2018

Dear Menno,

I had done what you mentioned and it worked like a charm, except for the PhoneCall.To and PhoneCall.From. These fields seems to work in another particular way. Please take a quick look at this: Link directly from microsoft and this link, a blog that I found that the guy kindly simplify the process but no solution.

Well, I belive the logic would be:

Pass the activity CRM ID to activity party and specify the parties, mentioning 1 to Sender and 2 to To field. Does that make sense? Do you mind helping me come up of what of doing this?

Thank you in advance

Avatar

Avatar

menno_74

Avatar

menno_74

menno_74

30-11-2018

Hi varrichio,

That depends on which field is shown there in the CRM page. It could be you need to fill additional fields as ' Call To' to get this displayed correctly.

In chrome browser you can install a plugin called 'level up for Dynamics CRM/365'  which can help you pull the fieldnames (logical names) from the screen, so you can find more easily which field(s) to map.

Kind Regards,

Menno.

Avatar

Avatar

varrichio

Avatar

varrichio

varrichio

16-11-2018

Menno, thank you so much for the response. It worked, greattttt

The image below is from a customer activity, it is getting assigned to a customer but it is not showing the customer name in the activity client name, maybe it is something related to the config...I will try a little bit more...

Thank you so much.....

1623256_pastedImage_0.png

Thank you again

Regards

Avatar

Avatar

glvarrichio

Avatar

glvarrichio

glvarrichio

31-10-2018

Hi Menno,

I´m having the same issue here, have you figured out a solution for this?

Thank you

Avatar

Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239

Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239
florentlb

04-04-2018

Thanks Menno for the update,

Let us know when you have more on this and find a way through!

Florent

Avatar

Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239

Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239
florentlb

12-03-2018

Hi,

Any update to share on this?

Florent

Avatar

Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239

Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239
florentlb

09-02-2018

Hi Menno,

Thanks for the update on your investigations. That may be a bug or a limitation in the new activity, I'd recommend getting in touch with support in case they have already heard about that.

Vipul Raghav​, do you know about this behaviour?

Florent

Avatar

Avatar

menno_74

Avatar

menno_74

menno_74

07-02-2018

After changing the order of fields to synchronyze, I found a scenario that gave me more error info:

“Error while inserting the object with local ID '399932262', cause: 'Account With Id = 33a6ce18-def9-e711-a829-000d3ab4be81 Does Not Exist'.”

This is interesting, beceause I’m inserting a  letter activity from campaign to CRM.  This letter is to be connected to a contact. RegadingObjectId therefore is the id of the contact (contactid).

Yes! It is the Id mentioned in the errormessages. Strange thing about it is that the regardingobjecttype I configured to be synchronized is ‘contact’ but instead CRM throws an error on ‘account’.

So if CRM is trying to find  mentioned guid in the ‘account’ entity; it seems correct to throw an error, as it does not exist as account id; it is a contact id. In that case either campaign ignores the option given via  ‘regardingobjecttype’ (where in case of CRM 4.0 sync it works) or CRM ignores it and therefore somehow CRM thinks the regarding object is account in stead of contact.

1412804_pastedImage_0.png

Avatar

Avatar

menno_74

Avatar

menno_74

menno_74

02-02-2018

Hi Florent.

Thanks for looking into this.

We use version 6.1 build 8887 (both server and client).

The reason for specifying 'campaign' twice, is because I got the same error when I used it for '@regardingibjectid' (described as regardingobjecttype  by CRM) only.

We've been using adobe campaign in combination with CRM 4.0 for a couple of years already and we do not face any problems when synchronizing (inserting) activities  (such as email, letter, appointment) in to CRM.

I can remember having an issue in connecting to CRM during implementation (version 5.1): "partylist" data type was not yet supported.

In the current version (6.1) campaign neatly dismisses the datatype "partylist" as being unusable.

If you need me to provide more details: please let me know.

Kiind Regards,

Menno

Avatar

Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239

Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239
florentlb

02-02-2018

Hi Meno,

What is your Campaign build number? Few build in 2017 contained enhancements for the Dynamics connector. That may be related. I'm not familiar with activities, could that be related to the fact that the 'campaign' local field is used twice here?

Florent