Upgrading from 2013 to 2017, Error: Modification not allowed, item record already exists

sjen
sjen Member Posts: 53
in NAV Three Tier
Upgrading from 2013 to 2017

During the data upgrade, I get the following error below. Does anyone know what is the solution to this problem? or how to debug? I looked at the Item records and I don't see a blank record.
SessionId    : 500
CodeunitId   : 104000
FunctionName : UpdateItem
CompanyName  : ABC
StartTime    : 4/22/2020 12:24:52 PM
Duration     :
State        : FailedPendingResume
Error        : The function UpdateItem in the company initialization codeunit 104000 in company ABC has
               failed due to the following error: 'Modification not allowed, item record already exists.'.

Best Answer

Answers

  • SanderDk
    SanderDk Member Posts: 507
    What CU of 2017 are you upgrading to?
    if you are going directly from NAV 213 to 2017 you need to do you upgrade on 2017 CU 15, and then do a CU upgrade to newest version:
    https://docs.microsoft.com/en-us/dynamics-nav/upgrading-to-microsoft-dynamics-nav-2017
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • sjen
    sjen Member Posts: 53
    FlameESD wrote: »
    The Error comes from the table 5718 Nonstock Item. In codeunit 104000 you have one place where "Item Template Code" is assign with validate. I guess this will cause your error. You can comment the check on T5718 or not assign with Validate.

    Just curious how did you know it was the codeunit 104000 ? Thank you It solved my problem!
  • sjen
    sjen Member Posts: 53
    SanderDk wrote: »
    What CU of 2017 are you upgrading to?
    if you are going directly from NAV 213 to 2017 you need to do you upgrade on 2017 CU 15, and then do a CU upgrade to newest version:
    https://docs.microsoft.com/en-us/dynamics-nav/upgrading-to-microsoft-dynamics-nav-2017

    It is 2017cu14. Thank you the problem is solved.

Categories