locked
Dynamics CRM NAV connector infinite loop RRS feed

  • Question

  • Hello,


    We’re currently installing and configuring the NAV connector with CRM 4.0 in our own organization. We’ve set up the following two mappings:

     

    ·         NAV Customer Card à Account

    ·         Account à NAV Customer Card

     

    Both maps run fine when activated separately.

     

    Unfortunately though, when both maps are activated simultaneously, changes made in either NAV or CRM keep going back and forth in the connector infinitely. Technically what happens is that a change in NAV results in an update in CRM affecting the modified date timestamp of the particular entity in CRM. When the Account à NAV Customer Card map runs next the connector picks up the change in CRM from the updated modification timestamp resulting in updating the record in NAV. This process repeats itself infinitely.

     

    Here’s an excerpt from the log file of the connector:

     

    INFO TID:89 [2011-09-02T10:23:00.2211165+02:00]: [NAV Customer Card to Account] has started in Map mode.

    VERBOSE TID:50 [2011-09-02T10:23:00.2367412+02:00]: [NAV Customer Card to Account] with MapId [19c9de4d-c3ed-4dd3-b0a8-e93dc86ec15a] is searching for READ keys using 02-09-2011 08:22:15 as last change.

    VERBOSE TID:78 [2011-09-02T10:23:00.2367412+02:00]: [NAV Customer Card to Account] is searching for DELETE keys using 02-09-2011 08:22:15 as last change.

    VERBOSE TID:78 [2011-09-02T10:23:00.2523659+02:00]: [NAV Customer Card to Account] returned no records to delete.

    INFO TID:89 [2011-09-02T10:23:00.6586081+02:00]: [NAV Customer Card to Account] has completed. 1 record(s) have been written. 0 record(s) have been deleted. 0 record(s) have failed. Total runtime was 0.4374916 seconds.

    INFO TID:78 [2011-09-02T10:23:15.4708237+02:00]: [Account to NAV Customer Card] has started in Map mode.

    VERBOSE TID:50 [2011-09-02T10:23:15.4708237+02:00]: [Account to NAV Customer Card] with MapId [3ea35375-de1e-4cfa-a32e-0be13b6849a8] is searching for READ keys using 02-09-2011 08:22:30 as last change.

    VERBOSE TID:71 [2011-09-02T10:23:15.4708237+02:00]: [Account to NAV Customer Card] is searching for DELETE keys using 02-09-2011 08:22:30 as last change.

    VERBOSE TID:71 [2011-09-02T10:23:15.4864484+02:00]: [Account to NAV Customer Card] returned no records to delete.

    INFO TID:78 [2011-09-02T10:23:15.8301918+02:00]: [Account to NAV Customer Card] has completed. 1 record(s) have been written. 0 record(s) have been deleted. 0 record(s) have failed. Total runtime was 0.3749928 seconds.

    INFO TID:71 [2011-09-02T10:23:45.0327561+02:00]: [NAV Customer Card to Account] has started in Map mode.

    VERBOSE TID:50 [2011-09-02T10:23:45.0327561+02:00]: [NAV Customer Card to Account] with MapId [19c9de4d-c3ed-4dd3-b0a8-e93dc86ec15a] is searching for READ keys using 02-09-2011 08:23:00 as last change.

    VERBOSE TID:79 [2011-09-02T10:23:45.0327561+02:00]: [NAV Customer Card to Account] is searching for DELETE keys using 02-09-2011 08:23:00 as last change.

    VERBOSE TID:79 [2011-09-02T10:23:45.0640055+02:00]: [NAV Customer Card to Account] returned no records to delete.

    INFO TID:71 [2011-09-02T10:23:45.2358772+02:00]: [NAV Customer Card to Account] has completed. 1 record(s) have been written. 0 record(s) have been deleted. 0 record(s) have failed. Total runtime was 0.1874964 seconds.

    INFO TID:89 [2011-09-02T10:24:00.3137127+02:00]: [Account to NAV Customer Card] has started in Map mode.

    VERBOSE TID:79 [2011-09-02T10:24:00.3137127+02:00]: [Account to NAV Customer Card] with MapId [3ea35375-de1e-4cfa-a32e-0be13b6849a8] is searching for READ keys using 02-09-2011 08:23:15 as last change.

    VERBOSE TID:50 [2011-09-02T10:24:00.3137127+02:00]: [Account to NAV Customer Card] is searching for DELETE keys using 02-09-2011 08:23:15 as last change.

    VERBOSE TID:50 [2011-09-02T10:24:00.3762115+02:00]: [Account to NAV Customer Card] returned no records to delete.

    INFO TID:89 [2011-09-02T10:24:00.7668290+02:00]: [Account to NAV Customer Card] has completed. 1 record(s) have been written. 0 record(s) have been deleted. 0 record(s) have failed. Total runtime was 0.4531163 seconds.

    INFO TID:82 [2011-09-02T10:24:30.3443861+02:00]: [NAV Customer Card to Account] has started in Map mode.

    VERBOSE TID:65 [2011-09-02T10:24:30.3600108+02:00]: [NAV Customer Card to Account] with MapId [19c9de4d-c3ed-4dd3-b0a8-e93dc86ec15a] is searching for READ keys using 02-09-2011 08:23:45 as last change.

    VERBOSE TID:87 [2011-09-02T10:24:30.3600108+02:00]: [NAV Customer Card to Account] is searching for DELETE keys using 02-09-2011 08:23:45 as last change.

    VERBOSE TID:87 [2011-09-02T10:24:30.3756355+02:00]: [NAV Customer Card to Account] returned no records to delete.

    INFO TID:82 [2011-09-02T10:24:30.7037542+02:00]: [NAV Customer Card to Account] has completed. 1 record(s) have been written. 0 record(s) have been deleted. 0 record(s) have failed. Total runtime was 0.3593681 seconds.

    INFO TID:87 [2011-09-02T10:24:45.4847204+02:00]: [Account to NAV Customer Card] has started in Map mode.

    VERBOSE TID:65 [2011-09-02T10:24:45.4847204+02:00]: [Account to NAV Customer Card] with MapId [3ea35375-de1e-4cfa-a32e-0be13b6849a8] is searching for READ keys using 02-09-2011 08:24:00 as last change.

    VERBOSE TID:83 [2011-09-02T10:24:45.5003451+02:00]: [Account to NAV Customer Card] is searching for DELETE keys using 02-09-2011 08:24:00 as last change.

    VERBOSE TID:83 [2011-09-02T10:24:45.5159698+02:00]: [Account to NAV Customer Card] returned no records to delete.

    INFO TID:87 [2011-09-02T10:24:45.7503403+02:00]: [Account to NAV Customer Card] has completed. 1 record(s) have been written. 0 record(s) have been deleted. 0 record(s) have failed. Total runtime was 0.2656199 seconds.

     

    Any idea as to how we can prevent this from happening?

     

    Thanks for your time.

    Friday, September 2, 2011 8:52 AM

Answers

  • The way we handle this in Scribe is to ignore changes made by the logged in user account that makes the changes.  For example, if you have a user account named Integration User and that user makes the Nav changes in CRM, then setup the Connector to ignore changes where the modified by is the Integration User.


    Regards, Donna

    • Marked as answer by Matthiasen Thursday, September 8, 2011 6:40 AM
    Friday, September 2, 2011 12:31 PM

All replies

  • The way we handle this in Scribe is to ignore changes made by the logged in user account that makes the changes.  For example, if you have a user account named Integration User and that user makes the Nav changes in CRM, then setup the Connector to ignore changes where the modified by is the Integration User.


    Regards, Donna

    • Marked as answer by Matthiasen Thursday, September 8, 2011 6:40 AM
    Friday, September 2, 2011 12:31 PM
  • Hi Donna,

    Thanks for your reply. Still waiting to hear how Microsoft handles this :)

    --Matthiasen

    Monday, September 5, 2011 9:53 AM
  • It turns out the dynamics connector handles this the same way. Problem solved :)

    Thanks.

    Thursday, September 8, 2011 6:41 AM
  • Terrific, glad this is solved for you.

    Regards, Donna

    Thursday, September 8, 2011 10:40 AM