You may experience several issues when you set a filter in a list form in Microsoft Dynamics NAV

Article ID: 954342 - View products that this article applies to.
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

If you use Microsoft Dynamics NAV 4.0 with Service Pack 3 that has hotfix 950920 installed or if you use Microsoft Dynamics NAV 5.0 with Service Pack 1, you may experience one of the following symptoms.

Symptom 1

You set a filter that contains a wildcard character (*) in a list form that uses certain collations. However, the form does not show any records until you scroll down in the form. For example, if you set a filter that contains a wildcard character in a list form that uses the Slovakian collation, the form does not show any records until you scroll down in the form.

Symptom 2

If you set a field filter that is exactly one character longer than the length of the field in a list form, Microsoft Dynamics NAV stops responding.

Cause

This problem occurs because the hotfix 950920 for Microsoft Dynamics NAV 4.0 and Service Pack 1 for Microsoft Dynamics NAV 5.0 introduce a new way for Microsoft Dynamics NAV forms to run SQL queries. Large parts of the form runtime were changed to optimize it for the SQL Server option.

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 your Microsoft Dynamics partner or Technical Support for Microsoft Dynamics and related products to obtain the hotfix. If you have access to online assisted support 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. To do this, visit the following Microsoft Web site:

PartnersCustomers
https://mbs.microsoft.com/customersource/support/information/SupportInformation/global_support_contacts_eng.htm
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 by using 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 or the update file.
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Dbm.dll5.0.26810.0443,38425-Jun-200822:33x86
Fin.exe5.0.26810.010,757,11225-Jun-200822:33x86
Finhlink.exe5.0.26810.0349,18425-Jun-200822:33x86
Finsql.exe5.0.26810.010,822,65625-Jun-200822:33x86
Nc_netb.dll5.0.26810.0111,61625-Jun-200822:33x86
Nc_tcp.dll5.0.26810.0111,61625-Jun-200822:33x86
Nc_tcps.dll5.0.26810.0156,67225-Jun-200822:33x86
Ndbcs.dll5.0.26810.01,287,16825-Jun-200822:33x86
Slave.exe5.0.26810.0160,76825-Jun-200822:33x86

Note The Microsoft Dynamics NAV client is usually installed in the following directory:
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 directory.
  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.
  6. If the hotfix or the update includes translated versions of the Fin.stx or the Fin.etx file, you must replace the Fin.stx or the Fin.etx files that are installed in the specific language folders of the installation directory.

    To replace the Fin.stx or the Fin.etx files, follow these steps.

    Note The following example references a German installation.
    1. Copy the W1 Fin.stx and the Fin.etx files to the following folder:
      C:\Program Files\Microsoft Dynamics NAV\CSIDE Client
    2. Copy the Fin.stx and the Fin.etx files from the ENU folder to the following folder:
      C:\Program Files\Microsoft Dynamics NAV\CSIDE Client\ENU
    3. Copy the Fin.stx and the Fin.etx files from the DEU folder to the following folder:
      C:\Program Files\Microsoft Dynamics NAV\CSIDE Client\DEU\
      In some cases, the new client executable files convert the database format. You must update all clients. For the Native option, you must also update the server installation.

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

If you are running the Native option, in the Microsoft Dynamics NAV database server installation, replace the following files by using the hotfix or the update file.

Note If you are running the SQL option, skip this step.
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Dbm.dll5.0.26810.0443,38425-Jun-200822:33x86
Nc_netb.dll5.0.26810.0111,61625-Jun-200822:33x86
Nc_tcp.dll5.0.26810.0111,61625-Jun-200822:33x86
Nc_tcps.dll5.0.26810.0156,67225-Jun-200822:33x86
Slave.exe5.0.26810.0160,76825-Jun-200822:33x86

To replace these files, follow these steps:
  1. Locate the Microsoft Dynamics NAV Database Server installation directory.

    Note Typically, the Microsoft Dynamics NAV Database Server is installed in the following directory:
    C:\Program Files\Microsoft Dynamics NAV\Database Server
  2. Stop the Microsoft Dynamics NAV Database Server, if it is running.
  3. Copy the files that you downloaded.
  4. Paste the files that you downloaded to the Microsoft Dynamics NAV server installation directory.
  5. When you are prompted, click Yes to overwrite the files in the installation directory.
  6. Start the Microsoft Dynamics NAV Database Server.

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

In the Microsoft Dynamics NAV Application Server installation, replace the following files.
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Dbm.dll5.0.26810.0443,38425-Jun-200822:33x86
Nas.exe5.0.26810.01,860,60025-Jun-200822:33x86
Nassql.exe5.0.26810.01,930,24025-Jun-200822:33x86
Nc_netb.dll5.0.26810.0111,61625-Jun-200822:33x86
Nc_tcp.dll5.0.26810.0111,61625-Jun-200822:33x86
Nc_tcps.dll5.0.26810.0156,67225-Jun-200822:33x86
Slave.exe5.0.26810.0160,76825-Jun-200822:33x86
To replace the files, follow these steps.
  1. Stop the Microsoft Dynamics NAV Application Server.
  2. Locate the Microsoft Dynamics NAV Application Server installation directory.

    Note Typically, the Microsoft Dynamics NAV Application Server is installed in the following directory:
    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 directory.
  5. Click Yes to overwrite the files in the directory.
  6. Start the Microsoft Dynamics NAV Application Server.
To replace the files, follow these steps.
  1. Locate the Microsoft Dynamics NAV SDK installation directories.

    Note Typically, the Microsoft Dynamics NAV SDK is installed in the following directories:
    C:\Program Files\Microsoft Dynamics NAV\SDK\Cfront
    C:\Program Files\Microsoft Dynamics NAV\SDK\Communication Components
    C:\Program Files\Common Files\Dynamics NAV\Communication Component
  2. Select the SDK to update. That is, select either C/Front or Communication Components.
  3. Copy the files that you downloaded.
  4. Paste the files that you downloaded into the appropriate Microsoft Dynamics NAV SDK installation directory.
  5. Click Yes to overwrite the files in the directory.

Step 4: Replace the Microsoft Dynamics NAV ODBC driver installation file

If you have the Microsoft Dynamics NAV ODBC driver installed, replace the following files in the Microsoft Dynamics NAV ODBC driver installation.
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Dbm.dll5.0.26810.0443,38425-Jun-200822:33x86
Nc_netb.dll5.0.26810.0111,61625-Jun-200822:33x86
Nc_tcp.dll5.0.26810.0111,61625-Jun-200822:33x86
Nc_tcps.dll5.0.26810.0156,67225-Jun-200822:33x86
Ndbcs.dll5.0.26810.01,287,16825-Jun-200822:33x86
Slave.exe5.0.26810.0160,76825-Jun-200822:33x86
To replace the files, follow these steps.
  1. Locate the Microsoft Dynamics NAV ODBC driver installation directory.

    Note Typically, the Microsoft Dynamics NAV ODBC driver is installed in the following directory:
    C:\Program Files\Common Files\Dynamics NAV\NODBC
  2. Copy the files that you downloaded.
  3. Paste the files that you downloaded into the Microsoft Dynamics NAV ODBC driver installation directory.
  4. Click Yes to overwrite the files in the directory.

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

Properties

Article ID: 954342 - Last Review: November 7, 2012 - Revision: 3.0
Applies to
  • Microsoft Dynamics NAV 5.0
  • Microsoft Dynamics NAV 4.0
Keywords: 
kbfix kbmbsdatabaseandplatforms kbbug kbmbsmigrate kbhotfixserver kbqfe kbexpertiseadvanced kbexpertiseinter KB954342

Give Feedback

 

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