Dynamics Community Forum Thread Details

Write Failed For Table When Using OData API Update

Hi D365 Community

I using Odata API to update 2 field data in DataEntity
METHOD : PATCH
URL : https://{baseURL}/data/AbcAssets(dataAreaId='abc',AssetId='100086N9')
Body :

{
  "Name": "Asset_Technical_C100",
  "Weight": 100.0
}

but have error occur below :

{
    "error": {
        "code": "",
        "message": "An error has occurred.",
        "innererror": {
            "message": "Write failed for table row of type 'ABC_ProductAssetEntity'. Infolog: .",
            "type": "Microsoft.Dynamics.Platform.Integration.Services.OData.AxODataWriteException",
            "stacktrace": "   at Microsoft.Dynamics.Platform.Integration.Services.OData.Update.UpdateProcessor.UpdateEntity_Save(ChangeOperationContext context, ChangeInfo changeInfo)\r\n   at Microsoft.Dynamics.Platform.Integration.Services.OData.Update.ChangeInfo.ExecuteActionsInCompanyContext(IEnumerable`1 actionList, ChangeOperationContext operationContext)\r\n   at Microsoft.Dynamics.Platform.Integration.Services.OData.Update.ChangeInfo.TrySave(ChangeOperationContext operationContext)\r\n   at Microsoft.Dynamics.Platform.Integration.Services.OData.Update.UpdateManager.SaveChanges()\r\n   at Microsoft.Dynamics.Platform.Integration.Services.OData.AxODataDelegatingHandler.<SaveChangesAsync>d__2.MoveNext()"
        }
    }
}

This error only occur when update field Name and Weight together.

ABC_ProductAssetEntity is DataEntity with datasource is EcoResReleasedProductV2Entity_extension for update data to InventTable_extension

ABC_ProductAssetEntity => EcoResReleasedProductV2Entity_extension => InventTable

field Name is custom field in InventTable_extension, and field Weight is system field.

if update one by one is OK. but together Name and Weight has error.

I check Event view with detail below

Thank you for reading. I hope to receive your assistance