Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Microsoft Employee

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

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Multiple NAVISION Application Servers stopping randomly

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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Multiple NAVISION Application Servers stopping randomly

    Hi Tharanga,

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

    Thanks and regards!

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Multiple NAVISION Application Servers stopping randomly

    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?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Multiple NAVISION Application Servers stopping randomly

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Multiple NAVISION Application Servers stopping randomly

    Hi Tharanga,

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

    Thanks,

    JM

  • Verified answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Multiple NAVISION Application Servers stopping randomly

    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 Microsoft Employee on at
    RE: Multiple NAVISION Application Servers stopping randomly

    Hi Manish,

    This is on a physical server

    Regards,

    JM

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Multiple NAVISION Application Servers stopping randomly

    Is this on cloud or a physical 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans