Package not distributed on SCCM 2012 SP1

1. Noticed pkg “Microsoft Office Professional Plus 2013 was successfully distributed to 69 DP, failed on 2.
2. The 2 DP are:

secondary server 1 CA5 6 Secondary site 

secondary server 2 U28 6 Secondary site

3. We tried to track the package from the CAS >> Primary (P02) >> Secondary (CA5), but due a lot of traffic on the network, it became difficult:

Package C01004C7 does not have a preferred sender. SMS_DISTRIBUTION_MANAGER 03/03/2017 15:52:31 13116 (0x333C)

STATMSG: ID=2333 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_DISTRIBUTION_MANAGER" SYS=be-oev-cmc01.eu.elcompanies.net SITE=C01 PID=2984 TID=13116 GMTDATE=Fri Mar 03 14:52:31.984 2017 ISTR0="C01004C7" ISTR1="U28" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=1 AID0=400 AVAL0="C01004C7" SMS_DISTRIBUTION_MANAGER 03/03/2017 15:52:31 13116 (0x333C)

4. Needs to send the compressed package for package C01004C7 to site U28 SMS_DISTRIBUTION_MANAGER 03/03/2017 15:52:31 13116 (0x333C)

Sending a copy of package C01004C7 to site U28 SMS_DISTRIBUTION_MANAGER 03/03/2017 15:52:31 13116 (0x333C)

Found the closest site P02 for destination site U28 SMS_DISTRIBUTION_MANAGER 03/03/2017 15:52:32 13116 (0x333C)

Skipped sending compressed copy of package C01004C7 to site U28 as the closest site is P02 SMS_DISTRIBUTION_MANAGER 03/03/2017 15:52:32 13116 (0x333C)

5. We noticed that the scheduler on the CAS had mentioned 19 pending SEND jobs; none for C01004C7
6. We tracked it to P02:

The StoredPkgPath for package C01004C7 is empty. Will wait for the compressed copy to arrive. SMS_DISTRIBUTION_MANAGER 03/03/2017 9:40:22 6088 (0x17C8)

The StoredPkgPath for package C01004C7 is empty. Will wait for the compressed copy to arrive. SMS_DISTRIBUTION_MANAGER 03/03/2017 9:40:22 6088 (0x17C8)

7. Found notification for package 'C01004C7' SMS_DISTRIBUTION_MANAGER 03/03/2017 9:52:00 7752 (0x1E48)
8. Ran the following queries:

UPDATE PkgStatus

SET SourceVersion=0, STATUS=2

WHERE ID='C01004C7' AND SITECODE='P02'

UPDATE PkgStatus

SET SourceVersion=0, STATUS=2

WHERE ID='C01004C7' AND SITECODE='CA5'

9. These queries set SourceVersion of the package to 0 so that CAS would now send a fresh copy to CA5.
10. Redistributed the package to CA5 – no results. However, it got redistributed to U28.
11. Checked and verified that the content was present on SCCMContentLib on P02.
12. We tracked logs on the secondary:

Despooler failed to execute instruction, error code=12.

13. It was failing for a lot of packages, including C01004C7.
14. Ran the following and found the version being requested and expected do not macth:

Select * from pkgstatus where id='C01004C7' and pkgserver like '%ca-onf%'  

15. Realized there’s slow replication.
16. Reinitialized the group on CA5:

Update rcm_drsinitializationtracking 

Set initializationstatus=7

17. The package got distributed.

This is a known issue with ConfigMgr 2012 SP1. The workaround is to reinitialize the replication group to force the information about the package down to the secondary sites.

RECCOMENDATION:

Upgrade to (at least) SCCM 1602.

Hope this helps!