Objects locked into database when upgrading to Dynamics NAV 2016
Views (1523)
Error there are some objects locked in the database when upgrading to Dynamics NAV 2016.
When you try to upgrade database other than Dynamics NAV 2016 to NAV 2016, you some time get below error.
—————————
Microsoft Dynamics NAV Development Environment
—————————
There are some objects locked in the database. You must unlock these objects before upgrading the database.
—————————
OK
—————————

Solution:
Open SQL Management and execute the following SQL Query,
Note :- USE your database name (replace NAVDatabase)
—————————
Microsoft Dynamics NAV Development Environment
—————————
There are some objects locked in the database. You must unlock these objects before upgrading the database.
—————————
OK
—————————

Solution:
Open SQL Management and execute the following SQL Query,
Note :- USE your database name (replace NAVDatabase)
USE [NAVDatabase]
UPDATE [Object] SET [Locked] = 0, [Locked By] = '';
Now again try to upgrade the database.
Now again try to upgrade the database.
*This post is locked for comments