Table locking issue - while doing Migration

Business Central/NAV Developers Forum
1

Dear Everyone,

We are doing data migration from version 2009 R2 to 2013.

After step 1 now we are trying to do the database conversion i.e opening the 2009 database in 2013 .

I got the following error.

Microsoft Dynamics NAV Development Environment

The G/L Entry table cannot be changed because it is locked by another user.

Wait until the user is finished and then try again.

OK

Single user mode is already enabled before starting the process.

Our database size is almost 300 GB. (Server RAM is 16 GB)

I have done through few sites, for these kind of issues, people are suggesting for more RAM & space. Ideally how much RAM & space is suggested for this big Database . Any other setup to be done in SQL ? (like shrinking of log file etc etc ??)

Please suggest what has to be checked in SQL server & what needs to be done before we again start the process.

2

hi,

the upgrade instructions:
http://msdn.microsoft.com/en-us/library/hh169484(v=nav.71).aspx

also follow:
http://www.dynamicsblog.at/index.php/2012/09/06/nav2013-how-to-convert-a-nav-2009-databa-2013

regards

3

Can anyone Please help us out on this table locking issue ??? Its a big worry in Data Migration for us

4

I’m running into the exact same issue with a test upgrade. I posted this on mibuso as well. I found that when I ran sp_who2 in SQL Server Management Studio I found several orphaned Session ID’s that were still connected to the database. I’ve killed these and am rerunning the process. We have a 650 gb database so it’s been taking over a day before it fails. I’ll keep you posted if this works.

5

OK…Thank you so much.

Even I am trying some work around. If I will be successful I will post it .