For the last few months we've had periodic issues with our NAV 2015 install where some users will experience a "spinning wheel" or "white screen" as the service appears to be slowing down. Sometimes it's all users and sometimes it's just some users. New users logging in will be unable to proceed due to the spinning cursor. No one reports a blocking message.
I can fix it by restarting the service or by switching users to a new NAV service. In the latter case users can log in without a problem and proceed normally even while the old service is still flakey. All indications is a service problem and not a SQL issue. Sometimes we go weeks without and issue; now we've had two in as many days.
The application server and SQL server are fine and not over utilizing any resources. Also after the incident there are no events in the respective server event logs that are unusual or could point to a problem.
Any ideas?
*This post is locked for comments
Thanks for the reply. We looked into network congestion but traffic is fine. Also switching services on the same server clears up the problem. Puzzling. When it happens we only have a minute or two to look for issues as the phone starts ringing to get people back online. We plan for one test each outage. It delays a minute but we get some data.
Hi Michael,
We have been experiencing a similar issue over the past several months. We concluded that it was not NAV 2015 because if we are directly on the server, the issue does not happen. After some investigation by a specialist in network setup, we discovered that we had some bad switches and cabling issues. The two problems caused time outs or extremely slow responses. We are now having the cabling redone, and new switches are going in. While your problem may be quite different, this solution worked for us.
Cheers, Judith
Thank you. We have NAV2015 so I will try it on our development system and see how it works.
Michael,
Try the Application Profiler
www.navisionworld.com/.../application-profilercode-coverage-in.html
In our previous version of Navision (an old one) I had a form from the Session table that monitored reads and writes by users. When we encountered issues like this I could quickly run that form and see which person (and it was usually accounting) was using up a lot of disk reads. I would contact them and asked them what they were doing and it was invariably something like exporting all the G/L entries for last year. I told them to use my export button at the top (which had built in sleep commands) and all was better. I wish there was something like that for this version of NAV.
Michael,
I have seen simlar kind of issue recently and the reason in my case was one user was running a report or exporting the page contents which has many records to excel by using send to excel function, which hang all the users and they see the spinning wheel for a longer time.
Memory doesn't seem to be an issue. I've never seen excessive memory usage during a hang-up and we run scripts each night that optimize our indexes. My solution to the slowdown is to switch the config file from pointing to NAV80 to NAV80_2 and have affected users log out and back in. Then when it happens again I switch back from NAV80_2 to NAV80 service on the same server.
I don't think it's the SQL as if I switch The NAV Application service (on to same server) the users on the new application service are fine but the ones on the old service are still hung.
It is set to "Always".
What is the field value of "Automatic Cost Adjustment" in Inventory Setup?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156