DOCUMENT:Q298455 25-JUL-2002 [sms] TITLE :SMS: Collection Evaluator Can't Update Collections on Child Site PRODUCT :Microsoft Systems Management Server PROD/VER::2.0 OPER/SYS: KEYWORDS:kberrmsg kbDatabase kbsms200 kbCollections ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Systems Management Server version 2.0 ------------------------------------------------------------------------------- SYMPTOMS ======== 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")) $$ CStatusReporter::Report() ERROR: Caller passed NULL for pSM. Could not refresh collection DET00028. Will retry later. CAUSE ===== 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. WORKAROUND ========== 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. MORE INFORMATION ================ 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 Systems Management Server 2.0 Resource Guide. Additional query words: prodsms ====================================================================== Keywords : kberrmsg kbDatabase kbsms200 kbCollections Technology : kbSMSSearch kbSMS200 Version : :2.0 Issue type : kbprb ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 2002.