· Nov 18, 2016

Server closed communication device?

I get this on some queries in some namespaces.  For instance, this query:

SELECT TOP 10 SessionId, datediff(s,min(TimeCreated),max(TimeCreated)) as ResponseTime
FROM ens.messageheader
GROUP BY SessionId
ORDER BY ResponseTime DESC

It works fine in HSBUS but in HSREG it throws the error.

Server closed communication device

Does anyone know what would cause this? Would it log something more useful somewhere?

Discussion (7)0
Log in or sign up to continue

Needs some more details.

You tagged post both ODBC and JDBC, but it is different. For ODBC as I know you can set logging in DSN settings. For JDBC, you can set it with JDBC connection URL

Then, how long this query usually takes. I see that you query just 10 rows, but anyway.

Also, you should look, at all levels logging cconsole.log and Application error logs, for any errors, at the same time.

Unfortunately, I don't know about the difference between HSBUS and HSREG, and can't say something useful about it.