Microsoft KB Archive/884123

= You cannot view status messages in the SMS Administrator console =

Article ID: 884123

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition
 * 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 :\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
$$<  > SQL Err #10007> General SQL Server error: Check messages from the SQL Server.

$$<  > SQL Msg #170> Line 1: Incorrect syntax near 'text'.

$$<  > SQL Msg #105> Unclosed quotation mark before the character string ',1212,2836,768,180 '.

$$<  > 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.

$$<  > 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  (0x04C0) Obtained SQL connection (SPID = 88) from the SQL connection cache.

SMS_STATUS_MANAGER  1216 (0x04C0) *** exec sp_InsStatusMessageInsStr 2,522072,0,'LDAP://OU= ,DC= ,DC= ,DC= ',522072,1,'The RPC server is too busy to complete this operation.

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

$$<  > SQL>>>>> Line 1: Incorrect syntax near 'text'. $$<  > SQL>>>>> Unclosed quotation mark before the character string ' '.

$$<SMS_INVENTORY_DATA_LOADER><  ><thread=3156 (0xC54)> SQL>>>>> General SQL Server error: Check messages from the SQL Server.

<div class="cause_section">

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

<div class="resolution_section">

RESOLUTION
To resolve this issue, delete the damaged .sql file from the :\Sms\Inboxes\Statmgr.box\Retry folder. To do this, follow these steps: <ol> <li>Stop the SMS Executive service on the site server. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Click Start, point to Settings, and then click Control Panel.</li> <li>Double-click Administrative Tools, and then double-click Services.</li> <li>Right-click the SMS_EXECUTIVE service, and then click Stop.</li></ol> </li> <li>Identify the damaged .sql file that is causing the issue. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Start Windows Explorer, locate and then click the :\Sms\Inboxes\Statmgr.box\Retry folder.</li> <li>In Windows Explorer, click Details on the View menu.</li> <li>In the list of files that are displayed, locate the oldest .sql file.</li></ol> </li> <li>Right-click the oldest .sql file, and then click Delete.</li> <li>Restart the SMS_EXECUTIVE service.</li></ol>

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 :\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.

<div class="moreinformation_section">

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

Additional query words: status SMS_INVENTORY_DATA_LOADER SMS_STATUS_MANAGER summarizer

Keywords: kbwinservperf kbmgmtservices kbtshoot kbprb KB884123

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.