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 :
Finance | Project Operations, Human Resources, ...
Unanswered

[on-premise] Financial Report Issue

(0) ShareShare
ReportReport
Posted on by 350

Hi.

In live environments, some of the financial reports often not finish.

- General Ledger Transactions to Fact (Running )

MR-issue.png

1) Is it because the hardware specification of the associated server is low?

No System  Server/VM 
1 ERP - LIVE AOS1
2 ERP - LIVE AOS2
3 ERP - LIVE Orchestrator1
4 ERP - LIVE Orchestrator2
5 ERP - LIVE Financial Report 1 (MR1)
6 ERP - LIVE Financial Report 2 (MR2)
7 ERP - LIVE SSRS Node

2) How do I know what caused the problem?

Do I go into the Financial Report server and look at the Event Viewer?

On the SQL DB server, should I monitor whether the query related to the financial report?

3) Connecting to the Orchestrator server, restarting MR Node will return normally.

However, after a few days, the same thing happens again.

4) Will resetting the data mart solve this problem?

Reset the Financial reporting data mart - Finance & Operations | Dynamics 365 | Microsoft Docs

I have the same question (0)
  • WillWU Profile Picture
    22,363 on at

    Hi dongwoon,

    Is it a specific report or a random report that happens like this?

    What is the size of your hardware. Please check:docs.microsoft.com/.../system-requirements-on-prem

    The first thing you need to do is to check if there are any error messages on Orchestrator. And you could check the Event Viewer on Financial Report server.

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans