SWIS Query Not Completing In Time Before Connection is Cut

campbrs

Hello,

I have a SWIS Query running as shown below that will only work if I do not add the "RETURN XML AUTO" (takes 2.4 seconds to run) - How can I add this in my C# app without this?

SELECT A.NodeID, B.Caption, A.Script, A.Group FROM Orion.NodesCustomProperties A INNER JOIN Orion.Nodes B ON A.NodeID=B.NodeID WHERE A.Group <> 'N/A' RETURN XML AUTO

It seems to be a timing issue with the InformationService v3.  Is there a way to increase the timeout on this service over https?

I also get weird errors inside the SWQL Studio where it says communication is in a Failed State for System.ServiceModel.Channels.ServiceChannel

Thanks

tdanner

The "RETURN XML AUTO" format is designed to work with queries that use navigation properties instead of explicit joins. If you want to use that output format, the equivalent query using navigation properties looks like this:

SELECT B.NodeID, B.Caption, B.CustomProperties.Scripts, B.CustomProperties.GroupFROM Orion.Nodes BWHERE B.CustomProperties.Group <> 'N/A'RETURN XML AUTO

Your existing query would work with the "RETURN XML RAW" format.

It's strange that your query is taking so long to run. Are you having poor performance overall? Or are things mostly fine but this one query is slow?