"Change Log Entry table cannot be changed because it is locked by another user" during upgrade
rsaritzky
Member Posts: 469
Hi All,
I'm testing a data upgrade from NAV2009 to NAV2016. I'm in the "Step 2" which involves opening the 2009 database with NAV2013. During the initial upgrade, the process cranks for awhile (our database is pretty large), and then stops with the error:
"The Change Log Entry table cannot be changed because it is locked by another user. Wait until the user is finished and then try again."
I'm certain I am the only user in the database. I've double-checked the "Change Log Setup" records for all 4 companies in the database. In 2 of the companies, the "Change Log Activated" flag is set to No and in the other 2 companies, there is no Change Log Setup record.
Any ideas on how to get past this roadblock?
Thanks
Ron
I'm testing a data upgrade from NAV2009 to NAV2016. I'm in the "Step 2" which involves opening the 2009 database with NAV2013. During the initial upgrade, the process cranks for awhile (our database is pretty large), and then stops with the error:
"The Change Log Entry table cannot be changed because it is locked by another user. Wait until the user is finished and then try again."
I'm certain I am the only user in the database. I've double-checked the "Change Log Setup" records for all 4 companies in the database. In 2 of the companies, the "Change Log Activated" flag is set to No and in the other 2 companies, there is no Change Log Setup record.
Any ideas on how to get past this roadblock?
Thanks
Ron
Ron
0
Best Answer
-
Thanks SWPolo. It turned out to be something simple. When I ran the upgrade step, I accidentally started another NAV2013 session.
RonRon5
Answers
-
Please check if "Change Log Entry" table is not locked in NAV object designer.
Nav Upgrades and DEV outsourcing
Reports transformation to RDLC
List -1h , Complex List -3h, Document -4h (dev hours)
navisionupgrade.com0 -
Thanks SWPolo. It turned out to be something simple. When I ran the upgrade step, I accidentally started another NAV2013 session.
RonRon5
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 328 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
