"Change Log Entry table cannot be changed because it is locked by another user" during upgrade

rsaritzky

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

rsaritzky

Thanks SWPolo. It turned out to be something simple. When I ran the upgrade step, I accidentally started another NAV2013 session.

Ron

swpolo

Please check if "Change Log Entry" table is not locked in NAV object designer.

rsaritzky

Thanks SWPolo. It turned out to be something simple. When I ran the upgrade step, I accidentally started another NAV2013 session.

Ron