SELECT SMS_R_System.Name FROM SMS_R_System JOIN SMS_G_System_COMPUTER_SYSTEM ON SMS_R_System.ResourceID = SMS_G_System_COMPUTER_SYSTEM.ResourceID JOIN SMS_G_System_OFFICE365PROPLUSCONFIGURATIONS AS ON SMS_R_System.ResourceID =SMS_G_System_OFFICE365PROPLUSCONFIGURATIONS.ResourceID WHERE SMS_G_System_OFFICE365PROPLUSCONFIGURATIONS.VersionToReport LIKE '%15330.20264%'
You can add one more condition to get x64 or x86 client versions:
Microsoft 365 Apps Update – Semi-Annual Enterprise Channel Quality Update for x64 based Edition Version 2102 (Build 13801.21004) (KB3104046) fails to get installed on a client where both English and German Microsoft 365 Apps are installed
When only the English version of this M365 update is deployed to the client it can get installed successfully.
Error Code: 0x5B4 (1460) - 0x800705b4 Error Name: ERROR_TIMEOUT Error Source: Windows Error Message: This operation returned because the timeout period expired.
DTS log says it successfully downloaded ONE file. Just one file only and no more! However, the update with English and German version contain many other files and is over 3G in size.
10-26-2021 11:18:36.838 DataTransferService 12280 (0x2ff8) DTSJob {9B87386D-110C-4726-8A24-3CE821E071C6} created to download from 'https://contoso.lab.com:443/SMS_DP_SMSPKG$/162734f6-b630-4373-b5d2-f22b051a80be' to 'C:\WINDOWS\ccmcache\1a'.
10-26-2021 11:18:36.838 DataTransferService 4156 (0x103c) DTSJob {9B87386D-110C-4726-8A24-3CE821E071C6} in state 'PendingDownload'.
10-26-2021 11:23:48.526 DataTransferService 16608 (0x40e0) Updating ccmcache with the downloaded file data
10-26-2021 11:23:48.530 DataTransferService 16608 (0x40e0) Adding full file Office\Data\16.0.13801.21004\i640.cab to cache
10-26-2021 11:23:48.552 DataTransferService 16608 (0x40e0) Download completed for file sccm?/Office/Data/16.0.13801.21004/i640.cab
10-26-2021 11:23:48.578 DataTransferService 8084 (0x1f94) DTSJob {9B87386D-110C-4726-8A24-3CE821E071C6} in state 'NotifiedComplete'.
10-26-2021 11:23:48.579 DataTransferService 8084 (0x1f94) DTS job {9B87386D-110C-4726-8A24-3CE821E071C6} has completed:
Status : SUCCESS,
Start time : 10/26/2021 11:18:36,
Completion time : 10/26/2021 11:23:48,
Elapsed time : 311 seconds
Another interesting point is that UpdatesHandle.log prints the following information.
10-26-2021 11:17:59.144 UpdatesHandler 15148 (0x3b2c) CUpdate::CheckLocations - Checking locations on action (INSTALL) for Update (162734f6-b630-4373-b5d2-f22b051a80be)
10-26-2021 11:18:02.459 UpdatesHandler 15148 (0x3b2c) Starting download on action (INSTALL) for Alternate Update (162734f6-b630-4373-b5d2-f22b051a80be)
10-26-2021 11:18:02.553 UpdatesHandler 15148 (0x3b2c) CAtomicUpdate::ScheduleDownloadTimer - Timer started, download will timeout in 120 seconds
10-26-2021 11:20:02.570 UpdatesHandler 14608 (0x3910) ContentAvailable notification received from CAS.
10-26-2021 11:20:02.583 UpdatesHandler 14608 (0x3910) CAS failed to download update (162734f6-b630-4373-b5d2-f22b051a80be). Error = 0x800705b4. Releasing content request.
I had a hunch that it could be either related to missing content or to some antivirus.
With the help of ContentLibraryExplorer.exe tool on the primary site, I found that the update files of German version are missing. What was annoying was that Update distribution points could not refresh the target distributions as expected. In the end, I had to create a new package at a new location and distributed the package to the target distribution points. I deployed the update again to the client computer and voila, it worked!
Office 365 updates sync failed with “Failed to download or process the O365 file manifest. Caught exception: System.IO.FileNotFoundException: Failed to download file manifest for O365 from http://officecdn.microsoft.com/pr/wsus/ofl.cab, with error 12029~~”
Issue: Software Update synchronization failed with the following exceptions in wsyncmgr.log.
SMS_WSUS_SYNC_MANAGER 8032 (0x1f60) Failed to download file- "http://officecdn.microsoft.com/pr/wsus/ofl.cab" from internet. Using proxyserver - 0. Error = 12029
SMS_WSUS_SYNC_MANAGER 8032 (0x1f60) Failed to download or process the O365 file manifest. Caught exception: System.IO.FileNotFoundException: Failed to download file manifest for O365 from http://officecdn.microsoft.com/pr/wsus/ofl.cab, with error 12029 at Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.DownloadAndExtractCabFile(String cabFileUrl, String fileNameInCab) SMS_WSUS_SYNC_MANAGER 8032 (0x1f60) Failed to download or process the O365 file manifest. Caught exception: System.IO.FileNotFoundException: Failed to download file manifest for O365 from http://officecdn.microsoft.com/pr/wsus/ofl.cab, with error 12029
at Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.DownloadAndExtractCabFile(String cabFileUrl, String fileNameInCab)~~
at Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.DownloadO365FileManifest(String fileManifestCabURL, String o365FileManifestXml)
SMS_WSUS_SYNC_MANAGER 8032 (0x1f60) Failed to synchronize O365 update bcaa6153-dd4b-4f69-bc39-e546554312c7 - Office 365 Client Update - Deferred Channel (1602-17) 64-bit Edition
Solution:
The hierarchy’s top level WSUS server and the top level Configuration Manager site server must have access to the following URLs:
In the previous post “Office 365 update failed to download with error 0x8007362e“, I described how to fix the issue by playing with the database. However, my customer asked me to fix all the remaining Office 365 updates seeing the same behaviour. I thought it would be enough to do a full synchronization. To my surprise, the synchronization failed.
wsyncmgr.log –
01-26-2021 15:09:19.835 SMS_WSUS_SYNC_MANAGER 8860 (0x229c) Failed to download file- "http://officecdn.microsoft.com/pr/64256afe-f5d9-4f86-8936-8840a6a4f5be/office/data/16.0.13628.20274/s320.cab" from internet. Using proxyserver - 0. Error = 80
01-26-2021 15:09:19.867 SMS_WSUS_SYNC_MANAGER 8860 (0x229c) Failed to download or process the O365 file manifest. Caught exception: System.IO.FileNotFoundException: Failed to download file manifest for O365 from http://officecdn.microsoft.com/pr/64256afe-f5d9-4f86-8936-8840a6a4f5be/office/data/16.0.13628.20274/s320.cab, with error 80 at Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.DownloadAndExtractCabFile(String cabFileUrl, String fileNameInCab) 01-26-2021 15:09:19.867 SMS_WSUS_SYNC_MANAGER 8860 (0x229c) GetOfficeFileHash_O365Service() failed to get file hash for O365 file. Caught exception: System.IO.FileNotFoundException: Failed to download file manifest for O365 from http://officecdn.microsoft.com/pr/64256afe-f5d9-4f86-8936-8840a6a4f5be/office/data/16.0.13628.20274/s320.cab, with error 80
at Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.DownloadAndExtractCabFile(String cabFileUrl, String fileNameInCab) at Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.GetOfficeFileHash_O365Service(O365FileList o365FileList, String fileContainingHash, String updateId) 01-26-2021 15:09:19.867 SMS_WSUS_SYNC_MANAGER 8860 (0x229c) ProcessOfficeFile() failed to get file properties from file manifest. Caught exception: System.IO.FileNotFoundException: Failed to download file manifest for O365 from http://officecdn.microsoft.com/pr/64256afe-f5d9-4f86-8936-8840a6a4f5be/office/data/16.0.13628.20274/s320.cab, with error 80
at Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.DownloadAndExtractCabFile(String cabFileUrl, String fileNameInCab) at Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.GetOfficeFileHash_O365Service(O365FileList o365FileList, String fileContainingHash, String updateId)
at Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.ProcessOfficeFile_O365Service(O365FileList o365FileList, Int32 iFile, XmlWriter xml, String updateId)
01-26-2021 15:09:19.867 SMS_WSUS_SYNC_MANAGER 8860 (0x229c) ProcessFileManifest() failed to process O365 file manifest. Caught exception: System.IO.FileNotFoundException: Failed to download file manifest for O365 from http://officecdn.microsoft.com/pr/64256afe-f5d9-4f86-8936-8840a6a4f5be/office/data/16.0.13628.20274/s320.cab, with error 80 at Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.DownloadAndExtractCabFile(String cabFileUrl, String fileNameInCab)
at Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.GetOfficeFileHash_O365Service(O365FileList o365FileList, String fileContainingHash, String updateId) at Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.ProcessOfficeFile_O365Service(O365FileList o365FileList, Int32 iFile, XmlWriter xml, String updateId)
at Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WsusSyncAction.WSyncAction.ProcessFileManifest_O365Service(String sO365ServiceUrl, XmlWriter xml, String updateId)
01-26-2021 15:09:19.867 SMS_WSUS_SYNC_MANAGER 8860 (0x229c) Failed to synchronize O365 update 5f3e8945-7806-4ec2-b723-ca7fd7e40edc - Microsoft 365 Apps Update - Current Channel (Preview) Version 2101 for x86 based Edition (Build 13628.20274)
Error 80 refers to file existing. I scratched my head struggling to figure out what that means. I looked into the database trying to find relevant information but in vain. Then it dawned on me that downloading had something to do with patchdownloader! Here is what I found from PatchDownloader.log –
01-26-2021 15:09:09.819 Software Updates Patch Downloader 3948 (0xf6c) Failed to create temp file with GetTempFileName() at temp location C:\Windows\TEMP\, error 80
01-26-2021 15:09:19.835 Software Updates Patch Downloader 8860 (0x229c) ERROR: DownloadContentFiles() failed with hr=0x80070050
The synchronization failed due to existing files in C:\Windows\TEMP on the software update point server. Thus the solution –
Delete all the content in C:\Windows\TEMP directory from the Software Update point server
Synchronize all updates:
Resynchronize updates – Create an empty file named full.syn in, eg. \inboxes\wsyncmgr.box on top-level site server and wait for the synchronization to complete.
Wait for its completion. To monitor the sync status: Monitoring>Overview>Software Update Point Synchronization Status
One of the possible reasons is that the server from which you downloaded the office update has the wrong update file. In fact, Microsoft provides a cluster of servers servicing the updates download. Theoretically, all those servers should have the same file content for a given office update. However, it may not be the case in reality. Sometimes things can go against your expectation as Microsoft also makes mistakes. If it is the file downloaded from the server caused the issue, one easy solution is to specify IP mappings in the hosts file in C:\Windows\System32\drivers\etc where SCCM console is installed, eg. –
23.36.252.68 officecdn.microsoft.com
You may wonder how should I know which IP I should use? Good question. If you capture a network trace file during the update download, you can find the actual IP address used for officedn.microsoft.com. And if you have another environment where you happen to succeed in downloading the same office update, you can capture a network trace file and look for the actual IP used during the download and then you can use that IP address for the other environment. Of course, this is not the best way. But you have no choice because there is nothing you can do about the updates servers that Microsoft provides. But Microsoft usually will fix the update file in short time.
What is interesting is that 0x8007362e can also mean other reasons, though literally it indicates a problem of hash verification. Let’s take a look at the following issue. One customer tried to download Microsoft 365 Apps Update – Semi-Annual Enterprise Channel Version 2002 for x64 based Edition (build 12527.21416).
PatchDownloader.log prints the following information –
01-06-2021 14:41:58.545 Software Updates Patch Downloader 78556 (0x132dc) Query to run: select f.FileName, ct.ContentSource from SMS_CIToContent c join SMS_CIContentFiles f on c.ContentID = f.ContentID join SMS_Content ct on c.ContentID = ct.ContentID where c.ContentDownloaded = 1 and f.FileHash = 'Sha256:67D805F422D110F3A346EA9F09747D59ED4BBB3AC1C5A9CE3AD8C9B534D892D9'
01-06-2021 14:41:59.101 Software Updates Patch Downloader 78556 (0x132dc) Downloading content for ContentID = 16801840, FileName = office\data\16.0.12527.21416\stream.x64.x-none.dat.
01-06-2021 14:41:59.102 Software Updates Patch Downloader 78556 (0x132dc) Proxy is enabled for download, using registry settings or defaults.
01-06-2021 14:41:59.110 Software Updates Patch Downloader 30668 (0x77cc) Connecting - Adding file range by calling HttpAddRequestHeaders, range string = "Range: bytes=0-"
01-06-2021 14:42:54.147 Software Updates Patch Downloader 30668 (0x77cc) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 10 percent complete
01-06-2021 14:43:40.883 Software Updates Patch Downloader 30668 (0x77cc) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 20 percent complete
01-06-2021 14:44:31.577 Software Updates Patch Downloader 30668 (0x77cc) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 30 percent complete
01-06-2021 14:45:14.107 Software Updates Patch Downloader 30668 (0x77cc) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 40 percent complete
01-06-2021 14:46:14.106 Software Updates Patch Downloader 30668 (0x77cc) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 50 percent complete
01-06-2021 14:47:04.850 Software Updates Patch Downloader 30668 (0x77cc) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 60 percent complete
01-06-2021 14:47:48.153 Software Updates Patch Downloader 30668 (0x77cc) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 70 percent complete
01-06-2021 14:48:47.669 Software Updates Patch Downloader 30668 (0x77cc) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 80 percent complete
01-06-2021 14:49:45.376 Software Updates Patch Downloader 30668 (0x77cc) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 90 percent complete
01-06-2021 14:50:48.126 Software Updates Patch Downloader 30668 (0x77cc) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat to C:\Users\KWS~1\AppData\Local\Temp\1\CAB7C18.tmp.dat returns 0
01-06-2021 14:50:48.131 Software Updates Patch Downloader 30668 (0x77cc) Using machine settings for CRL checking.
01-06-2021 14:50:48.135 Software Updates Patch Downloader 30668 (0x77cc) Cert revocation check is disabled so cert revocation list will not be checked.
01-06-2021 14:50:48.137 Software Updates Patch Downloader 30668 (0x77cc) To enable cert revocation check use: UpdDwnldCfg.exe /checkrevocation
01-06-2021 14:50:48.138 Software Updates Patch Downloader 30668 (0x77cc) Verifying file hash C:\Users\KWS~1\AppData\Local\Temp\1\CAB7C18.tmp.dat
01-06-2021 14:51:02.110 Software Updates Patch Downloader 30668 (0x77cc) Hash verification of file C:\Users\KWS~1\AppData\Local\Temp\1\CAB7C18.tmp.dat failed, error 0x17
01-06-2021 14:51:02.389 Software Updates Patch Downloader 78556 (0x132dc) ERROR: DownloadUpdateContent() failed with hr=0x8007362e
I tried to use IP mapping in hosts file as mentioned in the begging of the article, but in vain. Then I noticed the highlighted query in the above log. Turing to the site database, I ran the query below –
select * from vCI_ContentFiles where Content_ID='16801840' and FileHash='Sha256:67D805F422D110F3A346EA9F09747D59ED4BBB3AC1C5A9CE3AD8C9B534D892D9'
With no surprise, it returns one result exactly the same as printed in the PatchDownloader.log. The source url column has the actual download address of the update –
The actual hash value is 42649E74276D9746430BC323B3AF0F32404667A9279022BC591E7223B4CE6D3A. Next step is easy. I ran the following DML statement to update the database –
Update vCI_ContentFiles set FileHash='Sha256:42649E74276D9746430BC323B3AF0F32404667A9279022BC591E7223B4CE6D3A' where Content_ID='16801840' and FileHash='Sha256:67D805F422D110F3A346EA9F09747D59ED4BBB3AC1C5A9CE3AD8C9B534D892D9'
Finally, the update got downloaded successfully.
01-06-2021 17:04:03.768 Software Updates Patch Downloader 59304 (0xe7a8) Query to run: select f.FileName, ct.ContentSource from SMS_CIToContent c join SMS_CIContentFiles f on c.ContentID = f.ContentID join SMS_Content ct on c.ContentID = ct.ContentID where c.ContentDownloaded = 1 and f.FileHash = 'Sha256:42649E74276D9746430BC323B3AF0F32404667A9279022BC591E7223B4CE6D3A'
01-06-2021 17:04:04.146 Software Updates Patch Downloader 59304 (0xe7a8) Downloading content for ContentID = 16801840, FileName = office\data\16.0.12527.21416\stream.x64.x-none.dat.
01-06-2021 17:04:04.147 Software Updates Patch Downloader 59304 (0xe7a8) Proxy is enabled for download, using registry settings or defaults.
01-06-2021 17:04:04.154 Software Updates Patch Downloader 44036 (0xac04) Connecting - Adding file range by calling HttpAddRequestHeaders, range string = "Range: bytes=0-"
01-06-2021 17:04:44.258 Software Updates Patch Downloader 44036 (0xac04) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 10 percent complete
01-06-2021 17:05:35.130 Software Updates Patch Downloader 44036 (0xac04) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 20 percent complete
01-06-2021 17:06:22.481 Software Updates Patch Downloader 44036 (0xac04) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 30 percent complete
01-06-2021 17:07:08.299 Software Updates Patch Downloader 44036 (0xac04) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 40 percent complete
01-06-2021 17:08:30.809 Software Updates Patch Downloader 44036 (0xac04) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 50 percent complete
01-06-2021 17:09:04.307 Software Updates Patch Downloader 44036 (0xac04) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 60 percent complete
01-06-2021 17:09:36.654 Software Updates Patch Downloader 44036 (0xac04) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 70 percent complete
01-06-2021 17:10:12.204 Software Updates Patch Downloader 44036 (0xac04) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 80 percent complete
01-06-2021 17:10:53.899 Software Updates Patch Downloader 44036 (0xac04) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat in progress: 90 percent complete
01-06-2021 17:11:29.600 Software Updates Patch Downloader 44036 (0xac04) Download http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114/office/data/16.0.12527.21416/stream.x64.x-none.dat to C:\Users\KWS~1\AppData\Local\Temp\1\CABBA65.tmp.dat returns 0
01-06-2021 17:11:29.606 Software Updates Patch Downloader 44036 (0xac04) Using machine settings for CRL checking.
01-06-2021 17:11:29.607 Software Updates Patch Downloader 44036 (0xac04) Cert revocation check is disabled so cert revocation list will not be checked.
01-06-2021 17:11:29.607 Software Updates Patch Downloader 44036 (0xac04) To enable cert revocation check use: UpdDwnldCfg.exe /checkrevocation
01-06-2021 17:11:29.608 Software Updates Patch Downloader 44036 (0xac04) Verifying file hash C:\Users\KWS~1\AppData\Local\Temp\1\CABBA65.tmp.dat
01-06-2021 17:11:46.191 Software Updates Patch Downloader 44036 (0xac04) File hash verified: C:\Users\KWS~1\AppData\Local\Temp\1\CABBA65.tmp.dat
Hope this article helps if you run into similar issues.
SCCM Monde 