Answered by:
Error When Reviewing Unassigned Computers

Question
-
Good morning. I'm running WSUS on a fully-patched Win 12 R2 server. The "Computers" server is a downstream server running the WID database. When I click on the Unassigned Computers group, I get an "Unexpected Error". The error is at the end of this post. There's a corresponding 7053 error in the Application event log. All other computer groups work fine.
It doesn't matter from which computer I try to access this group. I get the same error. No other downstream server has this problem.
I have rebooted this downstream server. I have removed the "wsus" mmc settings from the appdata folder. I'm thinking that this is something in the database itself. I'm seriously considering starting with a new database.
Any help is much appreciated.
=-=-=-=-=-=-= Error Messages =-=-=-=-=-=-=-=-=
Log Name: Application
Source: Windows Server Update Services
Date: 9/19/2016 10:04:38 AM
Event ID: 7053
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: VRESPWSUS01.beaconhealthoptions.com
Description:
The WSUS administration console has encountered an unexpected error. This may be a transient error; try restarting the administration console. If this error persists,
Try removing the persisted preferences for the console by deleting the wsus file under %appdata%\Microsoft\MMC\.
The WSUS administration console has encountered an unexpected error. This may be a transient error; try restarting the administration console. If this error persists,
Try removing the persisted preferences for the console by deleting the wsus file under %appdata%\Microsoft\MMC\.
System.Xml.XmlException -- '', hexadecimal value 0x16, is an invalid character. Line 1, position 111370.
Source
System.Xml
Stack Trace:
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.ParseNumericCharRefInline(Int32 startPos, Boolean expand, StringBuilder internalSubsetBuilder, Int32& charCount, EntityType& entityType)
at System.Xml.XmlTextReaderImpl.ParseCharRefInline(Int32 startPos, Int32& charCount, EntityType& entityType)
at System.Xml.XmlTextReaderImpl.ParseText(Int32& startPos, Int32& endPos, Int32& outOrChars)
at System.Xml.XmlTextReaderImpl.ParseText()
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Xml.XmlReader.ReadStartElement()
at System.Xml.Serialization.XmlSerializationReader.ReadStringValue()
at System.Xml.Serialization.XmlSerializationReader.ReadTypedPrimitive(XmlQualifiedName type, Boolean elementCanBeType)
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderApiRemotingCompressionProxy.Read1_Object(Boolean isNullable, Boolean checkType)
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderApiRemotingCompressionProxy.Read2_GenericReadableRow(Boolean isNullable, Boolean checkType)
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderApiRemotingCompressionProxy.Read339_Item()
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
** this exception was nested inside of the following exception **
System.InvalidOperationException -- There is an error in XML document (1, 111370).
Source
System.Xml
Stack Trace:
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.UpdateServices.Internal.ApiRemoting.ExecuteSPSearchComputers(String computerTargetScopeXml)
at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccessProxy.ExecuteSPSearchComputers(String computerTargetScopeXml)
at Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.SearchComputerTargets(ComputerTargetScope searchScope, UpdateServer updateServer)
at Microsoft.UpdateServices.UI.AdminApiAccess.ComputerTargetManager.GetComputerTargets(ComputerTargetScope searchScope)
at Microsoft.UpdateServices.UI.AdminApiAccess.BulkComputerPropertiesCache.GetAndCacheComputers(ExtendedUpdateScope updateScope, ComputerTargetScope computerTargetScope)
at Microsoft.UpdateServices.UI.SnapIn.Pages.ComputersListPage.GetListRows()
Event Xml:
<Event xmlns='http://schemas.microsoft.com/win/2004/08/events/event'><System><Provider Name='Windows Server Update Services'/><EventID Qualifiers='0'>7053</EventID><Level>2</Level><Task>0</Task><Keywords>0x80000000000000</Keywords><TimeCreated SystemTime='2016-09-19T14:04:38.000000000Z'/><EventRecordID>5432</EventRecordID><Channel>Application</Channel><Computer>VRESPWSUS01.beaconhealthoptions.com</Computer><Security/></System><EventData><Data>The WSUS administration console has encountered an unexpected error. This may be a transient error; try restarting the administration console. If this error persists,
Try removing the persisted preferences for the console by deleting the wsus file under %appdata%\Microsoft\MMC\.
The WSUS administration console has encountered an unexpected error. This may be a transient error; try restarting the administration console. If this error persists,
Try removing the persisted preferences for the console by deleting the wsus file under %appdata%\Microsoft\MMC\.
System.Xml.XmlException -- '', hexadecimal value 0x16, is an invalid character. Line 1, position 111370.
Source
System.Xml
Stack Trace:
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.ParseNumericCharRefInline(Int32 startPos, Boolean expand, StringBuilder internalSubsetBuilder, Int32& charCount, EntityType& entityType)
at System.Xml.XmlTextReaderImpl.ParseCharRefInline(Int32 startPos, Int32& charCount, EntityType& entityType)
at System.Xml.XmlTextReaderImpl.ParseText(Int32& startPos, Int32& endPos, Int32& outOrChars)
at System.Xml.XmlTextReaderImpl.ParseText()
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Xml.XmlReader.ReadStartElement()
at System.Xml.Serialization.XmlSerializationReader.ReadStringValue()
at System.Xml.Serialization.XmlSerializationReader.ReadTypedPrimitive(XmlQualifiedName type, Boolean elementCanBeType)
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderApiRemotingCompressionProxy.Read1_Object(Boolean isNullable, Boolean checkType)
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderApiRemotingCompressionProxy.Read2_GenericReadableRow(Boolean isNullable, Boolean checkType)
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderApiRemotingCompressionProxy.Read339_Item()
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
** this exception was nested inside of the following exception **
System.InvalidOperationException -- There is an error in XML document (1, 111370).
Source
System.Xml
Stack Trace:
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.UpdateServices.Internal.ApiRemoting.ExecuteSPSearchComputers(String computerTargetScopeXml)
at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccessProxy.ExecuteSPSearchComputers(String computerTargetScopeXml)
at Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.SearchComputerTargets(ComputerTargetScope searchScope, UpdateServer updateServer)
at Microsoft.UpdateServices.UI.AdminApiAccess.ComputerTargetManager.GetComputerTargets(ComputerTargetScope searchScope)
at Microsoft.UpdateServices.UI.AdminApiAccess.BulkComputerPropertiesCache.GetAndCacheComputers(ExtendedUpdateScope updateScope, ComputerTargetScope computerTargetScope)
at Microsoft.UpdateServices.UI.SnapIn.Pages.ComputersListPage.GetListRows()</Data></EventData></Event>Monday, September 19, 2016 2:11 PM
Answers
-
Hi Roni H,
I have ever seen a similar issue with you, the cause is due to a bad data in SUSDB, the customer use a SQL query to delete the data, then the issue solves. Since I'm not a SQL guy and not professional with SQL queries, I can't manage with the query and parameter. Maybe you can invite a SQL guy to look into the detailed error message for you and use SQL server management studio to handle the query.
The similar post link:
If you don't want to bother much, you may just rebuilt the WSUS server.
Best Regards,
Anne
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.- Proposed as answer by Anne HeMicrosoft contingent staff Thursday, September 29, 2016 2:43 AM
- Marked as answer by Anne HeMicrosoft contingent staff Friday, October 7, 2016 2:22 AM
Tuesday, September 20, 2016 6:15 AM
All replies
-
Hi Roni H,
I have ever seen a similar issue with you, the cause is due to a bad data in SUSDB, the customer use a SQL query to delete the data, then the issue solves. Since I'm not a SQL guy and not professional with SQL queries, I can't manage with the query and parameter. Maybe you can invite a SQL guy to look into the detailed error message for you and use SQL server management studio to handle the query.
The similar post link:
If you don't want to bother much, you may just rebuilt the WSUS server.
Best Regards,
Anne
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.- Proposed as answer by Anne HeMicrosoft contingent staff Thursday, September 29, 2016 2:43 AM
- Marked as answer by Anne HeMicrosoft contingent staff Friday, October 7, 2016 2:22 AM
Tuesday, September 20, 2016 6:15 AM -
Hi Roni H,
Could the above replies be of help? If yes, you may mark it as answer, if not, feel free to feed back.
Best Regards,
Anne
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.Wednesday, September 28, 2016 9:15 AM