Windows-based computers are not displayed in the Network Topology diagram view in System Center Essentials 2007, and WSUS component parts fail on the Essentials 2007 agents after you deploy the agents

You may encounter one or more of the following symptoms when you use Microsoft System Center Essentials 2007 (Essentials 2007).

Symptom 1

After you use Essentials 2007 to discover network devices, the Network Topology diagram view in the Monitoring space is populated with subnet groups that contain network devices. However, Windows-based computers are not displayed in this view.

Symptom 2

After the problem that is described in the "Symptom 1" section occurs, all Windows Server Update Service (WSUS) component parts of Essentials 2007 fail on the Essentials 2007 agent. This failure occurs because the Essentials 2007 agent is not added to a security group successfully. Additionally, events that resemble the following may be logged in the Application event log when you deploy the Essentials 2007 agents:

Event Type: Warning
Event Source: DataAccessLayer
Event Category: None
Event ID: 33333
Date: <date>
Time: <time>
User: N/A
Computer: <computer name>
Description:
Data Access Layer rejected retry on SqlError:
Request: p_RelationshipDiscovered -- (RelationshipId=fbc6f59f-b1a1-28ae-fbaa-58598de4694b), (SourceEntityId=e5eb5c80-2f74-6de8-88f1-7333a7421470), (TargetEntityId=108a8f91-3c89-2801-ccf3-195014029154), (RelationshipTypeId=cc8d2f4e-b544-1ef9-8fe1-a0e2994e0f4d), (DiscoverySourceId=597ac233-d39b-89ec-ce11-923e63996a32), (HealthServiceEntityId=38d61898-ff76-6306-60b6-3639b21bb933), (PerformHealthServiceCheck=True), (TimeGenerated=3/14/2007 3:52:39 AM), (RETURN_VALUE=1)
Class: 16
Number: 777980002
Message: The specified relationship doesn't have a valid source.

Event Type: Error
Event Source: Health Service Modules
Event Category: None
Event ID: 10801
Date: <date>
Time: <time>
User: N/A
Computer: <computername>
Description: Discovery data couldn't be inserted to the database. This could have happened because of one of the following reasons:

- Discovery data is stale. The discovery data is generated by an MP recently deleted.
- Database connectivity problems or database running out of space.
- Discovery data received is not valid.

The following details should help to further diagnose:

DiscoveryId: 595ac212-7b9f-cf37-58d0-85478032419c
HealthServiceId: 38d61898-ff76-6306-60b6-3639b21bb933
Invalid relationship source specified in the discovery data item.
RelationshipSourceBaseManagedEntityId: e5eb5c80-2f74-6de8-88f1-7333a7421470
RuleId: 595ac212-7b9f-cf37-58d0-85478032419c
Instance:
<?xml version="1.0" encoding="utf-16"?><RelationshipInstance TypeId="{cc8d2f4e-b544-1ef9-8fe1-a0e2994e0f4d}" SourceTypeId="{1c289ef7-0b90-55a0-e18e-91559abb8f1a}" TargetTypeId="{7b070bc5-0f54-6663-f840-17affa1d6304}"><Settings /><SourceRole><Settings><Setting><Name>{13A2CF1C-0822-A98C-077C-4C2B9622F32B}</Name><Value>10.194.200.0</Value></Setting></Settings></SourceRole><TargetRole><Settings><Setting><Name>{45643F00-F90F-CFF1-B11B-D816D3FEC417}</Name><Value><computer DNS name></Value></Setting></Settings></TargetRole></RelationshipInstance>.

This problem occurs because the Microsoft.mom.databasequerymodules.dll module tries to create a relationship between the IPSubnet and the Windows-based computers. However, the IPSubnet is not available when the Microsoft.mom.databasequerymodules.dll module tries to create a relationship. Therefore, the symptoms that are mentioned in the "Symptoms" section occur.

Hotfix information

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site: Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Prerequisites

Install this hotfix on computers that host a System Center Essentials 2007 Management Server.

Restart requirement

You do not have to restart the computer after you apply this hotfix.

Hotfix replacement information

This hotfix does not replace any other hotfixes.

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

System Center Essentials 2007, x86-based versions

System Center Essentials 2007, x64-based versions

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

After you apply this hotfix, Windows-based computers are correctly populated into subnet groups. Therefore, these computers will appear in the Network Topology diagram view.

How to apply this hotfix

To apply this hotfix, follow these steps:

1. Copy the following file to a local folder or to a network shared folder that can be accessed:
   SCE2007-RTM-KB936339-X86-X64-ENU.MSI
2. Run the file that you copied in step 1 locally on each computer that hosts a System Center Essentials 2007 Management Server.
   
   Notes
   • You can run the SCE2007-RTM-KB936339-X86-X64-ENU.MSI file from Windows Explorer or at a command prompt.
   • After the hotfix is installed, the Essentials 2007 services will restart.

For more information about the standard terminology that is used to describe Microsoft software updates, click the following article number to view the article in the Microsoft Knowledge Base: