Good Morning,
When I click general ledger > General Journal it takes almost 10 minute before the general journal actually opens. What can cause this delay? Unfortunately we do not have access to an AX expert currently to help us with this issue.
AOS - Windows Server 2012 CPU - 8 Memory 16GB
SQL - Windows Server 2012 CPU - 8 Memory 32GB
I ended up speaking with our SQL guy and he found that one of the maintenance tasks had been failing for a couple of weeks. As soon as he successfully completed the task I was able to open ledger journal. Thank you everyone.
Hi tuffy,
Is only a specific journal open slowly or all of them?
Best regards,
Ludwig
Hi tuffy,
And I guess it happens for any kind of journal in the system? I would still recommend you try to update statistics\rebuild indexes (or at least to check fragmentation) for LedgerJournalTrans. Do you have someone who has experience in MSSQL to check if there are long queries or something weird is going on? It can be done pretty easily with Activity monitor tool.
Gunjan,
Everyone is experiencing this same issue.
Hi tuffy,
Is everyone facing this issue or is it happening for one user only?
Sergei,
It was working normally until yesterday. We have not introduced any changes recently.
We do perform DB maintenance regularly including statistics updates and index rebuilds.
Hi tuffy,
Did it work normally before? Have you brought any changes in this area recently to the environment?
Do you have any DB maintenance tasks (statistics update, index rebuild)?
#1
André Arnaud de Cal...
293,043
Super User 2025 Season 1
#2
Martin Dráb
231,864
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
