Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 1 Sep 2023 05:16:38 by 2

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:
  • Viswanath M Profile Picture
    Viswanath M 8 on 04 Oct 2024 at 06:57:22
    Dual write Initial sync error: CDS sales order lines V2 (salesorderdetails) table map
    Do you resolve this. I am also getting same error
  • HHigham96 Profile Picture
    HHigham96 2 on 02 Nov 2023 at 12:13:27
    Re: Dual write Initial sync error: CDS sales order lines V2 (salesorderdetails) table map

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

  • Hedan Profile Picture
    Hedan 2 on 18 Sep 2023 at 08:06:21
    Re: Dual write Initial sync error: CDS sales order lines V2 (salesorderdetails) table map

    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?

  • MarioRing Profile Picture
    MarioRing 541 on 01 Sep 2023 at 16:28:48
    Re: Dual write Initial sync error: CDS sales order lines V2 (salesorderdetails) table map

    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,316

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,290

Leaderboard

Featured topics

Loading complete