Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Error while connecting to MS Dynamics CRM

Avatar

Avatar
Boost 1
Level 1
adityaa24840389
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
adityaa24840389
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
adityaa24840389
Level 1

18-09-2018

Hi,

We are trying to import data from MS Dynamics CRM, using Microsoft CRM activity in the workflow. However it gets stuck up with following errors. Any clue as what is missing here...

1573870_pastedImage_0.png

Regards,

Aditya

Replies

Avatar

Avatar
Boost 5
Employee
Garima_Gakhar
Employee

Likes

44 likes

Total Posts

77 posts

Correct Reply

38 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Employee
Garima_Gakhar
Employee

Likes

44 likes

Total Posts

77 posts

Correct Reply

38 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
Garima_Gakhar
Employee

18-09-2018

Hi adityaa24840389​,

These are not really errors but Warnings. While Errors are in red crosses, Warnings are triangles or rectangles with an 'i' in between.

'Internal Server Error' is attributed to a temporary error, mostly network connection issue.

Is the setup with Microsoft CRM fine, has it ever worked before.

Avatar

Avatar
Boost 1
Level 1
adityaa24840389
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
adityaa24840389
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
adityaa24840389
Level 1

19-09-2018

Hi Garima,

It has partially worked before with generic CRM connector activity, where it gave message in logs that 4 records were fetched, but again those records never turned up in schema.

Tried this MS CRM activity, but this also gives error.

One more hint is, the schema that was created gives following error. May be this is causing the issues.

1574458_pastedImage_0.png

The schema def is this:

<srcSchema _cs="Order (abc)" created="2018-09-18 09:00:03.712Z" createdBy-id="0" desc="Order"
           entitySchema="xtk:srcSchema" img="xtk:schema.png" label="Order" labelSingular="Order"
           lastModified="2018-09-19 06:56:57.124Z" mappingType="sql" md5="0F9A3DA98160FDEB041C6766CC3692DC"
           modifiedBy-id="0" name="Order" namespace="abc" xtkschema="xtk:srcSchema">
  <createdBy _cs="hidden id"/>
  <modifiedBy _cs="hidden id"/>

  <element desc="Order" label="Order" labelSingular="Order" name="Order">
    <key internal="true" name="householdId">
      <keyfield xpath="@householdId"/>
    </key>
    <attribute label="rowId" name="rowId" type="string"/>
    <attribute label="modifiedDate" name="modifiedDate" type="datetime"/>
    <attribute label="changeDate" name="changeDate" type="datetime"/>
    <attribute label="householdId" name="householdId" type="string"/>
    <attribute label="name" name="name" type="string"/>
  </element>
</srcSchema>

The query looks for abcorder, is it something related to case sensitive...

Regards,

Aditya

Avatar

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct Reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile
pablo_rosero1
Level 10

28-11-2018

Hi Aditya,

I'm unsure but here's how to integrate Dynamics 365 with Campaign Classic.

Please give it a try by following the steps: How to Integrate Dynamics 365 with Adobe Campaign Classic (ACC)

I hope this works for you!

All the best,

Pablo