
Hi.
In live environments, some of the financial reports often not finish.
- General Ledger Transactions to Fact (Running )
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
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.