Skip to main content

Notifications

Announcements

Share Your Journey with Power Pages and Help Shape Its Future!
News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Failure to Copy Produc...
Business Central forum
Suggested answer

Failure to Copy Production Environment to Sandbox in Dynamics 365 BC

(1) ShareShare
ReportReport
Posted on by MT-17061426-0 9
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
Categories:
Administration and permissions
  • SC-25061358-0 Profile Picture
    SC-25061358-0 4 on at
    Failure to Copy Production Environment to Sandbox in Dynamics 365 BC
    Hi Folks,
     
    We are also facing the issue as not able to copy the production environment into sandbox:
     
    We have followed all the response : 
    Cancelled all sessions
    Restarted environment
    Checked Document exchanged setup - there is nothing enabled
     
    At last we have generated the ticket to Microsoft.
     
  • Suggested answer
    RL-22060930-0 Profile Picture
    RL-22060930-0 4 on at
    Failure to Copy Production Environment to Sandbox in Dynamics 365 BC
    We had the same issue with one of our customers. We solved it by doing the following
    1. Go to the Integration Synchronization Jobs
    2. Delete all entries older than 7 days
    3. Repeat step 1 + 2 for every company in the environment
    After doing so we managed to copy the production environment
     
    Even though this worked we still address this as a Microsoft issue and they need to come op with a long term solution
  • JO-21061456-0 Profile Picture
    JO-21061456-0 4 on at
    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 69,202 Super User 2024 Season 2 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 17,959 Super User 2024 Season 2 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 9 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 5 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 69,202 Super User 2024 Season 2 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

News and Announcements

Share Your Journey with Power Pages and Help Shape Its Future!

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

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,451 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,353 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans