You experience slow performance when you browse a list in a form in Microsoft Dynamics NAV 4.0

Article ID: 950920 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
Microsoft Business Solutions-Navision 4.0 and Microsoft Navision 4.0 are now part of Microsoft Dynamics NAV 4.0. All references to Microsoft Business Solutions-Navision or to Microsoft Navision 4.0 relate to Microsoft Dynamics NAV.
Expand all | Collapse all

On This Page

Symptoms

When you browse a list in a form in Microsoft Dynamics NAV 4.0, you experience slow performance.

Cause

This problem occurs because Microsoft Dynamics NAV 4.0 generates Microsoft SQL Server queries dynamically when you browse a list in a form. The generated queries depend on how you browse the data in the form.

The queries may contradict each other. Therefore, the SQL Server may scan many records to satisfy the queries, even if the queries do not return any results.

Additionally, the generated queries may contain extreme values. The SQL Server may optimize the queries for the extreme values. The optimized queries are used even if a value is not the extreme value or if the extreme value is in another direction. Therefore, the SQL Server must scan many records to satisfy the queries.

Resolution

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:
https://mbs.microsoft.com/support/newstart.aspx
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 the update files. To do this, follow these steps.

Step 1: Replace the Microsoft Dynamics NAV client installation file

In the Microsoft Dynamics NAV client installation, replace the following files by using the hotfix file or the update file.
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Dbm.dll4.0.3.26410345,09607-Apr-200818:18x86
Fin.exe4.0.3.264108,119,30407-Apr-200818:18x86
Finhlink.exe4.0.3.26410119,82407-Apr-200818:18x86
Finsql.exe4.0.3.264108,172,56007-Apr-200818:18x86
Nc_netb.dll4.0.3.2641078,86407-Apr-200818:18x86
Nc_tcp.dll4.0.3.2641082,96007-Apr-200818:18x86
Nc_tcps.dll4.0.3.2641091,15207-Apr-200818:18x86
Ndbcs.dll4.0.3.264101,094,66407-Apr-200818:18x86
Slave.exe4.0.3.2641095,24007-Apr-200818:18x86
Note The Microsoft Dynamics NAV client is usually installed in the following folder:
C:\Program Files\Microsoft Dynamics NAV\CSIDE Client\
To replace the existing Microsoft Dynamics NAV files, follow these steps:
  1. Close Microsoft Dynamics NAV.
  2. Locate the Microsoft Dynamics NAV client installation folder.
  3. Copy the files that you downloaded.
  4. Paste the files that you downloaded into the Microsoft Dynamics NAV client installation folder.
  5. In the Confirm File Replace dialog box, click Yes to overwrite the files in the installation folder.

Step 2: Replace the Microsoft Dynamics NAV Application Server installation file

In the Microsoft Dynamics NAV Application Server installation, replace the files that are listed in the following table.
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Nas.exe4.0.3.264101,422,34407-Apr-200818:18x86
Nassql.exe4.0.3.264101,471,50407-Apr-200818:18x86
Nc_netb.dll4.0.3.2641078,86407-Apr-200818:18x86
Nc_tcp.dll4.0.3.2641082,96007-Apr-200818:18x86
Nc_tcps.dll4.0.3.2641091,15207-Apr-200818:18x86
Ndbcs.dll4.0.3.264101,094,66407-Apr-200818:18x86
Slave.exe4.0.3.2641095,24007-Apr-200818:18x86
To replace the files, follow these steps.
  1. Stop the Microsoft Dynamics NAV Application Server.
  2. Locate the Microsoft Dynamics NAV Application Server installation folder.

    Note Typically, the Microsoft Dynamics NAV Application Server is installed in the following folder:
    C:\Program Files\Microsoft Dynamics NAV\Application Server\
  3. Copy the files that you downloaded.
  4. Paste the files that you downloaded into the Microsoft Dynamics NAV Application Server installation folder.
  5. Click Yes to overwrite the files in the folder.
  6. Start the Microsoft Dynamics NAV Application Server.

Status

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

More information

For more information, 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
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
935395 Microsoft Dynamics NAV 4.0 stops responding for several seconds or for several minutes when you browse through a form against a Microsoft SQL Server 2005 database

Properties

Article ID: 950920 - Last Review: November 2, 2013 - Revision: 3.0
Applies to
  • Microsoft Dynamics NAV 4.0
Keywords: 
kbnosurvey kbarchive kbmbsmigrate kbmbsdatabaseandplatforms kbqfe KB950920

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com