search

solarwinds / OrionSDK

SDK for the SolarWinds Orion platform, including tools, documentation, and samples in PowerShell, C#, Go, Perl, and Java.
https://thwack.com/OrionSDK
Apache License 2.0
397 stars 138 forks source link

socket connection was aborted #121

Open lafrank opened 6 years ago

lafrank commented 6 years ago

From a .Net 4.5 application I am connecting to Orion to query for node data. To connect I am using the code ported from SwisPowerShell ConnectSwis like:

image

To execute the query I also ported the code from GetSwisData as below: image

First I query Node properties using SELECT Name FROM Metadata.Property where EntityName = 'Orion.Nodes' then I am also querying available CustomProperties with SELECT Name FROM Metadata.Property where EntityName = 'Orion.NodesCustomProperties'. These queries works perfectly. Then, if I try to query actual Nodes like SELECT {0} FROM Orion.Nodes N INNER JOIN Orion.NodesCustomProperties C on C.NodeId = N.NodeId

I receive the below error and I am unable to overcome :

The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '00:59:59.9980000'.

However, If I omit the first two queries, and only perform the last one, the query succeeds. Also, this does not happen on all computers, only on some newer Win10 machines.

What settings can I tune ? Can you please advise why this happens ? This is driving me crazy already.

Thank you.

tdanner commented 6 years ago

The first thing I would check would be the SWIS log on the Orion server. It's at C:\ProgramData\SolarWinds\InformationService\v3.0\Orion.InformationService.log. Any errors there?

lafrank commented 6 years ago

@tdanner Thank you, I am checking the logs. I have to request it as I have no direct access to the server.