SWQL Studio Communciation Object in Failed State

Question

I have a query that is doing some aggregate calculations. It runs fine over a certain interval that takes less than 30 seconds to get results from the server. When I extend the range, and it takes more than about 30 seconds I get the follow error. The error is unclear, I assume it is a timeout, but do not know if it is the SWQL Studio Client setting or the Server. Does anyone know?

tdanner · Accepted Answer

I just realized that my test earlier wasn't really valid. The 30-second timeout you are seeing is happening at the SQL Server level, but in my test I induced a delay in SWIS so I didn't hit the SQL timeout.

I don't see any way to override this timeout from SWQL Studio. If you switch your testing over to PowerShell, you can provide a "-TimeOut" parameter to Get-SwisData and specify a timeout in seconds. This should allow you to run queries that spend more than 30 seconds in the database.