web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Multiple NAVISION Appl...
Microsoft Dynamics NAV (Archived)

Multiple NAVISION Application Servers stopping randomly

(0) ShareShare
ReportReport
Posted on by Community Member

Hi all,

Our company has been using NAV 2013 R2 for more than a year now without any server issues. Recently, we were advised to create additional NAV application servers to distribute the load of users connecting. The new NAV server instances runs on separate window server installations. But upon deployment of the servers, we started encountering errors randomly across the three servers and causes the instances to stop. We isolated the issue and found that the errors randomly occur when 2 or more servers are running simultaneously. 

Our IT already raised this to our provider and they too were unable to troubleshoot the problem. I was hoping that someone here already encountered the error and was able to troubleshoot the issue. The error usually is as follows:

Application: Microsoft.Dynamics.Nav.Server.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideException
at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.CheckAndthrowTrapableErrors(Int32, Microsoft.Dynamics.Nav.Types.Exceptions.NavSqlException) at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.MapException(System.Data.SqlClient.SqlException, Microsoft.Dynamics.Nav.Runtime.NavSqlCommand) at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteFunction[[System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Func`1<boolean>, Microsoft.Dynamics.Nav.Runtime.NavSqlCommand) at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteFunctionWithTrace[[System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Diagnostics.Tracing.EventTask, System.Func`1<boolean>, Microsoft.Dynamics.Nav.Runtime.NavSqlCommand) at Microsoft.Dynamics.Nav.Runtime.NavSqlCommand.ReadNextRow() at Microsoft.Dynamics.Nav.Runtime.CacheSynchronizationStorage+<read>d__4.MoveNext() at Microsoft.Dynamics.Nav.Runtime.CacheSynchronizationController.ReadAndHandleModifiedTables() at Microsoft.Dynamics.Nav.Runtime.CacheSynchronizationController.Synchronize() at Microsoft.Dynamics.Nav.Runtime.CacheSynchronizationController.TimerCallback(System.Object) at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) at System.Threading.TimerQueueTimer.CallCallback() at System.Threading.TimerQueueTimer.Fire() at System.Threading.TimerQueue.FireNextTimers()

Thanks in advance!



*This post is locked for comments

I have the same question (0)
  • ManishS Profile Picture
    ManishS 86 on at

    Is this on cloud or a physical server ?

  • Community Member Profile Picture
    Community Member on at

    Hi Manish,

    This is on a physical server

    Regards,

    JM

  • Verified answer
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,118 on at

    Can you get the SQL queries which ran when the service get stopped? It might show what is the action NAV tried to execute, by that you will be able to identify a pattern.

  • Community Member Profile Picture
    Community Member on at

    Hi Tharanga,

    I will, thanks for the advice. I will let you know at once when I have the results.

    Thanks,

    JM

  • Community Member Profile Picture
    Community Member on at

    Hi Tharanga,

    I ran an SQL trace as you suggested and saw that SQL updates related to NAV Jobs are running but not failing. These jobs were there since we started using nav. It even continued to run after the server instance has stopped.

    0284.Error.jpg

    I was expecting to see at least an error. The second NAV server instance was not doing any transaction at the time the first server instance stopped.

    Thanks,

    JM

  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,118 on at

    Hi,

    Sorry for the long delay on getting back to you. Do you have any more new information on this issue or is it already been resolved?

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi Tharanga,

    unfortunately, the higher ups grew impatient with the resolution so IT opted for a 1 application server setup.

    Thanks and regards!

  • ManishS Profile Picture
    ManishS 86 on at

    Is there any issue if you create a new service on the application server it self rather than on a new server.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans