Unhandled Script exception: Illegal address for field 'ASI_Table_Name_From' in script 'Explorer_Set_

25 April 2003

Issue Description

During the initialization of the tables, the following error message occurs:

Unhandled script exception: Illegal address for field 'ASI_Table_Name_From' in script 'Explorer_Set_SQL_Join_Info'. Script terminated.

EXCEPTION_CLASS_SCRIPT_ADDRESSING
SCRIPT_CMD_LOAD_ATSI8

This error can occur in two different situations:

Scenario #1

SmartList is not installed on the workstation generating the error.

Scenario #2

Smartlist is listed after AnyView in the Dynamics.set file.

Solution

Scenario #1

If Explorer/SmartList is not listed in the Customization Status window, it has not been installed or is not included in the Dynamics.set file. After installing Explorer/Smartlist on the workstation, follow the instructions for Scenario #2.

To verify that Smartlist (or Explorer in versions 5.5 and 6.0) is loaded on the workstation, follow these steps:

  1. From the Great Plains menu bar, select 'Tools > Customize > Customization Status'.
  2. Verifty that Smartlist (or Explorer in versions 5.5 and 6.0) is displayed in the product column, and that the status column shows 'Enabled'.

If Smartlist (or Explorer in versions 5.5 and 6.0) is not listed in the Customization Status window, it is not being loaded using the current Dynamics.set file. If Smartlist (Explorer in versions 5.5 and 6.0) is not loaded, this can indicate that either it has not been installed on the workstation, or that the Dynamics.set file has been modified to remove it. Correct the issue by either installing Smartlist (Explorer in versions 5.5 and 6.0) or adding it back into the Dynamics.set file.

After installing Smartlist (Explorer in versions 5.5 and 6.0) on the workstation, follow the instructions for Scenario #2.

Scenario #2

The Explorer/SmartList must be listed in the Dynamics.set file before the AnyView application.

Here is an example of a Dynamics.set file with the described problem:

6
0
eEnterprise
1655
Custom Report Integration
2377
AnyView
1230
Forms Printer
1493
SmartList
1513
ZipAssist
Windows
:C:eEnt70/Dynamics.dic
:C:eEnt70/Forms.dic
:C:eEnt70/Reports.dic
:C:eEnt70/ASI1655.DIC
:C:eEnt70/ASI1655F.DIC
:C:eEnt70/ASI1655R.DIC
:C:eEnt70/AV2377.DIC
:C:eEnt70/AV2377F.DIC
:C:eEnt70/AV2377R.DIC
:C:eEnt70/FPD1230.DIC
:C:eEnt70/FPD1230F.DIC
:C:eEnt70/FPD1230R.DIC
:C:eEnt70/EXP1493.DIC
:C:eEnt70/EXP1493F.DIC
:C:eEnt70/EXP1493R.DIC
:C:eEnt70/ZIP1513.DIC
:C:eEnt70/ZIP1513F.DIC
:C:eEnt70/ZIP1513R.DIC

You must modify this file so that the Smartlist entries appear before the AnyView entries as follows:

  1. Select the lines:
    2377
    AnyView
  2. From the Menu Bar, select 'Edit' then 'Cut'.
  3. Move the cursor directly beneath the line:
    SmartList
    and select 'Edit' then 'Paste'.
  4. Perform steps 1 and 2 for the lines:
    :C:eEnt70/AV2377.DIC
    :C:eEnt70/AV2377F.DIC
    :C:eEnt70/AV2377R.DIC
  5. Move the cursor directly beneath the line
    :C:eEnt70/EXP1493R.DIC
    and select 'Edit' then 'Paste'.
  6. Select 'File', 'Save As' and name the file 'Dynamics.set'. (Make sure it does not get named Dynamics.set.txt.)
  7. Launch Great Plains and select 'Yes' when prompted to initialize the tables.

If you have followed these steps, but are still getting the error message, please contact Accountable Software's Technical Support Team for further assistance.

Email: Accountable Software Technical Support Team
Telephone: 484-875-0600 ext. 9

Site Map