Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 298455 - Last Review: March 1, 2007 - Revision: 4.2
SMS: Collection Evaluator Cannot Update Collections on a Child Site
This article was previously published under Q298455
Collections at a central site that are based on a query may not be correctly replicated down to a child primary site if the query criteria does not exist on the child site. In this situation, you may receive the following error messages in the Colleval.log file:
Preparing to refresh collection DET00028
SQL Err #10007> General SQL Server error: Check messages from the SQL Server
SQL Msg #208> Invalid object name 'User_Information_DATA'.
CCollectionSource_SQL::RefreshResults - Err in SQL cmd insert into Temp__RES_COLL_DET00028 (MachineID,ArchitectureKey,Name,SMSID,Domain ,IsClient) select all SMS_R_System.ItemKey, SMS_R_System.DiscArchKey, SMS_R_System.Name0, SMS_R_System.SMS_Unique_Identifier0, SMS_R_System.Resource_Domain_OR_Workgr0, SMS_R_System.Client0 from System_DISC AS SMS_R_System INNER JOIN User_Information_DATA AS __RATION_USERINFORMATION_1_00 ON __RATION_USERINFORMATION_1_00.MachineID = SMS_R_System.ItemKey where UPPER(__RATION_USERINFORMATION_1_00.Department00) in (UPPER("092"),UPPER("091"),UPPER("094")) $$SMS_COLLECTION_EVALUATORTue Apr 10 11:25:21.218 2001 Eastern Standard Timethread=2032 (0x7F0)
CStatusReporter::Report() ERROR: Caller passed NULL for pSM.
Could not refresh collection DET00028. Will retry later.
This behavior occurs if the NOIDMIF file's database class is not defined on the child site. For example, assume the following hierarchy:
Central
/ \
/ \
/ \
Site A Site B
If Site A has implemented a NOIDMIF file, classes are created for both Site A and the Central site. However, classes are not created for Site B, because inventory only moves
up the hierarchy. Therefore, when the Collection Evaluator on Site B tries to evaluate a query based on these classes, the operation fails.
To resolve this issue, put a copy of the NOIDMIF file that has been processed on the parent site in the %windir%\MS\SMS\NOIDMIFS folder on a client in the child site (for example, Site B, as described in the "Cause" section of this article). To force a hardware inventory on the client, open the Systems Management tool in Control Panel, click the
Components tab, click
Hardware Inventory, and then click
Start Component. A hardware inventory cycle starts on the client.
When the standard hardware processing cycle is complete, the NOIDMIF file is appended to the hardware inventory and processed by the SMS Inventory Data Loader on the child site. Classes in the inventory that do not exist in the database are created. Collections can now be correctly evaluated.
When collections are replicated down to a child site, the membership rules are replicated as a portion of the replicated data. If membership depends on a class that does not exist at the child site, you may receive the error messages described in the "Symptoms" section of this article.
For additional information about collection replication to child sites, see chapter 17 of the
Microsoft Systems Management Server 2.0 Resource Guide.
APPLIES TO
- Microsoft Systems Management Server 2003
- Microsoft Systems Management Server 2.0 Standard Edition
| kbcollections kbdatabase kberrmsg kbprb KB298455 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate