Symantec helps consumers and organizations secure and manage their information-driven world. Our software and services protect against more risks at more points, more. Robert’s last comment is correct. Additionally, if you are in an domain environment that has a WSUS server, you will not be able to download the EN-US language pack.

WSUS replica server fails to synchronize with the master. WSUS infrastructure consisting of master WSUS server and one or more downstream replica servers may, at some point, stop synchronizing successfully.

1. Command-line automation can greatly improve your Windows patching process. Learn how to install WSUS updates immediately with this PowerShell script and reclaim some.
2. Thank you for this article it helped me to move WSUS without logging into SQL. On SBS 2008 I came up with a couple of errors when trying to detach and reattach the.
3. I was told to uninstall 3.1, which I did. I then rebooted and.

If you enable driver updates in your WSUS infrastructure, this sync issue may happen as quickly as 2 weeks after the WSUS server build. Most frustratingly, running index defrag on WSUS database or/and running WSUS Cleanup Wizard do nothing to fix the issue.

Symptoms. When you attempt to synchronize downstream server with the master, sync progress goes to 9x% (9. It eventually errors out with a SQL exception error, typically this is a timeout. You can see this message by clicking on the Details link in the sync run details, in WSUS console. Sql. Exception: Timeout expired. Check out this article first to see if driver update problem applies to you.

Cause. If this is specifically a Tds. Parser timeout, the issue is that your WSUS system has too many hidden updates in the database, and from the looks of it, WSUS server is trying to do some XML parsing of hidden updates and is not able to process all updates for replica sync. Hidden updates = declined updates. Number of declined updates mushrooms in WSUS databases if, ironically, you run WSUS Cleanup Wizard, which marks superseded and expired updates as declined. Declining unneeded updates is a good thing but it has this interesting side effect of breaking WSUS replication.

To confirm that this is indeed the issue, on your replica WSUS server, open SQL Server Management Studio (this article has information on how to install SSMS on WIDS WSUS database server), open Activity Monitor, expand expensive queries pane, and trigger manual synchronization run. You should see two RUNNABLE processes, one of which will be running under NETWORK SERVICE identity and showing as coming from wsusservice. Right- click on this process and click Details. You will see this command: SUSDB. Get. Updates. For. Bulk. Hide. In. Replica. Sync; 1. Next, run this statement above in SSMS new query window.

You should get a response back from SQL very quickly (a couple of seconds) but it will contain several tens of thousands of results – possibly 5. If you don’t see any other queries in Activity Monitor, and your CPU utilization goes up and flattens out, taking up about one core (so ~2. CPU utilization on a 4- core system), and stays at that level for a few minutes, the article applies to your situation. The issue is that SQL server returns requested results quickly, but then WSUS server tries to do something with associated XML definitions (explaining why there are no subsequent queries and seemingly high CPU utilization) and times out. Running this query below will also return a large number of matches, possibly as high as 5. SELECT * FROM tb. Update WHERE is. Hidden = 1.

Temporary Fix. Before putting in a more permanent (and irreversible) fix, try running this query on the replica WSUS server that can’t synchronize successfully: UPDATE tb. Update SET is. Hidden = 0 WHERE is.

Hidden = 1. After running this query, perform a manual sync on the replica WSUS server. Most likely, your replication will succeed this time, proving further that the issue is the number of hidden/declined updates in the system.

Unfortunately, you would only be able to synchronize once using this method. The first synchronization run will synchronize is. Hidden flag in the tb. Update table from the master WSUS server, and the following replication runs will fail with the same Tds.

Parser issue. Permanent Fix. Permanent solution involves reducing the number of hidden updates in the database. You need to manually delete definitions of hidden updates. Use the following queries to do this, and don’t forget to do it on all WSUS servers (assuming each WSUS server has a WIDS or Sql.

Express database) in your infrastructure. Revision where Local.

Update. Id in (select Local. Update. Id from tb. Update where ishidden=1)). Property where revisionid in (select revisionid from tb. Revision where Local. Update. Id in (select Local.

Update. Id from tb. Update where ishidden=1)). Localized. Property. For. Revision where revisionid in (select revisionid from tb.

Revision where Local. Update. Id in (select Local.

Update. Id from tb. Update where ishidden=1 )). File. For. Revision where revisionid in (select revisionid from tb.

Revision where Local. Update. Id in (select Local. Update. Id from tb.

Update where ishidden=1 )). Installed. Update. Sufficient. For. Prerequisite where prerequisiteid in (select Prerequisiteid from tb.

Pre. Requisite where revisionid in (select revisionid from tb. Revision where Local. Update. Id in (select Local. Update. Id from tb. Update where ishidden=1 ))). Pre. Requisite where revisionid in (select revisionid from tb.

Revision where Local. Update. Id in (select Local. Update. Id from tb. Update where ishidden=1 )). Deployment where revisionid in (select revisionid from tb. Revision where Local. Update. Id in (select Local.

Update. Id from tb. Update where ishidden=1 )). Xml where revisionid in (select revisionid from tb. Revision where Local. Update. Id in (select Local. Update. Id from tb. Update where ishidden=1 )).

Pre. Computed. Localized. Property where revisionid in (select revisionid from tb. Revision where Local. Update. Id in (select Local. Update. Id from tb. Update where ishidden=1 )).

Driver where revisionid in (select revisionid from tb. Revision where Local. Update. Id in (select Local.

Update. Id from tb. Update where ishidden=1)). Flattened. Revision.

In. Category where revisionid in (select revisionid from tb. Revision where Local. Update. Id in (select Local.

Update. Id from tb. Update where ishidden=1)). Revision. In. Category where revisionid in (select revisionid from tb. Revision where Local. Update. Id in (select Local. Update. Id from tb.

Update where ishidden=1)). More. Info. URLFor. Revision where revisionid in (select revisionid from tb. Revision where Local.

Update. Id in (select Local. Update. Id from tb. Update where ishidden=1)). Bundle. At. Least. One where bundledid in (select bundledid from tb.

Bundle. All where revisionid in (select revisionid from tb. Revision where Local. Update. Id in (select Local. Update. Id from tb. Update where ishidden=1))).

Bundle. All where revisionid in (select revisionid from tb. Revision where Local.

Update. Id in (select Local. Update. Id from tb. Update where ishidden=1)).

Security. Bulletin. For. Revision where revisionid in (select revisionid from tb. Revision where Local. Update. Id in (select Local. Update. Id from tb. Update where ishidden=1)).

KBArticle. For. Revision where revisionid in (select revisionid from tb. Revision where Local. Update. Id in (select Local. Update. Id from tb.

Update where ishidden=1)). Revision. Supersedes. Update where revisionid in (select revisionid from tb. Revision where Local.

Update. Id in (select Local. Update. Id from tb.

Update where ishidden=1)). Bundle. At. Least. One where revisionid in (select revisionid from tb. Revision where Local. Update. Id in (select Local. Update. Id from tb. Update where ishidden=1)).

Eula. Property where revisionid in (select revisionid from tb. Best Institute For Software Testing Course In Hyderabad Secunderabad. Revision where Local.

Update. Id in (select Local. Update. Id from tb. Update where ishidden=1)). Revision where Local. Update. Id in (select Local.

Update. Id from tb. Update where ishidden=1). Microsoft Windows Server 2012 X64 Dazzling here.

Update. Summary. For. All. Computers where Local.

Update. Id in (select Local. Update. Id from tb. Update where ishidden=1). Installed. Update. Sufficient. For. Prerequisite where Local.

Update. Id in (select Local. Update. Id from tb. Update where ishidden=1). Update where ishidden = 1.

The key is to delete all dependent records in tables other than tb. Update, and finally delete all is. Hidden = 1 records from tb.

Update table. The last statement in this script is what actually fixes WSUS replication problem.