My application is crashing periodically and when it happens EventViewer reporting below error.
Server instance: SIVVINAS Category: Security ClientSessionId: 00000000-0000-0000-0000-000000000000 ClientActivityId: 00000000-0000-0000-0000-000000000000 ServerSessionUniqueId: 9d36a95f-6d5b-457d-81d5-8579527e29e3 ServerActivityId: 60ec33d7-ffda-4458-939b-7794e0808bc3 EventTime: 05/05/2019 16:00:10 Message <ii>(NavServerSessionRemovedException): <ii>The server stopped the session (ID: 5) because the session is no longer active. ExceptionStackTrace: CallerStackTrace: at Microsoft.Dynamics.Nav.Runtime.NavSession.ValidateSessionIsActive(Boolean forceValidation) at Microsoft.Dynamics.Nav.Runtime.NavSession.ValidateUserHasAccessToCompany(String companyName) at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.GetCompanyNameToken(DataError errorLevel, String companyName, Int32& token) at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.Initialize(String companyName, SecurityFiltering filtering) at Microsoft.Dynamics.Nav.Runtime.NavRecord..ctor(ITreeObject parent, Int32 tableId, NCLMetaTable metaTable, Boolean isTemporary, NavRecord sharedTable, String companyName, SecurityFiltering securityFiltering) at Microsoft.Dynamics.Nav.BusinessApplication.Record337.__Construct(ITreeObject parent, NCLMetaTable metaTable, Boolean isTemporary, NavRecord sharedTable, String companyName, SecurityFiltering securityFiltering) at Microsoft.Dynamics.Nav.Runtime.NCLMetaTable.CreateObjectInstance(ITreeObject parent, Boolean isTemporary, NavRecord sharedTable, String companyName, SecurityFiltering securityFiltering) at Microsoft.Dynamics.Nav.Runtime.NavRecord.ValidateFlowField(NCLMetaField metaField) at Microsoft.Dynamics.Nav.Runtime.NavRecord.ValidateField(Action`1 fieldEvent, NCLMetaField metaField, Boolean isUserInput) at Microsoft.Dynamics.Nav.Runtime.NavRecord.Validate(NCLMetaField metaField, NavValue newValue, NavRecord callerRecord, Boolean isUserInput) at Microsoft.Dynamics.Nav.Runtime.NavRecord.ALValidateSafe(Int32 fieldNo, NavType expectedType, NavRecord callerRecord) at Microsoft.Dynamics.Nav.BusinessApplication.Record37.Quantity_a45_OnValidate_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() at Microsoft.Dynamics.Nav.BusinessApplication.Record37.Quantity_a45_OnValidate() at Microsoft.Dynamics.Nav.Runtime.NavRecord.ValidateField(Action`1 fieldEvent, NCLMetaField metaField, Boolean isUserInput) at Microsoft.Dynamics.Nav.Runtime.NavRecord.Validate(NCLMetaField metaField, NavValue newValue, NavRecord callerRecord, Boolean isUserInput) at Microsoft.Dynamics.Nav.BusinessApplication.Record37.Unit_of_Measure_Code_a45_OnValidate_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() at Microsoft.Dynamics.Nav.BusinessApplication.Record37.Unit_of_Measure_Code_a45_OnValidate() at Microsoft.Dynamics.Nav.Runtime.NavRecord.ValidateField(Action`1 fieldEvent, NCLMetaField metaField, Boolean isUserInput) at Microsoft.Dynamics.Nav.Runtime.NavRecord.Validate(NCLMetaField metaField, NavValue newValue, NavRecord callerRecord, Boolean isUserInput) at Microsoft.Dynamics.Nav.Runtime.NavRecord.ALValidateSafe(Int32 fieldNo, NavType expectedType, NavRecord callerRecord) at Microsoft.Dynamics.Nav.BusinessApplication.Record37.Noa46_a45_OnValidate_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() at Microsoft.Dynamics.Nav.BusinessApplication.Record37.Noa46_a45_OnValidate() at Microsoft.Dynamics.Nav.Runtime.NavRecord.ValidateField(Action`1 fieldEvent, NCLMetaField metaField, Boolean isUserInput) at Microsoft.Dynamics.Nav.Runtime.NavRecord.Validate(NCLMetaField metaField, NavValue newValue, NavRecord callerRecord, Boolean isUserInput) at Microsoft.Dynamics.Nav.Runtime.NavRecord.ALValidateSafe(Int32 fieldNo, NavType expectedType, NavValue newValue, NavRecord callerRecord) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit50024.SplitLines_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit50024.SplitLines(Int32 tableID, Int32 docType, NavCode docNo) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit50024.OnInvoke(Int32 memberId, Object[] args) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit50007.Release_SalesHdr_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit50007.Release_SalesHdr() at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit50007.OnRun_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit50007.OnRun(INavRecordHandle εrec) at Microsoft.Dynamics.Nav.Runtime.NavCodeunit.DoRun(DataError errorLevel, NavRecord record) at Microsoft.Dynamics.Nav.Runtime.NavCodeunit.RunCodeunit(DataError errorLevel, Int32 objectId, NavRecord record) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit99001467.RunScheduleJob_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit99001467.RunScheduleJob(INavRecordHandle scheduleHeader, Boolean createLog) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit99001467.OnInvoke(Int32 memberId, Object[] args) at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit99001469.Schedule_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit99001469.Schedule() at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit99001469.OnRun_Scope.OnRun() at Filter.InvokeWithFilter(NavMethodScope ) at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit99001469.OnRun(INavRecordHandle εrec) at Microsoft.Dynamics.Nav.Runtime.NavCodeunit.DoRun(DataError errorLevel, NavRecord record) at Microsoft.Dynamics.Nav.Runtime.NavCodeunit.InvokeRun(Int32 objectId, Object[] args) at Microsoft.Dynamics.Nav.Runtime.ALSession.RunCodeunitAndDisposeSession(NavSession session, Int32 codeUnitId, NavRecord record) at Microsoft.Dynamics.Nav.Runtime.NavTaskFactory.<>c__DisplayClass1_0.<RunTask>b__0() at System.Threading.Tasks.Task.Execute() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot) at System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution) at System.Threading.ThreadPoolWorkQueue.Dispatch() </ii></ii> ProcessId: 9864 Tag: 000001W ThreadId: 7 CounterInformation:
I don't have any idea whether it is Navison or SQL and how to fix it.
*This post is locked for comments