Server closed communication device?

Question

Question

Scott Beeson · Nov 18, 2016

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

Dmitry Maslennikov · Nov 18, 2016

cconsole.log, it is a server's main log, where logged start/stop and some crash errors. You have an error when communication was terminated from the server side, in this case, I may expect that process which worked on it was crashed unexpected, and it should be logged there.

0 0

score 0 · Answer 1 · 2016-11-18T10:48:53-05:00

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.

score 0 · Answer 2 · 2016-11-18T10:58:15-05:00

Sorry, it is JDBC.

This is probably a 5 minute query, but the error happens pretty quick.

Where is cconsole.log located?

score 0 · Answer 3 · 2016-11-18T11:08:29-05:00

Dmitry Maslennikov · Nov 18, 2016

cconsole.log located at mgr directory

0 0

score 0 · Answer 4 · 2016-11-18T11:32:05-05:00

If I'm understanding that document correctly, that log is literally a console log. Since I'm running this via JDBC it doesn't apply, does it?

Besides that, I can't find it. I'm doing a full filesystem search for *.log right now.

score 0 · Answer 5 · 2016-11-18T11:49:27-05:00

Thanks for clarifying. My search has 1 result for cconsole.log so far, in ./hs/mhc/TEST/docrep/mgr and it's dated today. I might be on to something.

score 2 · Answer 6 · 2016-11-18T11:44:31-05:00

Fabian Haupt · Nov 18, 2016

Did you mean to make this a comment, not an answer?

2 0