Microsoft KB Archive/166506

{| = PRB: Error Occurs when Closing Issue in Anomaly Tracking System =
 * width="100%"|

ID: Q166506

The information in this article applies to:


 * Microsoft Anomaly Tracking System, version 1.0

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.

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
 * }