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, ...
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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 613

#2
André Arnaud de Calavon Profile Picture

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

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 292 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans