The SMS_Discovery_Data_Manager component may contain an error message when you open the SMS 2003 Status Message Viewer (322543)


The information in this article applies to:

  • Microsoft Systems Management Server 2003
This article was previously published under Q322543

SYMPTOMS

When you open the Systems Management Server (SMS) 2003 Status Message Viewer to view the Component Status for your SMS 2003 site, the SMS_Discovery_Data_Manager component may contain an error message that is similar to the following:
Status message 2600
component: SMS_discovery_data_manager
process id: 43
Thread ID: 280

SMS Discovery Data Manager failed to synchronize this site's deletions with all secondary site databases. When discovery data is deleted, the deletion must be propagated to all secondary sites. In addition, any licenses associated with the deleted resources must be revoked. Because secondary site data is not synchronized, more licenses will be used than is necessary.

Possible cause:
SQL Server problem on this site or one or more secondary sites.

Solution:
1. Review the immediately preceding status messages from this component about SQL Server errors.
2. Verify that this computer can reach the SQL Server computer.
3. Verify that SQL Server services are running.
4. Verify that SMS can access the SMS site database.
5. Verify that the SMS site database, transaction log, and tempdb are not full.
6. Verify that there are at least 50 SQL Server user connections, plus 5 for each SMS Administrator console.

If the problem persists, check the SQL Server error logs.

CAUSE

This behavior occurs when the SMS Discovery Data Manager cannot communicate with the SMS 2003 primary site database on the Microsoft SQL Server computer.

MORE INFORMATION

Some information in the error message is not correct. The SMS Secondary Site server can host the software metering database. However, the term "secondary site" that is mentioned in the error message refers to the primary site database. You do not install an additional site database when you install a SMS 2003 Secondary Site server.

To view the SMS 2003 Component Status messages, follow these steps:
  1. Click Start, point to Programs, point to Systems Management Server, and then click SMS Administrator Console.
  2. In the SMS Administrator console tree, expand Site Database, and then expand System Status.
  3. Click Status Message Queries, and then right-click All Status Messages in the details pane.
  4. On the menu bar of the SMS Administrator console tree, click Action, and then click Show Messages.
  5. In the All Status Messages dialog box, specify the date and the time, and then click OK.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Modification Type:MinorLast Reviewed:6/13/2005
Keywords:kbnofix kbBug KB322543 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.