Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

You cannot stop the current process in the Process Monitor in Microsoft Dynamics GP 10.0


Symptoms

When you run the Process Monitor in Microsoft Dynamics GP 10.0, you cannot stop the current process.

Note To start the Process Monitor, click Process Monitor on the Microsoft Dynamics GP menu.

↑ Back to the top


Cause

This problem occurs when a process is stuck in the SY01300 (Process Monitor Information) table.

↑ Back to the top


Resolution

To resolve this problem, clear the Process Monitor Information table in Microsoft SQL Server. To do this, use one of the following methods.

Note Before you use one of the following methods, make sure that all users are logged off from Microsoft Dynamics GP.

Method 1: Use SQL Server Management Studio

If you use Microsoft SQL Server Management Studio, follow these steps:
  1. Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
  2. In the Connect to Server dialog box, follow these steps:
    1. In the Server name box, type the name of the server that hosts the Microsoft Dynamics GP databases.
    2. In the Authentication list, click SQL Authentication.
    3. In the Login box, type sa.
    4. In the Password box, type the password for the sa user, and then click Connect.
  3. On the File menu, point to New, and then click Query with Current Connection.
  4. On the Database menu, select the company for which the Process Monitor is stuck, and then run the following statement to delete all the records from the SY01300 table:
    DELETE SY01300
    Note The Delete statement will only clear the contents of the table. The table will not be deleted from the Database.

Method 2: Use Microsoft SQL Query Analyzer

If you use Microsoft SQL Query Analyzer, follow these steps:
  1. Click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
  2. In the Connect to SQL Server dialog box, follow these steps:
    1. In the SQL Server box, type the name of the server that hosts the Microsoft Dynamics GP databases.
    2. Click the SQL Server Authentication option.
    3. In the Logon name box, type sa.
    4. In the Password box, type the password for the sa user, and then click OK.
  3. Select the company for which the Process Monitor is stuck on the Database menu, and then run the following statement to delete all the records from the SY01300 table:
    DELETE SY01300
    Note The Delete statement will only clear the contents of the table. The table will not be deleted from the Database.

↑ Back to the top


Keywords: kbsurveynew, kbexpertisebeginner, kbtshoot, kbprb, kbexpertiseinter, kbmbspartner, kbmbsmigrate, kb

↑ Back to the top

Article Info
Article ID : 866350
Revision : 1
Created on : 1/7/2017
Published on : 7/13/2012
Exists online : False
Views : 105