Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Failure to Copy Production Environment to Sandbox in Dynamics 365 BC

Posted on by 4
I am writing to seek assistance with an issue we encountered while attempting to copy our production environment to create a sandbox environment in Microsoft Dynamics 365 Business Central. The operation failed with the following error message:
  • Status: Failed
  • Error: We can't save your changes right now, because a record in table 'Doc. Exch. Service Setup' is being updated in a transaction done by another session. You'll have to wait until the other transaction has completed, which may take a while. Please try again later.
  • Operation Details:
    • Operation Type: Copy
    • Copied From Environment: Production_main
    • Copied From Type: Production
    • New Environment Name: Test_us5
    • New Environment Type: Sandbox
    • Country: US

Operation Time:

  • Scheduled on: 17 Jun 2024, 08:53:10 CEST
  • Started on: 17 Jun 2024, 08:53:11 CEST
  • Completed on: 17 Jun 2024, 10:20:29 CEST

I have attempted the following steps to resolve the issue:

  • Waiting for a period of time and retrying the operation.
  • In some of our previous attempts an error with the 'Net Promoter Score' table occurred. 
  • Checking for active sessions and processes that might be accessing the 'Net Promoter Score' and 'Doc. Exch. Service Setup' tables.
  • Scheduling the copy operation during off-peak hours to minimize potential conflicts.

Despite these efforts, the issue persists, and I am unable to successfully create the sandbox environment. The error first time occurred on 05 Jun 2024, 13:13:38 CEST

We have two production environments: one in the US and one in AT country/region. I do not encounter any problems when copying the Production Environment to Sandbox in the AT region.

I would appreciate your assistance in resolving this issue. Could you please provide guidance on the following:

  1. Steps to ensure the completion of any pending transactions affecting the 'Net Promoter Score' or 'Doc. Exch. Service Setup' tables.
  2. Recommendations for preventing this concurrency issue in future copy operations.
  3. Any additional troubleshooting steps or actions that we can take to resolve this problem.
Kr,
Maša
  • Failure to Copy Production Environment to Sandbox in Dynamics 365 BC
    I have the same error 
     
    Error: We can't save your changes right now, because a record in table 'Paramètres service Doc. Exch.' is being updated in a transaction done by another session. You'll have to wait until the other transaction has completed, which may take a while. Please try again later.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 62,477 Moderator on at
    Failure to Copy Production Environment to Sandbox in Dynamics 365 BC
    Agree with Saurav, this is clearly a Microsoft issue. Or you could try raising this issue in the BC Yammer Group first.
    aka.ms/BCYammer: Dynamics 365 Business Central Partner Community (Formerly: Development)
    More details: About Business Central partner community on Viva Engage (formerly Yammer)
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 12,745 User Group Leader on at
    Failure to Copy Production Environment to Sandbox in Dynamics 365 BC
    Hi,
     
    If it still has issue, I suggest creating a ticket with Microsoft.
     
    The only way that we would think of is already discussed which is to restart environment. 
     
    Regards,
    Saurav Dhyani
  • MT-17061426-0 Profile Picture
    MT-17061426-0 4 on at
    Failure to Copy Production Environment to Sandbox in Dynamics 365 BC
    @YUN ZHU Thank you for your prompt response. Yes, I have tried restarting the environment and the issue remains.
    I have also updated the version - still, the same issue (current version: 24.1.18927.19282).
     

     
  • PY-18060728-0 Profile Picture
    PY-18060728-0 3 on at
    Failure to Copy Production Environment to Sandbox in Dynamics 365 BC
    I am getting the same error. As Yun ZHU said i have tried restarting the current environment and then copying it, but the issue still exists.

    Anyone have a solution for this? really appreciating 

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 62,477 Moderator on at
    Failure to Copy Production Environment to Sandbox in Dynamics 365 BC
    Hi, have you tried restarting the current environment and then copying it?
     
    Hope this helps.
    Thanks.
    ZHU

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,860 Moderator

#2
Ludwig Reinhard Profile Picture

Ludwig Reinhard Microsoft Employee

#3
Martin Dráb Profile Picture

Martin Dráb 225,155 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans