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

Report
All responses (
Answers (