NAV Application service slowdown

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (14)

Answers (0)

keoma 32,729 on at

Like (1)

Report

could be a license issue (concurrent users).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I don't think so. Some users who are already logged in get a rotating circle and/or white screen in addition to all new users. Is there an error message if one exceeds the licensed number of users. We occasionally got it with our old Navision as users had many sessions open at a time but now they almost all just have one.

Was this reply helpful? Yes No
Suggested answer

Jatin Patel 2,641 on at

Like (0)

Report

Hi Michael,

Check memory usage on NAV Service tier when users are facing problem. It could be some process or report(using Excel Buffer Table) that cause the hanging issue.

Try to rebuild SQL table indexes and statistics again and check.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (1)

Report

In worst case, in might be a database issue - run checkdb in SQL Management Studio and see if any errors appear. Also, it can be a connectivity issue; e.g., your network itself has been overloaded with traffic (e.g., someone downloads a torrent-movie in full bandwidth).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

What is the field value of "Automatic Cost Adjustment" in Inventory Setup?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It is set to "Always".

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

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.

Was this reply helpful? Yes No