- Problem 1
Users cannot enumerate collection members if they have read permissions on a collection instance but not on the collection class.
Additionally, the following errors are 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
The Task Sequence Media Wizard under Operating System Deployment does not list task sequences that need a boot image.
- Problem 3
The counters in the Component Status window are not reset to zero as expected.
Service Pack InformationTo resolve this problem, obtain the latest service pack for Microsoft System Center Configuration Manager 2007, available from this Microsoft web site: http://www.microsoft.com/downloads/details.aspx?FamilyID=3318741a-c038-4ab1-852a-e9c13f8a8140
For a list of issues resolved in this service pack, click on the following article number in the Microsoft Knowledgebase:
Hotfix informationA 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 the problem described in this article. 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.
PrerequisitesTo apply this hotfix, you must have System Center Configuration Manager 2007 Service Pack 1 installed.
To resolve this problem, apply hotfix 969529 on all System Center Configuration Manager 2007 SP1 site servers and on all computers that have the System Center Configuration Manager 2007 administrator console installed.
Note You must apply this hotfix to support Microsoft SQL Server 2008 in a System Center Configuration Manager 2007 SP1 environment.
Restart requirementYou do not have to restart the computer after you apply this hotfix.
Hotfix replacement informationThis hotfix replaces hotfix 955262.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
File informationThe 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.
|File name||File version||File size||Date||Time||Platform|
|Adminconsole.xml||Not Applicable||2,272,516||30-Nov-2008||23:55||Not Applicable|
|Update.sql||Not Applicable||7,818||30-Nov-2008||23:55||Not Applicable|
If your SQL instance is a named instance, follow these steps after you install the hotfix 969529:
- From the updated SMS site server, stop the following services:SMS_SITE_COMPONENT_MANAGER
- Run a command at the command prompt that resembles the following:378757_ENU_i386_zip.exe -x
- Run a command at the command prompt that resembles the following:SCCM2007-SP1-KB969529-X86-ENU.exe -xNote You will obtain the Update.sql file after you run this command.
- At the SMS site database server, load the Update.sql file in step 3 by using a SQL Server query tool, such as Query Analyzer or ISQL/W. From the SQL Server query tool, select the Systems Management Server database.
- Run the Update.sql script.
- Restart the following SMS site server services:SMS_SITE_COMPONENT_MANAGER
Article ID: 969529 - Last Review: Oct 23, 2009 - Revision: 1