D365 Integration With Odata : Data Entity Write Failed

(0) Share

Report

Posted on by Community Member

Hi All,

I am working with integrating sales order along with shipping charges into D365 FO using ODATA.

I have created custom package with new Data Entity for mapping Shipping Charge amount. Below was the error i see while creating sales order through Odata.

Write failed for table row of type 'MySalesOrderHeaderChargeEntity'. Infolog: Warning: Matching record for the read only data source 'SalesTable' does not exist.","type":"Microsoft.Dynamics.Platform.Integration.Services.OData.AxODataWriteException"

but surprisingly the same solution working on another instance which is running on different system..

D365 FO Apllication and platform versions used:

Product version: D365 FO 8.1

Platform Update: 20(7.0.5030.35333)

Can any one help me out to how to trace this and resolve.

Categories:

Development / Customization / SDK

Data Integration

All responses (8)

Answers (1)

Community Member on at

Like (1)

Report

RE: D365 Integration With Odata : Data Entity Write Failed

Thanks Daniel.

Changing default legal entity in user preference settings actually resolved issue.
Community Member on at

Like (0)

Report

RE: D365 Integration With Odata : Data Entity Write Failed

i am using specific legal Entity and same reading using my application configuration. which is same on both instance "USMF"
Verified answer

Daniel Weichsel 1,657 on at

Like (1)

Report

RE: D365 Integration With Odata : Data Entity Write Failed

"just curious and want to know why it was not working on my new instance."

Are you relying on the user default legal entity in your OData requests, and is it different in the new instance?
Community Member on at

Like (0)

Report

RE: D365 Integration With Odata : Data Entity Write Failed

i am using SalesOrderHeaderChargeEntity standard data entity for applying freight charges for the sales order thorugh Odata
Community Member on at

Like (0)

Report

RE: D365 Integration With Odata : Data Entity Write Failed

i was trying to add charges to the order along with order creation using OData and order will be created simultaneously.

Yes,the order will be created by OData integration first and then charges will be applied. the same working fine on other environment.

just curious and want to know why it was not working on my new instance.
Martin Dráb 232,938 Most Valuable Professional on at

Like (0)

Report

RE: D365 Integration With Odata : Data Entity Write Failed

It says that you're trying to add charges to a non-existing sales order.

If you assume that the order exists, your assumption seems to be wrong. It works in the other environment because such an order already exist there.

If the order was supposed to be created before importing charges, it sounds like your actual problem is in the order creation.
Community Member on at

Like (0)

Report

RE: D365 Integration With Odata : Data Entity Write Failed

Hi Rahul,

Thanks for the quick response.

i tried restarting DIXF service but still same error. and PU is same on both instance

what access do i need to verify ? what do you mean by build/deployment same . Can you please elaborate more as i am new to D365 FO Development.

i also tried performing full build of my model but no luck.
Suggested answer

Community Member on at

Like (0)

Report

RE: D365 Integration With Odata : Data Entity Write Failed

as it works in other instance, check to see on access, build/deployment is same, PU is same

Restart DIXF services and try and suggest