wlouisharris

Now support is telling us to upgrade all the .Net Framework versions to 4.7.2. They are saying 12.1 supports 4.7.2. I am guessing their documentation is not up to date because this is exactly what is printed in the 12.1 product requirements: .NET Framework .NET 4.5 Compatible with 4.6.1 * SolarWinds recommends using .NET…

Thanks. I found the problem. I had to create a variable for the connection; then running the query using the variable worked. PS C:\Users\wh24xu> $swis = Connect-Swis -Hostname wp046e.hostname 3.run the desired query: PS C:\Users\userID> Get-SwisData -SwisConnection $swis -Query 'SELECT DNS FROM Orion.Nodes'

Kacperm, that tip was spot on. I opened the database manager and the "SWA_InstallationSession" table. The table with row "Eula" had the "IsActive" box checked. After enabling table editing and unchecking the box I was able to run the "Updates available" option. I really wish I had known this during the upgrade.

Thanks Kacperm. I was wondering what table to check. I will check this table set to false if I can.

Hey Tdanner - nice tip This returns all the data. Adding the trust switch is what needed. $swis = Connect-Swis -Trusted -Hostname silo2 Get-SwisData -SwisConnection $swis -Query 'SELECT DNS FROM Orion.Nodes' Thanks so much.

I'm still working with support on this. This is the error we keep seeing after the license store gets corrupted. { "data": { "message": "An error has occurred.", "exceptionMessage": "RunQuery failed, check fault information.\nProvideFault failed, check fault information.", "exceptionType":…

It looks like the functions are supported but having trouble with the syntax. I am working with some guys internally that are better with SQL to try to convert SQL to SWQL. If anyone has any tips - great; otherwise I'll post when I come up with a solution.

That's great you found the solution. For us it has not been so easy. We were first told by support to make sure we had match .Net version on all our servers. We have moved them to 4.6.2. Now they are saying we need to make sure we have the security rollup. I am having a hard time locating the correct installer. We also…

Agreed it is a nuclear option. Perhaps as you say this is the cleanest method and will overall have the lowest implementation time and lowest risk. The problem I have with this solution is that we have to directly modify database tables which is considered a high risk change in our environment. I'm going to put in a…

We just upgraded QA. I really wish they would spend some more time with the user experience on these upgrades. The upgrade from the console failed(1st image) Then we used the online installer. The main poller went ok, but when we went to upgrade the additional pollers and web servers we got a message stating the upgrade…

Old post but was doing some research on the subjetc. We have tried a few tools but we ended up dropping Enterprise user experience monitoring altogether. We used HP BAC for many years. There was a lot more complexity developing the transaction monitors. It can handle more browser types. Cons are also the same as WPM - you…

I like the mention of website performance improvement. We had a number of issues with various web panels loading slowly with NPM 12.5 and 2019.4 so we are hoping this improves. Can anyone attest to the website performance improvements? 

We have setup the last database sync alert; however it is not currently alerting on a few pollers we have in this state. I can attest the pollers in this state are due to an inactivated license. I'm not sure if the alert condition accounts for pollers that have not synced due to a license activation issue. Here is what the…

We have an issue with the license store becoming corrupted after we build our HA pools in 2019.4. Still working with support on this case # 00415997. This is our QA license so I am thinking we probably caused some corruption in the database in doing several upgrades and backouts.

We coordinated a SDK training session through our sales rep which was extremely helpful. Kudos to Tim D. from Solarwinds. He showed us a query that did not utilize a join to pull metric data. Here is the query: SELECT TOP 100 I.Node.Caption AS NodeName, I.Caption, DATETRUNC('hour',I.Traffic.ObservationTimestamp) AS Time,…

I copied the time format straight from the database and I get the same error: 1)Database query output: 2)SWIS error:

Ok thanks. I did have an obvious syntax problem. SELECT TOP 100000 nodes.NodeID, Nodes.DNS, Interfaces.InterfaceID FROM Orion.Nodes INNER JOIN Orion.NPM.Interfaces ON (Nodes.NodeID = interfaces.NodeID) INNER JOIN Orion.NPM.InterfaceTraffic ON (Interfaces.InterfaceID = InterfaceTraffic.InterfaceID AND…

I'm experiencing the same issue. Luckily it is in my QA instance. I just upgraded to 12.4 but unfortunately I did not check if the functionality worked before the upgrade. I'm going to open a support case. It happens on either of my HA servers acting as primary. I re-ran configuration wizard on both my app servers to no…

Curious, does 12.5 have any fixes for 12.4? We are holding off on upgrading. We have done 3 upgrades this year(12.2, 12.3, and 12.4). Out of all the upgrades we have done 12.4 seems to be the most stable version of NPM.

Update on our case. We need to run validation for a few more days but I think we found the root cause. We are running SQL HA in 2 separate sites. Our DBA's had mistakenly set the replication to synchronous. Since the database VM's are in separate sites we need asynchronous replication. After configuring asynchronous…

Update on this case. I am still working with support. We really have not found any evidence pointing to root cause. I really cannot say what the origin of the problem is at this point but will update the post. I did work with my contact at Solarwinds to write a query that will show us when the lastheartbeat time stamp is…

I'm still working with support on the case. They did give me a cool alert to setup. Basically it does a SWIS query against the HA pool members table. I'll upload the xml file they gave me as well. Inner join HA_PoolMembers on Nodes.Sysname = HA_PoolMembers.Hostname where HA_PoolMembers.status != '2'

The only thing we have done so far with support is pull diagnostic files. All our servers are up to date with current Microsoft patches now so we have eliminated that as a possibility.

Also, here is a log message I found in the HighAvailability.service log in C:\ProgramData\SolarWinds\Logs\HighAvailability It references skipping synchronization because of pending sync task. The time stamp of the log is 3:09pm but you see the last sync completed was at 6:38am the same day; hence causing the "down" state.…

I missed the time slots. I dropped you an email. We would love to give your engineers some feedback.

We have a customer that wants a redundant Solarwinds environment and we are looking into this. The challenge we will face is that we want our app servers in 2 separate datacenters and we can't have the IP addresses in the subnet. We are also going to look at using SQL clustering. Right now the customer has a single node…

We ended up resolving the problem installing KB4457920 - Security and Quality rollup for .Net Framework. This was pulled down from WSUS using SCCM. I don't have a direct download link and it was hard to find when I originally looked for it. Also, I spoke with support. The tech I talked to said .Net Framework 4.7.2 has…

We did open a support case. We updated all our .Net versions to 4.6.2. We still see the problem intermittently. We are running NPM 12.1 so hopefully 12.3 resolves this issue.

We just started experiencing this problem. I ran a check to see if .Net Framework 4.7 is installed. All my servers have the same version and are up-to-date with the latest Microsoft patches. I'm going to open a support case.

Having the same problem. Running configuration wizard on all the pollers is quite resource heavy for us. Hoping for another fix and hate to just try something. I'm going to open a support case. Still it's not really impacting any services at this point.