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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Error while connecting to MS Dynamics CRM

adityaa24840389
Level 1
Level 1

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

3 Replies
Garima_Gakhar
Employee
Employee

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.

adityaa24840389
Level 1
Level 1

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

pablo_rosero1
Level 10
Level 10

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