SCCM package distribution fails to send a package to a distribution point… When multiple times clicks to updates

by
SCCM package distribution fails to send a package to a distribution point… When multiple times clicks to updates

issue we can see below in the Distmgr.log file
Package
XYZ00234 requires a newer version (3) of source files and the new compressed
files haven’t arrived yet, current version is 2, skip
E:SMSinboxesdistmgr.boxINCOMINGZ3AWAX9I.PKG

read here : https://marcusoh.blogspot.sg/2008/01/sms-distribution-manager-fails-to-send.html
just to add to the above page we need to refresh the Package, and we might need to restart the Distrubutionmanager/Sender services or Componenet manager and SMS executive services.


multiple things you want to look at if you’re running into this error:


SQL Commands to update the delta replication status.

SELECT * FROM PkgStatus WHERE Type=1 AND Status=1 AND ID='XYZ00234'

most likely, you’ll get back a list of the distribution points where you’re
having a problem with the package. it should look like the following:

ID Type SiteCode PkgServer Personality Status SourceVersion UpdateTime Location ShareName HTTPUrl
XYZ00234 1 XYZ SMSServer1 0 1 93 2008-01-01

to give this a kick in the rear, run this next statement to reset the delta
replication value by changing the status to 2 and changing the sourceversion to
0:

UPDATE PkgStatus SET Status=2, SourceVersion=0
WHERE (ID='XYZ00234') AND (TYPE=1) AND (PkgServer='SMSServer1')

and now it should look like this:

ID Type SiteCode PkgServer Personality Status SourceVersion UpdateTime Location ShareName HTTPUrl
XYZ00234 1 XYZ SMSServer1 0 2 0 2008-01-01

Below are the Pkgstatus table Codes and their meanings.

PKG_STATUS_NONE 0
PKG_STATUS_SENT 1
PKG_STATUS_RECEIVED 2
PKG_STATUS_INSTALLED 3
PKG_STATUS_RETRY 4
PKG_STATUS_FAILED 5
PKG_STATUS_REMOVED 6
PKG_STATUS_PENDING_REMOVE 7 // Not used.
PKG_STATUS_REMOVE_FAILED 8
PKG_STATUS_RETRY_REMOVE 9

Leave a Comment