We have 18 instances of Orion in our enterprise with a very heavy dependence on automation via the API.
I am seeing a very simple SWQL query timeout when run via SWQL Studio and via code on only one instance. I occasionally see the following error:
<error>
The communication object, System.ServiceModel.Security.SecuritySessionClientSettings '1 + ClientSecurityDuplexSessionChannel[System.ServiceModel.Channels.IDuplexSessionChannel], cannot be used for communication because it is in the Faulted state
</error>
I've restarted services several times without any improvement.
SWQL query with issues:
SELECT TOP 100 CA.ConfigID, CA.DownloadTime, CA.Config, CA.NodeID
FROM NCM.ConfigArchive CA
The same basic query in "Database Manager" pulling the whole table returns in seconds.
SELECT TOP 1000 * FROM [dbo].[NCM_ConfigArchive]
Support refuses to assist since the ticket mentions "SWQL" and "SWQL Studio" even though it seems to be unique to one instance and likely below the API or SWQL Studio.