web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

Archiving data using Dataverse long-term retention stuck in the 'Pending move to history' state.

(3) ShareShare
ReportReport
Posted on by 21
Hello Everyone,

I'm working on archiving data using Dataverse long-term retention. I've completed all the prerequisites and setup, and I've scheduled the archival job for inventory transactions. However, the job is stuck in the 'Pending move to history' state. Can someone please guide me on how to proceed?
 


I have the same question (0)
  • Suggested answer
    Adis Profile Picture
    6,069 Super User 2025 Season 2 on at
    Hi,
     
    I think I read somewhere that it can take up to 2 weeks until this finishes. I did the same for tax transactions and it worked well within few days.
     
    My questions:
     
    • If this is done in sandbox, did you release anything there? New custom code, new version update? Did you do a database copy from PROD to UAT
    If you can answer the above questions with NO, I would suggest creating a MS Ticket. As far as I know, there isnt much you can do here, like cancelling the job or so.
     

    Kind regards, Adis

     

    If this helped, please mark it as "Verified" for others facing the same issue

    Keep in mind that it is possible to mark more than one answer as verified

  • CU06061003-0 Profile Picture
    21 on at
    Hi @Adis,
     
    Thank You for the reply 
     
    This was a test environment, and aside from a PQU and a standard Microsoft serivce update, the environment did not have any new custom code or database copy.
     
    The process is still running and struck at pending move to history state.Does the standard update also impact the process?
     
     
  • Suggested answer
    Adis Profile Picture
    6,069 Super User 2025 Season 2 on at
    Hi,
     
    If you did updates during this process, then I am pretty sure this is what caused the issue. I would always wait until the process is finished and then do updates, no matter if it is a Microsoft update or you are releasing custom code. 
     
    I would make a database copy from PROD to your test environment and start the process again. I am pretty sure it will run through with no issues.
     

    Kind regards, Adis

     

    If this helped, please mark it as "Verified" for others facing the same issue

    Keep in mind that it is possible to mark more than one answer as verified

  • CU06061003-0 Profile Picture
    21 on at
    Hi @Adis,
     
    Thank You for the response.
     
    What would happen if the same situation happened in production environments and the job was interrupted at one point or another? How do we handle it?
     
    Regarding situations of similar kind Is there documentation on this topic in any of the MS docs or other related documents? Please let me know if there are, it would be very helpful.

    Best regards,
    A seeker in need of assistance
  • Adis Profile Picture
    6,069 Super User 2025 Season 2 on at
    Hi,
     
    If that happens in PROD I would suggest to create a MS ticket so they help you to resolve the issue. In order to avoid such a situation, I would make sure to prevent making updates during the archiving. 
     
    I guess someone will still do it and MS will need to fix it at some point of time, however, I would try to avoid it as of now.
     

    Kind regards, Adis

     

    If this helped, please mark it as "Verified" for others facing the same issue

    Keep in mind that it is possible to mark more than one answer as verified

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Martin Dráb Profile Picture

Martin Dráb 45 Most Valuable Professional

#2
iampranjal Profile Picture

iampranjal 36

#3
Satyam Prakash Profile Picture

Satyam Prakash 31

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans