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

(0) Share

Report

Posted on by Wajahat Mirza

254

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:

Other

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Arun Vinoth 11,615 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Wajahat Mirza 254 on at

Like (0)

Report

Hi

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

Regards,

Wajahat Mirza

Was this reply helpful? Yes No
Emmanuel_N_Z 30 on at

Like (1)

Report

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

Was this reply helpful? Yes No
johnnylawson 90 on at

Like (0)

Report

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

Was this reply helpful? Yes No
jkarau 10 on at

Like (0)

Report

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."

Was this reply helpful? Yes No
johnnylawson 90 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
jkarau 10 on at

Like (1)

Report

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.

Was this reply helpful? Yes No