Below is a few lines of code from wsyncmgr.log that are bugging me:
Synchronizing update 1a837ac1-0fa9-4bff-89b4-01561601bd9b - Microsoft 365 Apps Update - Current Channel Version 2007 for x64 based Edition (Build 13029.20344) $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:48:44.324+420><thread=1576 (0x628)>
Base Url for Office update file list service not configured or not valid , keep the original Url $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:48:44.355+420><thread=1576 (0x628)>
Process O365 update manifest with no proxy. $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:48:44.465+420><thread=1576 (0x628)>
SQL MESSAGE: - String data, right truncation $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:50:53.611+420><thread=1576 (0x628)>
sync: SMS synchronizing updates, processed 8922 out of 11316 items (78%), ETA in 00:45:29 $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:50:54.704+420><thread=1576 (0x628)>
Synchronizing update c220f67d-7aef-4fb0-b670-62503685ac1e - SQL Server Management Studio 18.6 $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:50:54.798+420><thread=1576 (0x628)>
Synchronizing update 6661f810-b9da-4336-a7a1-fdf6f48abd55 - 2020-07 Servicing Stack Update for Windows 7 for x64-based Systems (KB4565354) $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:50:55.626+420><thread=1576 (0x628)>
Synchronizing update ba5ec0da-9de9-4312-95fd-2c852c295f8d - 2020-07 Servicing Stack Update for Windows 10 Version 1507 for x86-based Systems (KB4565911) $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:50:56.517+420><thread=1576 (0x628)>
Synchronizing update 75352e34-d650-4e85-960c-cc1021d28396 - 2020-07 Servicing Stack Update for Windows 10 Version 1803 for x86-based Systems (KB4565552) $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:50:57.423+420><thread=1576 (0x628)>
Synchronizing update 270a4d95-ad49-49c0-8b7b-b20bd03e7e6a - 2020-07 Servicing Stack Update for Windows 10 Version 1703 for x86-based Systems (KB4565551) $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:50:58.205+420><thread=1576 (0x628)>
Synchronizing update cbdd311f-9094-4a87-a5ce-8c10c46070be - 2020-07 Cumulative Update for Windows 10 Version 1709 for x86-based Systems (KB4565508) $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:50:59.080+420><thread=1576 (0x628)>
Synchronizing update eff77122-1e3e-4ad2-8c13-f2d3e0971196 - 2020-07 Servicing Stack Update for Windows 10 Version 1709 for x64-based Systems (KB4565553) $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:50:59.924+420><thread=1576 (0x628)>
Synchronizing update 4e2556e1-8b2f-4d6c-ad22-67b11736daf5 - 2020-07 Cumulative Update for Windows 10 Version 1507 for x86-based Systems (KB4565513) $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:51:00.908+420><thread=1576 (0x628)>
Synchronizing update 6e163c4b-2ce3-4f5d-a23c-8b440394a44c - 2020-07 Cumulative Security Update for Internet Explorer 11 for Windows 7 for x86-based systems (KB4565479) $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:51:01.924+420><thread=1576 (0x628)>
Synchronizing update 72caedbc-a308-4ba5-bbfb-4e4debc6c804 - Microsoft 365 Apps Update - Current Channel Version 2006 for x86 based Edition (Build 13001.20384) $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:51:02.783+420><thread=1576 (0x628)>
Base Url for Office update file list service not configured or not valid , keep the original Url $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:51:02.815+420><thread=1576 (0x628)>
Process O365 update manifest with no proxy. $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:51:02.877+420><thread=1576 (0x628)>
SQL MESSAGE: - String data, right truncation $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:53:23.957+420><thread=1576 (0x628)>
sync: SMS synchronizing updates, processed 8932 out of 11316 items (78%), ETA in 00:45:55 $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:53:24.566+420><thread=1576 (0x628)>
Synchronizing update 94c0627f-eac6-49f5-94d6-f202ac62d76e - Microsoft 365 Apps Update - Current Channel (Preview) Version 2007 for x64 based Edition (Build 13029.20236) $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:53:24.613+420><thread=1576 (0x628)>
Base Url for Office update file list service not configured or not valid , keep the original Url $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:53:24.644+420><thread=1576 (0x628)>
Process O365 update manifest with no proxy. $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:53:24.722+420><thread=1576 (0x628)>
SQL MESSAGE: - String data, right truncation $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:55:16.864+420><thread=1576 (0x628)>
sync: SMS synchronizing updates, processed 8933 out of 11316 items (78%), ETA in 00:46:24 $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:55:17.427+420><thread=1576 (0x628)>
Synchronizing update cd8c2674-9be9-4249-96a4-325e5096702a - Update for Microsoft Office 2016 (KB4484439) 32-Bit Edition $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:55:17.474+420><thread=1576 (0x628)>
Synchronizing update b8917239-6553-4503-9705-01438d4e1e10 - Microsoft 365 Apps Update for Windows 7 - Version 2002 for x64 based Edition (Build 12527.20880) $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:55:18.193+420><thread=1576 (0x628)>
Base Url for Office update file list service not configured or not valid , keep the original Url $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:55:18.224+420><thread=1576 (0x628)>
Process O365 update manifest with no proxy. $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:55:18.255+420><thread=1576 (0x628)>
SQL MESSAGE: - String data, right truncation $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:58:40.842+420><thread=1576 (0x628)>
sync: SMS synchronizing updates, processed 8935 out of 11316 items (78%), ETA in 00:47:15 $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:58:41.389+420><thread=1576 (0x628)>
Synchronizing update 68af4d94-88ce-4036-a1c5-8f0d7c2a76cb - 2020-07 Cumulative Update for Windows 10 Version 1809 for x86-based Systems (KB4558998) $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:58:41.764+420><thread=1576 (0x628)>
Synchronizing update 40b2919a-852a-49e7-90c9-18c7312cd3c4 - 2020-07 Extended Security Updates (ESU) Licensing Preparation Package for Windows 7 for x64-based Systems (KB4575903) $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:58:43.186+420><thread=1576 (0x628)>
Synchronizing update 763bc801-2b8c-4672-9e4e-98769ea33606 - Microsoft 365 Apps Update - Current Channel Version 2007 for x86 based Edition (Build 13029.20344) $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:58:44.420+420><thread=1576 (0x628)>
Base Url for Office update file list service not configured or not valid , keep the original Url $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:58:44.452+420><thread=1576 (0x628)>
Process O365 update manifest with no proxy. $$<SMS_WSUS_SYNC_MANAGER><11-12-2020 23:58:44.498+420><thread=1576 (0x628)>
SQL MESSAGE: - String data, right truncation $$<SMS_WSUS_SYNC_MANAGER><11-13-2020 00:01:19.112+420><thread=1576 (0x628)>
sync: SMS synchronizing updates, processed 8938 out of 11316 items (78%), ETA in 00:47:53 $$<SMS_WSUS_SYNC_MANAGER><11-13-2020 00:01:20.597+420><thread=1576 (0x628)>
Synchronizing update bf9e3d15-cd27-4c8e-b3b7-7a529c1cef6c - Microsoft 365 Apps Update - Current Channel (Preview) Version 2007 for x86 based Edition (Build 13029.20236) $$<SMS_WSUS_SYNC_MANAGER><11-13-2020 00:01:20.643+420><thread=1576 (0x628)>
Base Url for Office update file list service not configured or not valid , keep the original Url $$<SMS_WSUS_SYNC_MANAGER><11-13-2020 00:01:20.675+420><thread=1576 (0x628)>
Process O365 update manifest with no proxy. $$<SMS_WSUS_SYNC_MANAGER><11-13-2020 00:01:20.753+420><thread=1576 (0x628)>
SQL MESSAGE: - String data, right truncation $$<SMS_WSUS_SYNC_MANAGER><11-13-2020 00:03:16.273+420><thread=1576 (0x628)>
sync: SMS synchronizing updates, processed 8939 out of 11316 items (78%), ETA in 00:48:22 $$<SMS_WSUS_SYNC_MANAGER><11-13-2020 00:03:16.836+420><thread=1576 (0x628)>
Synchronizing update 3f6b0a54-1aeb-4248-bd70-f02dc82d1c3a - Microsoft 365 Apps Update - Semi-Annual Enterprise Channel Version 1902 for x86 based Edition (Build 11328.20624) $$<SMS_WSUS_SYNC_MANAGER><11-13-2020 00:03:16.867+420><thread=1576 (0x628)>
Base Url for Office update file list service not configured or not valid , keep the original Url $$<SMS_WSUS_SYNC_MANAGER><11-13-2020 00:03:16.883+420><thread=1576 (0x628)>
Process O365 update manifest with no proxy. $$<SMS_WSUS_SYNC_MANAGER><11-13-2020 00:03:16.945+420><thread=1576 (0x628)>
SQL MESSAGE: - String data, right truncation $$<SMS_WSUS_SYNC_MANAGER><11-13-2020 00:05:12.293+420><thread=1576 (0x628)>
sync: SMS synchronizing updates, processed 8940 out of 11316 items (79%), ETA in 00:48:52 $$<SMS_WSUS_SYNC_MANAGER><11-13-2020 00:05:13.074+420><thread=1576 (0x628)>
Synchronizing update e9fa2fe3-908f-40fd-9875-be3e0070e071 - 2020-07 Servicing Stack Update for Windows 10 Version 1709 for x86-based Systems (KB4565553) $$<SMS_WSUS_SYNC_MANAGER><11-13-2020 00:05:13.121+420><thread=1576 (0x628)>
Synchronizing update 8932c227-8e7e-4495-a4ff-f810a4de5212 - Microsoft 365 Apps Update - Semi-Annual Enterprise Channel (Preview) Version 2002 for x86 based Edition (Build 12527.20988) $$<SMS_WSUS_SYNC_MANAGER><11-13-2020 00:05:14.043+420><thread=1576 (0x628)>
Base Url for Office update file list service not configured or not valid , keep the original Url $$<SMS_WSUS_SYNC_MANAGER><11-13-2020 00:05:14.059+420><thread=1576 (0x628)>
Process O365 update manifest with no proxy. $$<SMS_WSUS_SYNC_MANAGER><11-13-2020 00:05:14.106+420><thread=1576 (0x628)>
So the first ~8000 updates processed without issue in about 5.5 minutes. Then the next thousand have taken almost 3 hours. Scanning through the completed section, the ONLY updates with this issue are the M365 App updates. It says "Base URL for Office update file list service not configured or not valid, keep the original URL." and then proceeds to try to process the update. It waits about 90 seconds before throwing the SQL message and continuing.
