Description
Symptoms
When using the related link called "Test Load 20 Records" from a Data Source, the test does not complete and the page will refresh until the timeout is reached. (See additional information below about the timeout setting.)
Once the timeout is reached you may see the following error "Did not get a response from the MID Server"
If you view the ECC queue during the time of your test, you can see the JDBCProbe output record, but will not see an input record immediately or even minutes later. It may take over 15 mins or possibly hours to get an input.
https://YOUR_INSTANCE.service-now.com/ecc_queue_list.do?sysparm_query=topicLIKEJDBCProbe
If you set your MID Server to "debug" logging level, run the test again, and check the MID Server agent log, you may see the following "Socket closed" error below:
<results error="com.microsoft.sqlserver.jdbc.SQLServerException: Socket closed 	at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1667) 	at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1654) 	at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1789) 	at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:4838) 	at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:6150) 	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteCursored(SQLServerStatement.java:1877) 	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:766) 	at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689) 	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) 	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) 	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) 	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) 	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:616) 	at com.service_now.monitor.jdbc.JDBCRowSet.query(JDBCRowSet.java:64) 	at com.service_now.mid.probe.JDBCProbe.doSelect(JDBCProbe.java:312) 	at com.service_now.mid.probe.JDBCProbe.doQuery(JDBCProbe.java:198) 	at com.service_now.mid.probe.JDBCProbe.probe(JDBCProbe.java:123) 	at com.service_now.mid.probe.AProbe.process(AProbe.java:96) 	at com.service_now.mid.queue_worker.AWorker.runWorker(AWorker.java:125) 	at com.service_now.mid.queue_worker.AWorkerThread.run(AWorkerThread.java:20) 	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) 	at java.lang.Thread.run(Unknown Source) " probe_time="1808105" result_code="900000"><result/>
Cause
The message above "Did not get a response from the MID Server" may lead some to believe there is a MID Server issue when there is not. The MID Server sent out the SQL statement but the socket was closed.
A "socket closed" error indicative that the connection has been terminated, however, no specific reason was provided/returned. There can be a number of reasons such as:
- Network failure
- Firewall ACLs and/or timeouts
- The database unexpectedly terminated the connection
- Account permissions
- Physical proximity of the MID Server host and the SQL Server
Resolution
Check that the MID Server is UP https://YOUR_INSTANCE.service-now.com/ecc_agent_list.do
Install Microsoft SQL Server Management Studio (SSMS) or equivalent tool on the MID Server and run the same SQL statement that is in your Data Source then analyze the results.
Additional Information
By default the JDBC request times out after five minutes due to these default settings for these system properties:
NOTE:
If you have set your MID Server logging to DEBUG, don't forget to remove the MID Server Configuration Parameter or set it from DEBUG to INFO.