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

I have the same question (0)

All responses (6)

Answers (1)

Inge M. Bruvik 1,065 Moderator 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?

Was this reply helpful? Yes No
Jerome Cader 62 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

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,065 Moderator 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 ?

Was this reply helpful? Yes No
Jerome Cader 62 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

Was this reply helpful? Yes No
Verified answer

Jerome Cader 62 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.

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No