web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Map: NAV Customer Card...
Microsoft Dynamics NAV (Archived)

Map: NAV Customer Card to Account

(0) ShareShare
ReportReport
Posted on by charliejamesuk 585

Running the default connector map "NAV Customer Card to Account", results in "Exception occurred in Microsoft Dynamics NAV". Checking the application logs reveals the following errors:

Exception occurred in Microsoft Dynamics NAV
    --- Exception Dump ---
    Caught Exception: [Microsoft.Dynamics.Integration.AdapterAbstractionLayer.AdapterException] Exception occurred in Microsoft Dynamics NAV
    Stack trace:
   at Microsoft.Dynamics.Integration.Adapters.Nav2009.NavObjectProvider.ReadObjectKeys(DateTime modifiedDate)
   at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.ReadObjectKeyList(DbMap map, DateTime queryDate, Int32& count)
   at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.ProcessRecordsImplementation(OperationType operationType)

    Inner Exception: [System.NullReferenceException] Object reference not set to an instance of an object.
    Stack trace:
   at Microsoft.Dynamics.Integration.Adapters.Nav2009.CustomerObjectProvider.ReadDynamicObjectKeys(DateTime modifiedDate)
   at Microsoft.Dynamics.Integration.Adapters.Nav2009.NavObjectProvider.ReadObjectKeys(DateTime modifiedDate)

Any ideas on how to troubleshoot this further? Other maps complete without errors.

Regards

Charlie

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    keoma Profile Picture
    keoma 32,729 on at

    goto to form "marketing setup", tab "Synchronisation" and disable and enable the "Enable Connector" checkbox. that reruns the integration configuration. then try again.

  • charliejamesuk Profile Picture
    charliejamesuk 585 on at

    Just done that, still get the following:

    Exception occurred in Microsoft Dynamics NAV
        --- Exception Dump ---
        Caught Exception: [Microsoft.Dynamics.Integration.AdapterAbstractionLayer.AdapterException] Exception occurred in Microsoft Dynamics NAV
        Stack trace:
       at Microsoft.Dynamics.Integration.Adapters.Nav2009.NavObjectProvider.ReadObjectKeys(DateTime modifiedDate)
       at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.ReadObjectKeyList(DbMap map, DateTime queryDate, Int32& count)
       at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.ProcessRecordsImplementation(OperationType operationType)

        Inner Exception: [System.NullReferenceException] Object reference not set to an instance of an object.
        Stack trace:
       at Microsoft.Dynamics.Integration.Adapters.Nav2009.CustomerObjectProvider.ReadDynamicObjectKeys(DateTime modifiedDate)
       at Microsoft.Dynamics.Integration.Adapters.Nav2009.NavObjectProvider.ReadObjectKeys(DateTime modifiedDate)

  • keoma Profile Picture
    keoma 32,729 on at

    check the mapping for the field modifiedDate.

    seems to be a problem with that.

  • charliejamesuk Profile Picture
    charliejamesuk 585 on at

    There is a "Modified On" field which is not mapped. Is this the field you mean?

  • Suggested answer
    keoma Profile Picture
    keoma 32,729 on at

    did you follow the install guide?

    mbs.microsoft.com/.../MDNAV2009R2_CRMConnector

    have you installed the required hotfixes for nav 2009?

    1. Microsoft Dynamics NAV 2009 R2 with KB 2597312 applied.

    2. Microsoft Dynamics NAV 2009 R2 with KB 2721512 applied.

  • keoma Profile Picture
    keoma 32,729 on at

    is that the complete stacktrace?

    if not, please publish the complete exception list.

    have you made any changes to the customer card?

    please publish the list of the integration records.

  • charliejamesuk Profile Picture
    charliejamesuk 585 on at

    That is the complete exert from the application logs.

    How can I view the Integration records?

  • Suggested answer
    keoma Profile Picture
    keoma 32,729 on at

    i did some research. result: it seems to be a problem with some customer records, maybe with wrong/missing option values.

    but also can be a problem with the integration records, which have to do with table customer (more than one, ...).

    to view the integration records: open table 5151 directly from the dev.env.

  • charliejamesuk Profile Picture
    charliejamesuk 585 on at

    I can see table 5151 which is populated with various information.

    Must be a good 5000 records.

  • keoma Profile Picture
    keoma 32,729 on at

    first open table 5150 integration page and filter for Servicename = *Customer*

    do you get more than 1 records? you should get at least a record with Page-ID = 21.

    then open table 5151 and filter for Page-ID = 21. delete the records and rerun the integration job (marketing setup: disable and then re-enable the checkbox "enable connector). sometimes that helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans