Active Discussion

Data Upgrade NAV2013 to NAV2018 error

(0) Share

Report

Posted on by Balagopu

Hi Expert,

I am upgrading from NAV2013 to NAV2018, when i am doing Data Upgrade i am getting the below error

The function UpdateGeneralLedgerSetup in the company initialization codeunit 104000 in company Chicago Real Estate has failed due to the following error: 'The server
stopped the session (ID: 61) because of a stop session request.'.

Please help me, how to resolve the issues

*This post is locked for comments

All responses (11)

Sort by

Hannes Holst 5,767 on at

Like
a
(0)

Report
Copy link

Link copied!

Do you get the error every time?

The error is raised normally when your session is stopped on server side. This could be either when the ServiceTier is restarted or your session is stopped manually.
Balagopu on at

Like
a
(0)

Report
Copy link

Link copied!

services is not getting stopped or restarted , i am getting this error while data upgrading through Power shell.
GreatScott001 115 on at

Like
a
(0)

Report
Copy link

Link copied!

Is there anything in the Application Event Log on the NAV Server Service machine related to this? Often when this happens it is some critical error caused by something else.
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Increment SQL command timeout in administration console
Balagopu on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Marco, yes i have given SQL timeout is 24 :00:00 but still i am getting the error.
Rahman Erlebach on at

Like
a
(0)

Report
Copy link

Link copied!

First of all, try the data Upgrade in the DEV Client, use the serial mode and not parallel, and before you start data updgrade, use the debugger, and it should point you directly where the issue is coming.

I hope this helps.

Rahman
Balagopu on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Rahaman, but when debug before start Data upgrade i am getting below error,

can you please help me? working on NAV2013 to NAV2018

---------------------------

Microsoft Dynamics NAV Development Environment

---------------------------

Cannot start the data upgrade process because there are active sessions to the tenant database. You must make sure that there are no active sessions before you continue the upgrade process.

---------------------------

OK

---------------------------
Rahman Erlebach on at

Like
a
(0)

Report
Copy link

Link copied!

sure, before you start make sur the active sessions are all killed you can restart the service, and / Or simply empty the table of the server instance at all:

DELETE FROM [My NAV Database Name].[dbo].[Server Instance]

IT is all about making sure no active sessions are there, sometimes restarting the service is enough.

thanks,

Rahman
ManishS 86 on at

Like
a
(0)

Report
Copy link

Link copied!

Getting this error,

SessionId : 91
CodeunitId : 104000
FunctionName : UpdateJobPlanningLinePlanningDueDate
CompanyName : CRONUS India Ltd.
StartTime : 24-08-2022 14:21:47
Duration :
State : FailedPendingResume
Error : The function UpdateJobPlanningLinePlanningDueDate in the company initialisation codeunit 104000 in
company CRONUS India Ltd. has failed due to the following error: 'Function ID 125 was called. The
object with ID 9998 does not have a member with that ID.'.
ExecutionSourceId : 00000000-0000-0000-0000-000000000000
PostUpgrade : False