PRB: Error Occurs when Closing Issue in Anomaly Tracking System

ID: Q166506

The information in this article applies to:

SYMPTOMS

When closing an issue in a new Anomaly Tracking System (ATS) database, the following error occurs:

   File 'onclose.prg' does not exist.

CAUSE

The sample database that ships with ATS includes a sample procedure that executes when the Status of an issue is changed to Closed. This procedure automatically assigns an issue to "Unassigned" whenever an issue is closed. The template database that ATS uses to create new databases is configured to use this stored procedure. However, the procedure file OnClose.fxp is not included in the new database directory.

RESOLUTION

There are two possible methods that can be used to avoid this error:

1. Copy the file "OnClose.fxp" from the ATS\Shardata directory to the

   ATS\Template directory before creating new databases in ATS. This method
   adds the functionality of the OnClose procedure to every new database
   that is created in ATS.

2. Modify a newly created ATS database so that it does not call the OnClose
   procedure. The following steps outline how to do this:

   a. Start ATS and login to the new database as the administrator.

   b. Select Property Options Maintenance from the Tools menu.

   c. Select Status in the Group list and Closed in the Name list.

   d. Click Edit.

   e. Remove OnClose() from the validation procedure text box, and
      click Save.

   f. Close the Property Options Maintenance dialog box.

STATUS

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Behavior

1. Start ATS and create a new database.

2. Run the All Issues query.

3. Click New to enter a new issue into the database.

4. Change the Status property to Closed.

NOTE: The error message occurs.

Additional query words: msats

Keywords          : kbtool FxtoolGeneral msats 
Version           : 1.0
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: April 11, 1997