Error during NAVDataUpgrade from BC Cronus v14 to v19 on premises - Table 405 Change Log Entry is not in the list of allowed tables

(0) Share

Report

Posted on by Jerome Cader

Trying a basic upgrade test from BC Cronus v14 CU18 to BC v19.4 on premise,

using the following guide https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-unmodified-application-v14-v19#task-2-upgrade-permission-sets

On Task 10: Upgrade data

Start-NAVDataUpgrade -ServerInstance BC19CronusAllObj -Tenant default -FunctionExecutionMode Serial -SkipAppVersionCheck

The progress is stuck and the error showed is the following:

State : OperationalWithDataUpgradeFailure
DetailedState : Table 405 Change Log Entry is not in the list of allowed tables.

Can you help please?

Thanks,

Jerome

All responses (6)

Answers (1)

Mannavmej 5 on at

Like (0)

Report

RE: Error during NAVDataUpgrade from BC Cronus v14 to v19 on premises - Table 405 Change Log Entry is not in the list of allowed tables

Hello good,

I have the same problem, but I can't move forward. Can you explain in more detail how you solved it? Thank you very much
Verified answer

Jerome Cader 60 on at

Like (1)

Report

RE: Error during NAVDataUpgrade from BC Cronus v14 to v19 on premises - Table 405 Change Log Entry is not in the list of allowed tables

Issue resolved after recreating BC Instance.
Jerome Cader 60 on at

Like (0)

Report

RE: Error during NAVDataUpgrade from BC Cronus v14 to v19 on premises - Table 405 Change Log Entry is not in the list of allowed tables

The Change Log Setup table is empty so it's not enabled.

I'll try to enable and disable the change log on my next run, not sure if that would help

I was trying to figure out where the upgrade process is taking this list of allowed tables, if there is a setting somewhere, but couldn't find anything
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: Error during NAVDataUpgrade from BC Cronus v14 to v19 on premises - Table 405 Change Log Entry is not in the list of allowed tables

Maybe you should try to disable the change log while you do the upgrade ?
Jerome Cader 60 on at

Like (0)

Report

RE: Error during NAVDataUpgrade from BC Cronus v14 to v19 on premises - Table 405 Change Log Entry is not in the list of allowed tables

yes I'm db owner and super user

It worked for other tables but stopped at this one weird
Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: Error during NAVDataUpgrade from BC Cronus v14 to v19 on premises - Table 405 Change Log Entry is not in the list of allowed tables

Are you a super user in NAV and the dbowner of the database?