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:
- Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
- In the Connect to Server dialog box, follow these steps:
- In the Server name box, type the name of the server that hosts the Microsoft Dynamics GP databases.
- In the Authentication list, click SQL Authentication.
- In the Login box, type sa.
- In the Password box, type the password for the sa user, and then click Connect.
- On the File menu, point to New, and then click Query with Current Connection.
- 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: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:
- Click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
- In the Connect to SQL Server dialog box, follow these steps:
- In the SQL Server box, type the name of the server that hosts the Microsoft Dynamics GP databases.
- Click the SQL Server Authentication option.
- In the Logon name box, type sa.
- In the Password box, type the password for the sa user, and then click OK.
- 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: Note The Delete statement will only clear the contents of the table. The table will not be deleted from the Database.