Every day the website slows down and I can't get a response from the site, the pages do not load. When I looked at the resource usage, I saw that Information Service v3 consumes a lot of memory and CPU. When I examined the logs, I saw the following errors. Since my current version is 2022.4.1, the solutions I searched for Solarwinds all seem to be 2020. The latest version. I solve this problem by restarting the services all the time, but restarting the services doesn't make any sense since it's a daily problem. Anyone have experience on the subject?
ERROR SolarWinds.InformationService.Core.InformationService - w3wp| /LM/W3SVC/2/ROOT-5-133177216663706463| SolarWinds.Orion.Web.Plugins.Footer.FooterAvailabilityManager.GetFooterString()| (null) Exception running query:
SELECT l.LicenseName, la.ProductName
FROM Orion.Licensing.LicenseAssignments la
LEFT JOIN Orion.Licensing.Licenses l ON l.LicenseKey = la.LicenseKey AND l.LicenseVersion = la.LicenseVersion AND l.ProductName = la.ProductName RETURN XML RAW
ERROR SolarWinds.InformationService.Serialization.XmlSerializer - (null) (null) Error serializing query results <s:Envelope xmlns:s="">www.w3.org/.../soap-envelope" xmlns:a="">www.w3.org/.../addressing">
<s:Header>
<a:Action s:mustUnderstand="1">schemas.solarwinds.com/.../a:Action>
<a:MessageID>urn:uuid:1bf5211f-ad52-4868-81ce-8bc9ad36f6e2</a:MessageID>
<a:ReplyTo>
<a:Address>www.w3.org/.../a:Address>
</a:ReplyTo>
<Impersonation xmlns="">schemas.solarwinds.com/.../informationservice" xmlns:i="">www.w3.org/.../XMLSchema-instance">
<TargetUsername>A101\berna.baysal</TargetUsername>
</Impersonation>
<i18n xmlns="">schemas.solarwinds.com/.../informationservice" xmlns:i="">www.w3.org/.../XMLSchema-instance">
<Culture>en-US</Culture>
</i18n>
<SwisSettings xmlns="">schemas.solarwinds.com/.../informationservice" xmlns:i="">www.w3.org/.../XMLSchema-instance">
<AppendErrors>false</AppendErrors>
<ApplicationTag>w3wp| /LM/W3SVC/2/ROOT/api2-7-133177216682144768| SolarWinds.Orion.Web.Platform.Data.SwisRepository.Query()| </ApplicationTag>
<DataProviderTimeout>PT0S</DataProviderTimeout>
<FederationEnabled>false</FederationEnabled>
</SwisSettings>
<SwisProtocolVersion xmlns="">schemas.solarwinds.com/.../SwisProtocolVersion>
<IsBase64EncodingAccepted xmlns="">schemas.solarwinds.com/.../IsBase64EncodingAccepted>
<a:To s:mustUnderstand="1">net.tcp://localhost:17777/SolarWinds/InformationService/v3/Orion/Streamed/certificate</a:To>
</s:Header>
<s:Body>... stream ...</s:Body>
</s:Envelope>
SELECT
[NotificationID],
[TypeID],
ToLocal([Timestamp]) AS Timestamp,
[ImageLink],
[DisplayAs],
[CustomDismissButtonText],
[HideDismissButton],
[AcknowledgeByItemId],
[DetailsPageLink],
[DetailsPageLinkCaption],
[Message]
FROM Orion.NotificationItemGrouped
ORDER BY [Timestamp] DESC
RETURN XML RAW
System.NullReferenceException: Object reference not set to an instance of an object.
at SolarWinds.InformationService.Serialization.XmlResponseSerializerSimple.Serialize(XmlWriter writer)
at SolarWinds.InformationService.Serialization.XmlSerializer.Serializable.WriteXml(XmlWriter writer)
