Table locks are not released as expected in Microsoft Dynamics NAV 4.0 Service Pack 3 with platform update 940718 and in Microsoft Dynamics NAV 5.0 with platform update rollup 943858

Symptoms

Consider the following scenario:
  • User A is using a Microsoft Dynamics NAV client. Then, this user receives an error message. For example, user A receives the following error message:
    Register Time must be No in General Ledger Setup Primary Key=''.
  • User B is using another Microsoft Dynamics NAV client. Then, this user receives the following error message:
    The table_name table cannot be changed because it is locked by another user. Wait until the user is finished and then try again.
In this scenario, the locked transactions will be released only if user A clicks OK in the dialog box that contains the error message that this user received. However, Microsoft Dynamics NAV should automatically release the table locks when user B receives the error message.

This problem occurs in the following versions:
  • Microsoft Dynamics NAV 4.0 Service Pack 3 with platform update 940718. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

    940718 Platform update 940718 for Microsoft Dynamics NAV 4.0 Service Pack 3 is available

  • Microsoft Dynamics NAV 5.0 with platform update rollup 943858. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

    943858 Platform update rollup 943858 is available for Microsoft Dynamics NAV 5.0

Resolution

Hotfix information

A supported hotfix is now available from Microsoft. The hotfix corrects the problem that is described in this article. Apply the hotfix only to systems that are experiencing this specific problem.

To resolve this problem immediately, contact Technical Support for Microsoft Dynamics and related products to obtain the hotfix. You can log on to the Microsoft Dynamics site and create a new support request. To do this, visit the following Microsoft Web site: You can also contact Technical Support for Microsoft Dynamics and related products by telephone at (888) 477-7877.

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Technical Support Professional for Microsoft Dynamics and related products determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.


How to obtain the Microsoft Dynamics NAV hotfix or update files

After you request a Microsoft Dynamics NAV hotfix or an update file from Technical Support for Microsoft Dynamics, a hyperlink will be sent to you in an e-mail.


The e-mail will contain a hyperlink and a password. You can use the hyperlink to download the Microsoft Dynamics NAV hotfix or the update files. When you click the hyperlink, the File Download – Security Warning dialog box opens. Then, you are prompted to run, to save, or to cancel the download.


If you click Run, the files start the download and the extraction process. You must specify a folder for the new files, and then provide the password.


If you click Save, you must specify a path for saving the compressed file. When you open the file that you saved, you are prompted to specify a path for the files. You must then provide the password provided in the e-mail.


If you click Cancel, the download process stops.

How to install a Microsoft Dynamics NAV hotfix or an update file

The Microsoft Dynamics NAV platform hotfixes and updates are made available as single files. To install a Microsoft Dynamics NAV hotfix or an update, you must replace the existing Microsoft Dynamics NAV installation files with the hotfix or with the update files.

If you have the Microsoft Dynamics NAV client installed, you must replace the following files in the Microsoft Dynamics NAV client installation.

Microsoft Dynamics NAV 4.0 Service Pack 3 with platform update 940718

File nameFile versionFile sizeDateTimePlatform
Fin.exe4.0.3.256388,119,41627-Nov-200723:01x86
Finsql.exe4.0.3.256388,168,56827-Nov-200723:01x86
Nas.exe4.0.3.256381,422,45627-Nov-200723:01x86
Nassql.exe4.0.3.256381,467,51227-Nov-200723:01x86

Microsoft Dynamics NAV 5.0 with platform update rollup 943858

File nameFile versionFile sizeDateTimePlatform
Fin.exe5.0.25653.010,781,81619-Dec-200717:51x86
Finsql.exe5.0.25653.010,847,35219-Dec-200717:51x86
Nas.exe5.0.25653.01,860,72819-Dec-200717:51x86
Nassql.exe5.0.25653.01,930,36019-Dec-200717:51x86
To replace the existing Microsoft Dynamics NAV files, follow these steps:
  1. Exit Microsoft Dynamics NAV.
  2. Locate the Microsoft Dynamics NAV client installation directory.

    Note The Microsoft Dynamics NAV client is usually installed in the following directory:
    C:\Program Files\Microsoft Business Solutions-Navision\Client\
  3. Copy the files that you downloaded.
  4. Paste the files that you downloaded into the Microsoft Dynamics NAV client installation directory.
  5. In the Confirm File Replace dialog box, click Yes to overwrite the files in the installation directory.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

More Information

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
Properties

Article ID: 945349 - Last Review: Jan 30, 2017 - Revision: 2

Feedback