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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Failed to read entity ...
Microsoft Dynamics CRM (Archived)

Failed to read entity keys from Microsoft Dynamics Nav - CRM Connector

(0) ShareShare
ReportReport
Posted on by Bill Thompson. 435

I am using the Navision\CRM Connector.

I have successfully integrated Ennumerated Values, Currencies, SalesPersons, UOMS, Items.

When I integrate Nav Accounts to CRM I get the error :-  "Failed to read entity keys from Microsoft Dynamics Nav. There is an error in XML document (1,679)"

I have run Fiddler and can see it querying the records.

I have stripped down the mapping to 2 fields  - Account Number and NAme  - still get above error.

Only strange thing I noticed is that Fiddler does not display all the NAvision account fields.

Additionally I added extra fields to the Web Service Page for the account that did not display in the "out of the box" connector mapping.

Any Ideas?

 

*This post is locked for comments

I have the same question (0)
  • Bill Thompson. Profile Picture
    Bill Thompson. 435 on at
    Re: Failed to read entity keys from Microsoft Dynamics Nav - CRM Connector

    Konstantin,,

    Thanks for taking the time to reply.

    You were indeed correct  - we had a navision picklist field value in SQL that had a value that did not exist in the picklist dropdown in NAvision.

    We traced the account record by using switching on the connector log and it actually give us the field causing the XML(1,3739) error. We then looked at this field in SQL and seen a value that looked strange!.

    We changed the fields and ....... it worked - many thanks.

    Can I ask how you sync in batches.

    All invoices in table 5151 have a date modified fo 25/09/2012 as when the connector was installed.

    We are looking to filter the last 6 months invoices, by changing the date modified in the SQL table Integration lines table. However when we try to select the last range of invoice numbers for the last 6 months the record id does not display "Sales Invice Header: SI123456" , instead it displays text that we do not understand?

    Even if we use the connector filter option , it stills seems to query ALL the invoices and then apply the filter afterwards.

    How did you sync in batches????

  • Konstantin Levchenko Profile Picture
    Konstantin Levchenko 1,410 on at
    Re: Failed to read entity keys from Microsoft Dynamics Nav - CRM Connector

    Hi Bill,

    I had similar error when I had not allowed character in one of customer fields (very often happen when data copy pasted from external sources in NAV.

    To make sure that issue with data, I would suggest to perform next steps:

    1. Change "Check Data modified after" to NOW. So, when you run Connector, it not pick up any record.

    2. Make sure that map executed successfully and do nothing

    2. Create New Customer with minimum data.

    If it will sync successfully, then apparently here is NAV data issue. If still same error, then something else ...

    Here is I described my fun time with similar error:

    www.nav-connector.com/.../connector-sync-error-there-is-an-error-in-xml-document-1-700

    Cheers,

    Konstantin  

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#2
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans