Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 922350 - Last Review: November 21, 2010 - Revision: 2.0
Some Systems Management Server 2003 wizards may not work correctly when you include a join statement in an SMS query
Consider the following scenario. You perform a query in the Microsoft Systems Management Server 2003 (SMS) Administrator console. Then, you right-click a client computer in the results pane, and then click Install Client. In this scenario, the Client Push Installation Wizard does not appear. Additionally, other wizards such as Distribute Software and Distribute Software Updates may no longer function.
When you close the SMS Administrator console, you receive an error message that resembles the following:
__CMmfThread1____: mmc.exe - Application Error
The Instruction at "0x153aa959" referenced memory at "0x01695b80".
The memory could not be "read".
Click on OK to Terminate the program
This issue occurs when you change an existing query in SMS 2003 to include an attribute class that causes a join in the query statement, such as the
All Systems query. For example, you edit the All Systems query statement and add an attribute class such as
Workstation Status, and then you add an attribute such as
Last Hardware Scan. In this case, the query statement now includes a join statement. This may prevent the Client Push Installation Wizard and other wizards from appearing.
To resolve this issue, you can create a collection that is based on the query that includes the join statement. Then, you can use the Client Push Installation Wizard on client computers that reside in the new collection.
To do this, follow these steps:
- Click Start, point to All Programs, click Systems Management Server, and then click SMS Administrator Console.
- Expand Site Database(SiteCide-SiteName), and then expand Collections.
- Right-click Collections, point to New, and then click Collection.
- In the Collection Properties dialog box, type a name in the Name box.
- Click the Membership Rules tab, and then click the Query Rule Properties icon.
- In the Query Rule Properties dialog box, type a name in the Name box, and then click Import Query Statement.
- In the Browse Query dialog box, select the query that you want, click OK, and then click OK two more times.
- Right-click the new collection, point to All Tasks, and then click Update Collection Membership.
- When the collection has been updated, right-click the client computer in the results pane, point to All Tasks, and then click Install Client.
For more information on troubleshooting Advanced Client Push Installations see the following article in the Microsoft Knowledge Base:
928282 How to troubleshoot Advanced Client Push Installation Issues in Systems Management Server 2003 and System Center Configuration Manager 2007Â
(http://kbalertz.com/Feedback.aspx?kbNumber=925282/
)
APPLIES TO
- Microsoft Systems Management Server 2003
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