KB Files Required not Downloaded to Cache

[MTRankin]

I have found 2 files today that are need by our servers but were not downloaded to the Cache directory on BatchPatch server, “D:\Batchpatch\Updates\Cache”. The two files are.

sqlserver2019-kb5042749-x64_2c0838a37fa4e7a546a74b7a70fb3785eed6401d
sqlserver2022-kb5042578-x64_18623cd1ce0bf3194b464398271eb0302ae62b37

It reported that it needed them, but it could not find them. I was able to download them manually and place them on BatchPatch which allowed for a successful install.

My concern is that it happened on two different servers we use to install updates from. One of the servers is Hosted by AWS and the other we host ourselves.

Thank You for any help in understanding this you can provide.

Regards,
Mike

[doug]

The log columns will show exactly what occurred and if a download was skipped or failed etc. If you need help reviewing logs, feel free to contact us.

[MTRankin]

Thank you Doug. Could you point to me to where I would find the log files on the batchPatch server?

Thanks,
Mike

[doug]

When you perform a Windows Update action, the row in the grid will have ‘All Messages’ column, ‘Remote Agent Log’ column, ‘Local Agent Log’ column, which together can be used to see what occurred during an offline update action for a given row. You can/shold always reviews those columns after an action, if you believe something didn’t go as expected, since they will show what occurred. The contents of just the ‘Remote Agent Log’ column are also saved to the remote working directory of the target computer (default is C:\Program Files\BatchPatch\BatchPatch.log). The ‘Local Agent Log’ column is not saved outside of the BatchPatch grid.

[MTRankin]

My apologies, I did check and all it said was, it could not find the file. Here is the message from the log file. I am wonder why it did not download from Microsoft. Again, I was able to download it and place it in the Cache directory.

::Begin copying files to Windows Update cache

1> Windows Malicious Software Removal Tool x64 – v5.128 (KB890830)
1> C:\Program Files\BatchPatch\cache\windows-kb890830-x64-v5.128_f786417fbcec3039e78101d55d5632f4f4b7d35b.exe :: Copy To Cache: Succeeded

2> Security Update for SQL Server 2022 RTM CU (KB5042578)
1> sqlserver2022-kb5042578-x64_18623cd1ce0bf3194b464398271eb0302ae62b37.exe :: Copy To Cache: Failed. HRESULT: -2147024894

3> 2024-09 Cumulative Update for Microsoft server operating system version 21H2 for x64-based Systems (KB5042881)
1> C:\Program Files\BatchPatch\cache\windows10.0-kb5042881-x64_8df3cf57ac2b0fbf0675d94984020a6168e01830.cab :: Copy To Cache: Succeeded

::End copying files to Windows Update cache

::Begin adding downloaded items to installer collection

adding> Windows Malicious Software Removal Tool x64 – v5.128 (KB890830)
skipped> Security Update for SQL Server 2022 RTM CU (KB5042578) – Reason: Update not downloaded/cached
adding> 2024-09 Cumulative Update for Microsoft server operating system version 21H2 for x64-based Systems (KB5042881)

::End adding downloaded items to installer collection

[doug]

This ‘Remote Agent Log’ detail that you pasted doesn’t show the download attempt because in ‘cached mode’ the download details appear in the ‘Local Agent Log’ not the ‘Remote Agent Log’ column. If you execute a new “download updates” operation, you’ll be able to see the download attempts and any failure messages. This log that you have here is showing the caching operation failing because the file didn’t exist in the cache. It’s not showing the actual download operation.

[MTRankin]

Right now I have already added the two files to the cache folder on the distribution server so when I go to update they are there and can be copied to the remote servers doing the updates. I more updates tomorrow, so I can remove these two files from the server and get the error then.

Thank You,
Mike

[doug]

How are you populating your cache folder in the first place?

Are you using online cached mode or offline cached mode?

Are you using “Download offline updates repository” to populate your cache?

Or are you just executing “Download and install updates” on target computers, and then the BatchPatch computer has access to the internet to download the updates to the cache?

Which scenario at this link describes the method/approach that you are using?
cached-mode-and-offline-updates

=============

Since you have already resolved the issue by placing the files into the cache, I’m not sure that there is any value to removing them. It sounds like we might be trying to solve a problem that doesn’t exist. If your goal is to see why they weren’t downloaded in the first place, then start by going through my questions above. At the moment I don’t know enough about what you’re doing to really comment much, as there are multiple ways you could be using BatchPatch, and multiple ways for the cache to get populated etc. I’m not sure the exact method/operation that you’re using. If BatchPatch couldn’t download a file from Microsoft but then you downloaded it yourself, it sounds like the problem is solved.

[MTRankin]

We are using Cache mode and Offline mode.

[MTRankin]

We are using Cache mode and Offline mode. The distribution server does have access to the internet.

[MTRankin]

Here is the latest issue with certain files not downloading. I do not see what the error could be.

Local Agent Log
::Begin download – 2024-10-14 10:14:17

Microsoft Offline Scan File
1> wsusscn2.cab :: Skipped: ‘Do not download newest wsusscn2.cab if any version is already cached’ setting is enabled

::End download – 2024-10-14 10:14:17

Files downloaded: 0
Files located in cache: 1
Files excluded by filter: 0
Files initiated by another row: 0
Failures: 0

::Begin file copy operation – 2024-10-14 10:14:17

1> WsusScn2.cab :: File already exists in destination

::End file copy operation – 2024-10-14 10:14:18

::Begin download – 2024-10-14 10:19:15

::End download – 2024-10-14 10:19:34

Files downloaded: 0
Files located in cache: 0
Files excluded by filter: 0
Files initiated by another row: 0
Failures: 0

::Begin file copy operation – 2024-10-14 10:19:34

Security Update for SQL Server 2022 RTM CU (KB5046059)
1> sqlserver2022-kb5046059-x64_2b8a00ea1782f87f002605d6cf3231cf47882da5.exe :: Failed: Could not find file ‘D:\Batchpatch\Updates\Cache\sqlserver2022-kb5046059-x64_2b8a00ea1782f87f002605d6cf3231cf47882da5.exe’.

::End file copy operation – 2024-10-14 10:19:34

Files copied: 0
Files skipped: 0
Failures: 1

All Messages
10/14 10:24:36> Windows Update: END (Offline mode: Download and install updates)
10/14 10:24:34> Windows Update: There are no updates available for installation
10/14 10:19:38> Windows Update: Executing BatchPatchRemoteAgent.exe…
10/14 10:19:36> Windows Update: Attempting to initiate Windows Update (Action: Copy files to Windows Update cache and install updates: ‘ImportantAndRecommended’ | Server selection: Offline sync service) …
10/14 10:19:36> Windows Update: Establishing connection…
10/14 10:19:34> Windows Update: Initializing…
10/14 10:19:34> Windows Update: File copy complete (Files copied: 0. Failures: 1)
10/14 10:19:34> Windows Update: Copying file(s) from local cache to target working directory…
10/14 10:19:34> Windows Update: Attempting to copy file(s) from local cache to target working directory…
10/14 10:19:34> Windows Update: Local download complete (Files downloaded: 0. Files located in cache: 0. Files excluded by filter: 0. Files initiated by another row: 0. Failures: 0)
10/14 10:19:15> Windows Update: Executing local downloader…
10/14 10:19:15> Windows Update: Queued local downloader…
10/14 10:19:13> Windows Update: 1 update(s) found
10/14 10:14:22> Windows Update: Executing BatchPatchRemoteAgent.exe…

[doug]

The log info that you included in your posting does not show the entire picture, as the log details are spread across multiple columns. If you’d like help sorting through this, please contact us directly for further assistance. We’ll ask you to send us an HTML grid export so that we can review everything instead of just the tidbits that you’re pasting.

[Author]

Posts