You cannot view status messages in the SMS Administrator console (884123)


The information in this article applies to:

  • Microsoft Systems Management Server 2.0
  • Microsoft Systems Management Server 2003

SYMPTOMS

Status Summarizers in the Microsoft Systems Management Server (SMS) Administrator console indicate that there are status messages to view. However, when you right-click a Status Summarizer, point to Show Messages, and then click All, the SMS Administrator console does not display status messages.

The drive letter:\Sms\Inboxes\Statmgr.box\Retry folder contains one or more Microsoft SQL Server query files (.sql).

The Statmgr.log file contains entries that are similar to one of the following two examples.

Statmgr.log example 1

$$<SMS_STATUS_MANAGER><date time time zone><thread=2264 (0x8D8)> SQL Err #10007> General SQL Server error: Check messages from the SQL Server.
$$<SMS_STATUS_MANAGER><date time time zone><thread=2264 (0x8D8)> SQL Msg #170> Line 1: Incorrect syntax near 'text'.
$$<SMS_STATUS_MANAGER><date time time zone><thread=2264 (0x8D8)> SQL Msg #105> Unclosed quotation mark before the character string ',1212,2836,768,180 '.
$$<SMS_STATUS_MANAGER><date time time zone><thread=2264 (0x8D8)> ERROR: Could not add a SQL command to the transaction. Most likely, there is a problem with the SQL server or our connection to it. The transaction will be rolled back.
$$<SMS_STATUS_MANAGER><date time time zone><thread=2264 (0x8D8)> WARNING: SMS_STATUS_MANAGER could not insert 51 status messages, 126 insertion strings, and 47 attribute ID/value pairs into the database at this time but retry them in 600000 milliseconds.

Statmgr.log example 2

Retrying a 434-byte SQL transaction to insert 2 status messages and their 2 insertion strings and 0 attribute ID/value pairs into the database.
SMS_STATUS_MANAGER date time (0x04C0) Obtained SQL connection (SPID = 88) from the SQL connection cache.
SMS_STATUS_MANAGER date time 1216 (0x04C0) *** exec sp_InsStatusMessageInsStr 2,522072,0,'LDAP://OU=organizational unit,DC=domain context,DC=domain context,DC=domain context',522072,1,'The RPC server is too busy to complete this operation.

The Dataldr.log file contains entries that are similar to the following:

$$<SMS_INVENTORY_DATA_LOADER><date time time zone><thread=3156 (0xC54)> SQL>>>>> Line 1: Incorrect syntax near 'text'. $$<SMS_INVENTORY_DATA_LOADER><date time time zone><thread=3156 (0xC54)> SQL>>>>> Unclosed quotation mark before the character string ' '.
$$<SMS_INVENTORY_DATA_LOADER><date time time zone><thread=3156 (0xC54)> SQL>>>>> General SQL Server error: Check messages from the SQL Server.

CAUSE

This issue may occur because of a damaged .sql file in the drive letter:\Sms\Inboxes\Statmgr.box\Retry folder.

RESOLUTION

To resolve this issue, delete the damaged .sql file from the drive letter:\Sms\Inboxes\Statmgr.box\Retry folder. To do this, follow these steps:
  1. Stop the SMS Executive service on the site server. To do this, follow these steps:
    1. Click Start, point to Settings, and then click Control Panel.
    2. Double-click Administrative Tools, and then double-click Services.
    3. Right-click the SMS_EXECUTIVE service, and then click Stop.
  2. Identify the damaged .sql file that is causing the issue. To do this, follow these steps:
    1. Start Windows Explorer, locate and then click the drive letter:\Sms\Inboxes\Statmgr.box\Retry folder.
    2. In Windows Explorer, click Details on the View menu.
    3. In the list of files that are displayed, locate the oldest .sql file.
  3. Right-click the oldest .sql file, and then click Delete.
  4. Restart the SMS_EXECUTIVE service.
Note It may take some time for status messages to appear in the SMS Administrator console if there is a backlog of .sql files to process.

Important There may be more than one damaged .sql file in the drive letter:\Sms\Inboxes\Statmgr.box\Retry folder. If you cannot view status messages in the SMS Administrator console after you follow the steps that are described in this article, you may have to repeat the steps in this article until you can view status messages in the SMS Administrator console. Note that each file contains status messages. Therefore, each file that you delete causes the loss of additional status messages.

MORE INFORMATION

For additional information about a similar issue, click the following article number to view the article in the Microsoft Knowledge Base:

840301 Status message files accumulate in the \SMS\inboxes\statmgr\retry folder on a Systems Management Server 2003 site

Modification Type:MinorLast Reviewed:6/13/2005
Keywords:kbwinservperf kbMgmtServices kbtshoot kbprb KB884123 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.