You receive a SmartList initialization message when you start Microsoft Dynamics GP

Resolution 1

To resolve this problem, verify the Pathname parameter in the Dex.ini file. To do this, follow these steps:

1. Locate the Dex.ini file on the computer. To locate the file, follow the appropriate step:
   
   • If you are using Microsoft Dynamics GP 10.0 or Microsoft Dynamics GP 2010, the Dex.ini is in the Data folder of the installation folder. By default the installation folder is C:\Program Files\Microsoft Dynamics\GP.
   • If you are using Microsoft Dynamics GP 9.0, the Dex.ini is in the installation folder. By default the installation folder is C:\Program Files\Microsoft Dynamics\GP.
2. Open the file in Notepad.
3. Verify that the parameter is as follows:
   Pathname=DYNAMICS/dbo/

Resolution 2

To resolve this problem, verify the Dynamics database records in the SY02100 table. To do this, follow these steps:

1. Run the following statement.

   SELECT * FROM DYNAMICS..SY02100

   Note If you are using Microsoft SQL Server, run the statement in SQL Query Analyzer. To open SQL Query Analyzer, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer. If you are using SQL Server Desktop Engine (MSDE), run the statement in Support Administrator Console. To open Support Administrator Console, click Start, point to
   Programs, point to Microsoft Support Administrator Console, and then click Support Administrator Console. The Support Administrator Console requires a separate installation. If you do not have Support Administrator Console installed, you can install it by using the Microsoft Dynamics GP installation CD.
2. In the results that are returned, make sure that you have at least seven records that contain the following:
   
   • DTAPTHNM=DYNAMICS/dbo/
   • CMPANYID=0

Resolution 3

To resolve this problem, resynchronize the Dynamics.dic file to the account framework. To do this, follow these steps:

1. Locate the Dex.ini file on the computer. To locate the file, follow the appropriate step:
   
   • If you are using Microsoft Dynamics GP 10.0 or Microsoft Dynamics GP 2010, the Dex.ini is in the Data folder of the installation folder. By default the installation folder is C:\Program Files\Microsoft Dynamics\GP.
   • If you are using Microsoft Dynamics GP 9.0, the Dex.ini is in the installation folder. By default the installation folder is C:\Program Files\Microsoft Dynamics\GP.
2. Open the file in Notepad.
3. Change the Synchronize parameter as follows:
   Synchronize=TRUE
4. On the File menu, click
   Save.
5. On the File menu, click
   Exit.
6. To start the synchronization process, start Microsoft Dynamics GP Utilities. To do this, follow the appropriate step:
   
   • • In Microsoft Dynamics GP 2010, click Start, point to All Programs, point to Microsoft Dynamics, point to GP 2010, and then click GP Utilities.
   • • In Microsoft Dynamics GP 10.0, click Start, point to All Programs, point to Microsoft Dynamics, point to GP 10.0, and then click GP Utilities.
   • • In Microsoft Dynamics GP 9.0, click Start, point to All Programs, point to Microsoft Dynamics, point to GP 9.0, and then click GP Utilities.

Resolution 4

To resolve this problem, verify the current ODBC connection, or create a new ODBC connection that uses a new name. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

870416 ODBC setup on Microsoft SQL Server 2000, Microsoft SQL Server 7.0, and Microsoft SQL Server Desktop Engine 2000 (MSDE)

Resolution 5

To resolve this issue, you will need to re-create the auto procedures for SmartList. To do this, follow these steps:

Note You should have valid backups of your GP databases before you proceed.

1. In Microsoft Dynamics GP, open the SQL maintenance window. To do this, follow these steps:
   
   • Click Microsoft Dynamics GP.
   • Point to Maintenance.
   • Click on SQL.
2. With the SQL Maintenance window open, use the following options to populate the SmartList SQL objects:
   
   • Database: DYNAMICS.
   • Product: SmartList.
3. With the SmartList objects populated, select all items listed.
4. With all items selected, check the boxes for the following actions:
   
   • Drop Auto Procedure.
   • Create Auto Procedure.
5. Click Process.