You encounter problems after you apply hotfix 955229 on System Center Configuration Manager 2007 site servers

Article translations Article translations
Article ID: 970170 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

After you apply hotfix 955229 on System Center Configuration Manager 2007 site servers, you encounter one or more of the following problems.

Problem 1

Users cannot enumerate collection members if they have read permissions on a collection instance but no read permissions on the related collection class.

Additionally, the following error is logged in the Smsprov.log file:
CSspQueryForObject::GetColumnName, Unable to find property "XYZ0000D" in class SMS_CM_RES_COLL_XYZ0000D
Execute WQL =<SQL statement>
Execute SQL =<SQL statement>
Results returned: 0 of -1

Problem 2

Under the Operating System Deployment node, the Task Sequence Media Wizard does not list task sequences that require a boot image.

Problem 3

The Component Status window does not reset counters to zero.

RESOLUTION

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.

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, submit a request to 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:
http://support.microsoft.com/contactus/?ws=support
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

To apply this hotfix, you must have System Center Configuration Manager 2007 installed. Apply this hotfix on all System Center Configuration Manager 2007 site servers and on all computers that have the Administrator console installed.

Note You must apply this hotfix to support Microsoft SQL Server 2008 in a System Center Configuration Manager 2007 environment.

Restart requirement

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

Hotfix replacement information

This hotfix replaces hotfix 955229. For more information, click the following article number to view the article in the Microsoft Knowledge Base: For more information, click the following article number to view the article in the Microsoft Knowledge Base:
955229 You experience issues in the original release of System Center Configuration Manager 2007 after you upgrade some site databases to SQL Server 2008

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.
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Adminconsole.xmlNot Applicable2,150,23831-Dec-200721:30Not Applicable
Adminui.tasksequencemediawizard.dll4.0.5931.154259,92831-Dec-200722:25x86
Basesvr.dll4.0.5931.1431,723,41631-Dec-200721:30x86
Sitestat.dll4.0.5931.143128,53631-Dec-200721:30x86
Smsprov.dll4.0.5931.1543,596,13631-Dec-200722:25x86
Smsse.dll4.0.5931.15147,47231-Dec-200723:10x86
Update.sqlNot Applicable32,37931-Dec-200722:25Not Applicable
After you apply this hotfix, follow these steps:
  1. From the updated SMS site server, stop the following services:
    • SMS_SITE_COMPONENT_MANAGER
    • SMS_EXECUTIVE
  2. At the SMS site database server, load <SMS_root>\Logs\<KBID>\Update.sql by using a SQL Server query tool such as Query Analyzer or ISQL/W.
  3. In the SQL Server query tool, select the Systems Management Server database.
  4. Run the script.
  5. Restart the following SMS site server services that you stopped in step 1:
    • SMS_SITE_COMPONENT_MANAGER
    • SMS_EXECUTIVE

STATUS

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

MORE INFORMATION

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
955229 You experience issues in the original release of System Center Configuration Manager 2007 after you upgrade some site databases to SQL Server 2008
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates

Properties

Article ID: 970170 - Last Review: October 7, 2011 - Revision: 3.0
APPLIES TO
  • Microsoft System Center Configuration Manager 2007
Keywords: 
kbautohotfix kbexpertiseinter kbsurveynew kbbug kbfix kbqfe KB970170

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com