News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) "Hidden" loc...

Microsoft Dynamics NAV (Archived)

"Hidden" locked tables

(0) Share

Report

Report

Posted on by Martinho Costa

775

Hello,

I'm trying to upgrade a 2013r2 database to 2016. After following the regular steps, when I open the database in 2016 development environment for the conversion process it says that i cant convert since I have locked objects.

After force unlock all objects tried again and same message appeared. Checked a second time if all objects were unlocked. Since it was all clear I've created a report outputting all locked objects from the Object system table. Turns out I have 7 locked tables that I need to unlock but I don't know how.

Any tip? Thanks in advance.

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (1)

Martinho Costa 775 on at

Like (0)

Report

RE: "Hidden" locked tables

tried to clear the field "locked" from the report but have no permissions to do that on a system table.

Gonna try from TSQL then.
Verified answer

Mohana Yadav 59,139 Super User 2024 Season 2 on at

Like (0)

Report

RE: "Hidden" locked tables

I faces similar issue and i solved it in one of the below ways.

1. processing only report

2. from SQL query

I didn't remember exactly but one of the above ways should solve.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans