Unanswered

Dual write Initial sync error: CDS sales order lines V2 (salesorderdetails) table map

(0) Share

Report

Posted on by Dhruv R Thakar

I am facing error while running dual write initial sync for the entity "CDS sales order lines V2", all the dependent entities are running and has been synced successfully.

Record Id: 93172a53-791c-4336-acf3-3784a75bb5f6, ErrorMessage: Reason: Bad Request, Header x-ms-client-request-id c20a6d9e-5d4a-4d7f-bad5-3880c7fce03c, The detail cannot be updated because the parent is not editable.

I really appreciate your support if you can provide any solution for this issue.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

MarioRing 541 Super User 2024 Season 1 on at

Like (0)

Report

Do you have only one error for a single object or is it a bunch of errors? Identify the broken record in the system and analyze it. Is it possible to delete it and then recreate it somehow?

Try to distinguish whether this is a broken record issue or something related to the whole integration.

Stop your DW mappings for orders and order lines and delete them from the target system. Then start the initial sync process again.

Verify if you have the newest version of the Dual Write solution and mappings.

Check if you have any additional custom plugins/workflows/business rules/automations working on your Order and Order Lines.

There are two (old one and new one) approaches for the dual write Quotes/Orders, verify if you correctly set only one of them - partial enablement may cause troubles.

This forum is dedicated to general Power Apps topics, it may be beneficial to you if you publish your post on relevant Supply Chain or Dynamics CE/CRM community here;)

Good luck!

Was this reply helpful? Yes No
Hedan 2 on at

Like (0)

Report
I'm facing the same issue.

The detail cannot be updated because its parent cannot be edited.

This affects roughly 95% of all rows in SalesOrderLines V2. The rows that are actually exported successfully are those that are connected to a Sales Order that still has status "Open order". If the Sales Order has status "Invoiced" then I'm getting the error.

All related dual-write solutions and tables are updated and synced successfully.

Does anyone know how to address this issue? Is there a way to turn of the validation?

Was this reply helpful? Yes No
HHigham96 2 on at

Like (0)

Report

@hdn Hello, did you ever get anywhere with this?

we are facing the same issue with sales order line for any read only SO records.

Was this reply helpful? Yes No
Viswanath M 8 on at

Like (0)

Report

Do you resolve this. I am also getting same error

Was this reply helpful? Yes No