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
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.
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.
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."
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
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
Hi
There was a wrong mapping of CDS between FnO and CRM. After correction, the issue was resolved.
Regards,
Wajahat Mirza
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,133 Most Valuable Professional
nmaenpaa 101,154