MID server not responding

[andy_trayler]

I am currently developing on EUREKA (prior to the move to FUJI) and I am experiencing problems with the MID server not returning responses to JDBC SQL requests agains an SQL server DB. The response that I'm seeing on the Data Source importation is MID server did not respond (within the 300 sec time period). I am seeing the ecc queue being to accumulkate items in the "processing" state and eventually nothing is handler by the MID server. Any one have any suggestion?

[andy_trayler]

The instance is doing lots of importing through the mid-server but the imports are scheduled to be sequential using the system imports -> Scheduled Imports (each import is launched after the previous (parent) import). If I run this import process manually, rather than through the scheduled import follow the parent approach this seems to be ok. So there is some sort of timing/load/semaphore problem occuring.

This is a single mid-server against a single DB import.

Memory should be fine for this (I'm experiencing this problem on both my local dev set-up and a larger customer set-up).

[tony_barratt]

Hi Andy,

Possibly the Waiting for connection semaphore indicates your are hitting a maximum number of connections.

This could be related to the number of MID Server threads

http://wiki.servicenow.com/index.php?title=MID_Server_Configuration#Setting_MID_Server_Thread_Use

There are 25 threads available for use I think.

You could increase this as an investigative step.

You can invoke a MID Server Thread Dump - which puts the info in the wrapper log is you are curious.

Or you could look a the threads from Windows or linux.

Also you could I suppose have a connection famine on the target DB.

Best Regards

Tony

[lileem09]

Did any of the above help you to resolve your issue? I am experiencing the same and there is nothing in the log file showing any issues/errors.

[Community Alums]

I have exactly same issue now in kingston version. Any suggestions ? 

[andy_trayler]

Have you looked at the ECC queue to see if tasks are in progress?