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

Article ID: 866350 - View products that this article applies to.
Expand all | Collapse all

On This Page

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.

Cause

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

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.

Properties

Article ID: 866350 - Last Review: July 13, 2012 - Revision: 4.0
Applies to
  • Microsoft Dynamics GP 10.0
  • System Manager
Keywords: 
kbsurveynew kbexpertisebeginner kbtshoot kbprb kbexpertiseinter kbmbsmigrate KB866350

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com