Microsoft KB Archive/810817

= User rights to individual packages on a distribution point are unintentionally deleted =

Article ID: 810817

Article Last Modified on 7/5/2007

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition
 * Microsoft Systems Management Server 2003

-



Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry



SYMPTOMS
On a distribution point, user rights to individual packages may be unintentionally deleted if the Microsoft Systems Management Server Administrative console or Distribution Manager (DistMgr) threads try to update the PkgAccess table while DistMgr is reading it. This can result in log entries in the Distmgr.log file that resemble the following:

Thread 451

Sleep 3600 seconds...

SQL>>>select distinct PkgID, Priority from PkgNotification order by Priority ASC

SQL>>>>> Done.

SQL>>>delete from PkgNotification where PkgID = &quot;R0100061&quot;

SQL>>>>> Done. $$

...

Starting package processing thread,thread ID = 20E

Thread 362

Processing incoming file D:\SMS\inboxes\distmgr.box\INCOMING\IJW3WK1A.PKG.

...

SQL>>>delete PkgAccess where PkgID = &quot;R0100061&quot;

SQL>>>>> Done.

SQL>>>insert PkgAccess (PkgID, UserGroup, Access) values (&quot;R0100061&quot;, &quot;[&quot;&quot;Display=Administrators&quot;&quot;]GENERIC:GROUP=Administrators&quot;, 511)

SQL>>>>> Done.

SQL>>>insert PkgAccess (PkgID, UserGroup, Access) values (&quot;R0100061&quot;, &quot;[&quot;&quot;Display=Guests&quot;&quot;]GENERIC:GROUP=Guests&quot;, 0)

SQL>>>>> Done.

SQL>>>insert PkgAccess (PkgID, UserGroup, Access) values (&quot;R0100061&quot;, &quot;[&quot;&quot;Display=Users&quot;&quot;]GENERIC:GROUP=Users&quot;, 101)

SQL>>>>> Done.

---> time of the delete PkgAccess: Mon Sep 9 13:48:51.774

---> time of insert PkgAccess: Mon Sep 9 13:48:51.915

---> time of insert PkgAccess: Mon Sep 9 13:48:51.977

---> time of insert PkgAccess: Mon Sep 9 13:48:52.227

Thread 526 (20E)

Start updating the package R0100061...

...

SQL>>>select UserGroup, Access from PkgAccess where PkgID = &quot;R0100061&quot; order by UserGroup

SQL>>>>> Done.

---> time of select from PkgAccess: Mon Sep 9 13:48:51.774

---> compare timestamp of the select with the delete / insert timestamps from thread 362



Microsoft Systems Management Server 2.0
A supported hotfix is now available from Microsoft. However, it is intended to correct only the problem that is described in this article. Apply it only to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next service pack that contains this hotfix.

To resolve this problem immediately, contact Microsoft Customer Support Services to obtain the hotfix. For a complete list of Microsoft Customer Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question. 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.

Note Because of file dependencies, the most recent hotfix or feature that contains the files may also contain additional files.

Microsoft Systems Management Server 2003
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

To resolve this problem, follow these steps.

SMS Server 2003 Service Pack 2 (SP2)
Install the hotfix that is mentioned in the following Microsoft Knowledge Base article:

905751 Some packages are not uncompressed in the share folder on the distribution point in a multi-tier Microsoft Systems Management Server 2003 Service Pack 2 hierarchy



Step 2: Configure the Notification Delay registry value
After you install the hotfix that is mentioned in &quot;Step 1: Install the following hotfix,&quot; the Notification Delay value is added to the following registry subkey:

Value name: Notification Delay

Value type: REG_DWORD

Value data:

Note This value controls the time that the Distribution Manager waits before the Distribution Manager processes package change notifications. The value can be between 5 and 300 seconds.

Modify this registry value to set a delay that is sufficiently long to allow all permission changes to a package to complete before the Distribution Manager acts on the package.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbqfe kbpackage kbsoftwaredist kbfix kbbug KB810817

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.