data upgrade error in nav2017

Hi,

Following error comes on doing Tools–Data upgrade in nav 2017. Any help is highly appreciated.

Server instance: DemoNAV2017
Category: Workflow
ClientSessionId: {00000000-0000-0000-0000-000000000000}
ClientActivityId: {00000000-0000-0000-0000-000000000000}
ServerSessionUniqueId: {00000000-0000-0000-0000-000000000000}
ServerActivityId: {00000000-0000-0000-0000-000000000000}
EventTime: ‎2017‎-‎10‎-‎21T06:11:43.342324600Z
Message (NavSessionTerminatedException): The server stopped the session (ID: 3309) because of a stop session request.
ExceptionStackTrace:
at Microsoft.Dynamics.Nav.Runtime.NavApplicationMethod.InvokeMethod(ITreeObject obj, String methodName, Object[] args)
at Microsoft.Dynamics.Nav.Runtime.NavCodeunit.Invoke(Int32 objectId, String methodName, Object[] args)
at Microsoft.Dynamics.Nav.Runtime.NavUpgradeCodeunit.InvokeCodeunitMethod(String methodName, String companyName, Object[] args)
at Microsoft.Dynamics.Nav.Runtime.NavExecuteUpgradeCodeunitMethodActivity.RunUpgradeMethod(NavSession navSession)
at Microsoft.Dynamics.Nav.Runtime.NavWorkflowTenantSessionManager.Microsoft.Dynamics.Nav.Runtime.INavWorkflowTenantSessionManager.RunActionInSystemSession(Action1 action) CallerStackTrace: at Microsoft.Dynamics.Nav.Runtime.NavWorkflowTenantSessionManager.Microsoft.Dynamics.Nav.Runtime.INavWorkflowTenantSessionManager.RunActionInSystemSession(Action1 action)
at Microsoft.Dynamics.Nav.Runtime.NavExecuteUpgradeCodeunitMethodActivity.ExecuteAsync()
at Microsoft.Dynamics.Nav.Runtime.NavTaskFactory.<>c__DisplayClass10_0.b__0(Object _)
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()


ProcessId: 3796
Tag: 00000E6
ThreadId: 81

Hi Manjusree,
Exactly when does this happen?
It’s looks like something regarding workflows. Are you upgrading from NAV 2016?

Hello,

Thanks for your reply.

Upgrading from NAV2009 R2 to NAV 2017. I have converted NAV 2013 database to NAV 2017, imported base+modified code, compiled all the objects and did Sync. Schema For All Tables. All objects are compiled and Sync. also does not show any issue. But getting error when I do Tools–Data Upgrade when it comes around 50-55%. I have set SQL timeout to 23 hrs, but still getting into this problem.

The reason is most likely some data going wrong somehow. You do not have any workflows you are upgrading?
And are you using the latest build of NAV 2017?