web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Manish Sharma blog / Objects locked into databa...

Objects locked into database when upgrading to Dynamics NAV 2016

ManishS Profile Picture ManishS 86

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)

USE [NAVDatabase]
UPDATE [Object] SET [Locked] = 0, [Locked By] = '';

Now again try to upgrade the database. 

Comments

*This post is locked for comments