Skip to main content

Notifications

Customer Service forum

Error while running Common Data Services for D365 CRM online and Finance Operations

Posted on by 245

Hi,

I am getting following error when I run power apps project of Data integration to transfer data from D365 CRM online (Customer Experience) to Finance and Operations using Common Data Services.

5 Attempts to get data from https://<CRM URL>/tables/quotes/items?$select=shipto_city, shipto_country, shipto_line1, billto_line2, billto_postalcode, quotenumber, shipto_stateorprovince, name, versionnumber&$expand=transactioncurrencyid($select=isocurrencycode)&$filter=(versionnumber le 5502215) and (((statecode eq 1) and (msdynce_hasexternallymaintainedproductsonly eq true)))&$orderby=versionnumber desc failed.

After running project it gets completed with green tick mark however, the internal message shows above error.

I am transferring Sales Quotation from CRM to F&O. My CRM online is deployed in Europe region however, Finance and operations is deployed in South Indian region. Please suggest what can be the cause of error.

Regards,

Wajahat Mirza

Categories:
  • jkarau Profile Picture
    jkarau 10 on at
    RE: Error while running Common Data Services for D365 CRM online and Finance Operations

    I've received some information back from MSFT on our ticket.  

    Long story short, CDS has a limit of 10 $expand commands in the OData query that is being used to query from CDS to update F&O.  The out of the box data entry mappings are beyond that limit.  So, the suggested workaround was to remove some linked entities from the mappings, run the initial sync, put those mappings back and remove others, re-run the sync, again put those back, and then fully enable dual-write.

    I'm currently working on trying that workaround, but I'm also pushing back on when they believe they'll have this bug fixed.

  • johnnylawson Profile Picture
    johnnylawson 90 on at
    RE: Error while running Common Data Services for D365 CRM online and Finance Operations

    I've got a support ticket in with MSFT on this and awaiting their answer. They are looking into my environment was the last status. I'll report back any findings.

  • jkarau Profile Picture
    jkarau 10 on at
    RE: Error while running Common Data Services for D365 CRM online and Finance Operations

    Is there any update on this.

    I'm attempting an initial sync of existing customers from CDS into F&O and receiving the same error.  The mappings have not been customized.

    When I attempt to run the generated OData query against CRM directly, I get the following error message:

    "Number of link entities in query exceeded maximum limit."

  • johnnylawson Profile Picture
    johnnylawson 90 on at
    RE: Error while running Common Data Services for D365 CRM online and Finance Operations

    Any update on this? I'm running into this same issue trying to do the dual write sync of customers from sales up to operations / supply chain. Thanks

  • Emmanuel_N_Z Profile Picture
    Emmanuel_N_Z 30 on at
    RE: Error while running Common Data Services for D365 CRM online and Finance Operations

    Could you please advise what the field mapping error was because i am receiving the same error but I am trying to push Accounts from CRM to Customers in F&O

  • Verified answer
    Wajahat Mirza Profile Picture
    Wajahat Mirza 245 on at
    RE: Error while running Common Data Services for D365 CRM online and Finance Operations

    Hi

    There was a wrong mapping of CDS between FnO and CRM. After correction, the issue was resolved.

    Regards,

    Wajahat Mirza

  • Suggested answer
    Arun Vinoth Profile Picture
    Arun Vinoth 11,613 on at
    RE: Error while running Common Data Services for D365 CRM online and Finance Operations

    Region should not be the problem here. Probably authentication failure or some connection timeout kind of issues surfacing without full exception.

    Check the query for its completeness & if it returns expected data.

    Can you share the screenshot of where you are seeing this message.

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,133 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans