Converting Nav 2015 database to 2016 - gives locked object error even though no objects are locked

johannbjarka

I'm upgrading from Nav 2015 to 2016 and following the guide from MS from here. I followed all the steps and made sure that no objects were locked (by filtering the object designer by Locked = yes). I have now done this multiple times but every time I try to convert the database in the 2016 developer environment I get an error saying:

There are some objects locked in the database. You must unlock these objects before upgrading the database.

Any ideas?

mohana_cse06

Please create a page with table Object and check whether there are any locked tabledata records.
may be its strange but I faces similar issues and few tabledata records are locked.
we have to unlock them by using SQl query

Wisa123

Create a ListPage with sourceTable "Object".. add all the fields and run it. You should see all the Objects
Reason behind this is that Object Designer doesnt show TableData .. only Table

Duikmeester

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

mohana_cse06

Please create a page with table Object and check whether there are any locked tabledata records.
may be its strange but I faces similar issues and few tabledata records are locked.
we have to unlock them by using SQl query

johannbjarka

Thanks for the reply. How exactly can I see if there are locked tabledata records?

Wisa123

Create a ListPage with sourceTable "Object".. add all the fields and run it. You should see all the Objects
Reason behind this is that Object Designer doesnt show TableData .. only Table

johannbjarka

Thanks, I found two locked tabledata records. What kind of SQL query do I need to make to unlock the tabledata?

Duikmeester

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

johannbjarka

Thanks everyone. It's working now.