Upgrade NAV 2015 to NAV 2018

(0) Share

Report

Posted on by Community Member

Hello

We are currently updating our NAV 2015 to NAV 2018 (CH).

I am stuck at task 14 (https://docs.microsoft.com/en-us/dynamics-nav/upgrading-the-data) where I have to run the data upgrade

I get the following error:

When I check the suggested Powershell Command, I can see several error messages called:

Error : Function 'UpdateSalesIcons' in the upgrade codeunit '104000' has failed because of the following
error: 'The server stopped the session (ID: 455) because of a stop session request.'.

There are some more errors with this message. One complete session message looks like that:

SessionId : 449
CodeunitId : 104000
FunctionName : CreateJobWebServices
CompanyName : COMPANY
StartTime : 20.04.2018 19:04:26
Duration :
State : FailedPendingResume
Error : The function CreateJobWebServices in the company initialization codeunit 104000 in company
COMPANY has failed due to the following error: 'The server stopped the session
(ID: 449) because of a stop session request.'.
ExecutionSourceId : 00000000-0000-0000-0000-000000000000
PostUpgrade : False

I imported all the modified objects and the Upgrade8001100.FOB file. I already restarted the NAV Instances, but no luck.

Did I miss something?

Thank you very much.

Best regards

Raphael

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (3)

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (1)

Report

how much time it took to get this error?

if I remember correctly then there is a query timeout setting in SQL set to 30min or so. Please increase that and see..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello

I click on Start and then the error appears immediately.

Can I somehow restart the upgrade completely? It seems that the percent counter is directly at ~80% and the Stop and Start seems not to work.

Thank you.

Best regards

Raphael

Was this reply helpful? Yes No
Verified answer

alan.butterfield on at

Like (1)

Report

Use switch -FunctionExecutionMode Serial -Force with Start-NavDataUpgrade

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks, this looks a little bit better, now I see the following error:

The function UpdateItem in the company initialization codeunit 104000 in company COMPANY has failed due to the following error: 'The UPG Item does not exist. Identification fields and values: No.='A10001''.

When I try to sync the schema with validation, I can see the same error with the state: OperationalWithDataUpgradeFailure.

Any idea?

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Seems to be a problem of the sync with force.. I did that before, as I got some failures while doing it with validation.

It seems that I have to do the steps in a new database again.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello again

I've done the sync with validation and now I get the following message while upgrading:

SessionId : 1231

CodeunitId : 104000

FunctionName : UpdateItem

CompanyName : COMPANY

StartTime : 20.04.2018 22:47:19

Duration :

State : FailedPendingResume

Error : The function UpdateItem in the company initialization codeunit 104000 in company COMPANY has

failed due to the following error: 'Unable to upgrade Item Category because of Code duplication.

Please make sure that this Item Category has a unique Code, and retry the upgrade.'.

ExecutionSourceId : 00000000-0000-0000-0000-000000000000

PostUpgrade : False

What does that mean? There is just one line in the database.

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hey,

how many company there are in db? Is Item category table common for all companies?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello

There are 6 companies in the db. The item category table is empty for 5 companies, but in the failing company, there is the following line:

timestamp Code Parent Category Description Indentation Presentation Order Has Children Last Modified Date Time Id

0x0000000001CD5076 0 0 0 1753-01-01 00:00:00.000 00000000-0000-0000-0000-000000000000

The columns are the same for every company.

May I just delete this item category?

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

Seems a non standard table... If you have only that record and isn't used in item table (Table 27 - item category field is related to this table), delete the record and restart upgrade

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Alright, I will check that, thank you.

(I made another mistake, so I'll start over)

Was this reply helpful? Yes No