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

johannbjarka · 2016-02-25

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 · 2016-02-25

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 · 2016-02-25

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 · 2016-02-25

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

mohana_cse06 · 2016-02-25

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 · 2016-02-25

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

Wisa123 · 2016-02-25

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 · 2016-02-25

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

Duikmeester · 2016-02-25

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

johannbjarka · 2016-02-25

Thanks everyone. It's working now.

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

Best Answers

Answers

Categories