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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

"The data mart reset was unable to be processed because of an active task. Try again later."

(1) ShareShare
ReportReport
Posted on by 44
Dear Team,
 
We are currently experiencing an issue in Microsoft Dynamics 365 Finance and Operations related to Financial Reporting (Management Reporter).
 
Issue Details:
We created a financial report and configured all required row, column, and reporting tree definitions correctly. The report generates successfully; however, the values appear incomplete (not all transactions are reflected). After saving the report, it does not appear under Financial Reports inside Dynamics 365 Finance and Operations.
 
Upon investigation, we found that resetting the Data Mart is a recommended solution.
 
However, when attempting to reset the Data Mart, we receive the following error message: "The data mart reset was unable to be processed because of an active task. Try again later."
 
We have verified the following:
 
- No users are currently generating reports.
- No reports appear to be in progress.
- We have reviewed the Financial reporting status form.
 
Could you please assist us in:
- Identifying the active task that is blocking the Data Mart reset.
- Advising on how to safely clear or terminate the stuck process.
- Confirming whether this issue may indicate Data Mart corruption.
 
Environment details:
Deployment type: [Cloud]
Environment: [Production / UAT]
 
We appreciate your urgent support, as this issue is impacting financial reporting accuracy.
Kind regards,
Categories:
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    303,730 Super User 2026 Season 1 on at
    Hi,
     
    Can you please choose the categories with care? In the body, you mentioned Dynamics 365 Finance and Operations. Categories like Microsoft Dynamics SLMicrosoft Dynamics GP, Microsoft Dynamics Fraud Protection, are confusing. Someone who is e.g. monitoring for GP questions can't answer your question as it is related to one product, not all.
     
    Less is more. I edited the tags to have only Dynamics 365 Finance left.  


    Related to your question, did you try the reset option only once or did you retry it several times where you get the same error again and again? Do you have the issue on Production, UAT, or all environments?
  • BI-21121017-0 Profile Picture
    44 on at
    Thank you for your clarification regarding the categories. I appreciate the correction — the issue is related specifically to Dynamics 365 Finance, and I will ensure the correct category is selected moving forward.
     
    Regarding your questions:
    We have attempted the Data Mart reset multiple times, and each attempt results in the same error message:
    "The data mart reset was unable to be processed because of an active task. Try again later."
     
    The issue is currently occurring in the following environment(s):
    [Production / UAT]
     
    Please advise if there is a way to identify the specific background task that may still be running or stuck, and how we can safely terminate it.
     
    Kind regards,
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    303,730 Super User 2026 Season 1 on at
    Hi,
     
    The last time, I did you extensive troubleshooting on the processes. was with AX2012. Then there was an option to see the integration tasks and recurrence. It was then identified that a job was continuously failing due to incorrect data in the chart of accounts. 
    I don't know if you can see running tasks with Dynamics 365 Finance, but you can get JIT access to the UAT database and run some queries to see if there is something wrong. 
    Here is a link to my blog post with some SQL statements that can be used to analyse if it is caused by incorrect data. 
    Troubleshooting Management Reporter integration with AX 2012
     
    Note that some screenshots are missing. I will link them to the correct images later today.
     
    If this not helping, you can raise an incident for Microsoft Support.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 658

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 468 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 333 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans