MID Server Error - "Did not get a response from the MID server"

[SaranyaJothivel]

Hi All,

We have a scheduled import that is set to run for every 5 minutes through out the day. The average time for the job to complete everytime is around 30 to 35 seconds. But sometimes it takes 1 hour for completing due to the below error.
**********Did not get a response from the MID server**********
com.glide.db.impex.datasource.DataSourceException: Did not get a response from the MID server
at com.glide.db.impex.JDBCProbeLoader.preLoad(JDBCProbeLoader.java:103)
at com.glide.db.impex.AbstractLoader.createColumnAttributes(AbstractLoader.java:374)
at com.glide.db.impex.AbstractLoader.createTableAndMap(AbstractLoader.java:200)
at com.glide.db.impex.AbstractLoader.createTableForImport(AbstractLoader.java:171)
at com.glide.db.impex.AbstractLoader.load(AbstractLoader.java:124)
at com.glide.db.impex.AbstractLoader.startWork(AbstractLoader.java:109)
at com.glide.worker.ProgressWorker.startAndWait(ProgressWorker.java:51)
at com.glide.worker.ProgressWorker.start(ProgressWorker.java:37)
at com.glide.system_import_set.ImportSetLoader.startWorker(ImportSetLoader.java:77)
at com.glide.system_import_set.ImportSetLoader.startLoader(ImportSetLoader.java:66)
at com.glide.system_import_set.ImportSetLoader.loadImportSetTable(ImportSetLoader.java:47)
at com.glide.system_import_set.ImportSetLoader.loadImportSetTable(ImportSetLoader.java:30)
at com.snc.automation.ScheduledImportSetJob.runImport(ScheduledImportSetJob.java:48)
at com.snc.automation.ScheduledImportJob.execute(ScheduledImportJob.java:43)
at com.glide.schedule.JobExecutor.execute(JobExecutor.java:65)
at com.glide.schedule.GlideScheduleWorker.executeJob(GlideScheduleWorker.java:127)
at com.glide.schedule.GlideScheduleWorker.process(GlideScheduleWorker.java:97)
at com.glide.schedule.GlideScheduleWorker.run(GlideScheduleWorker.java:54)

Can anyone guide me here what would be the possible cause for this error message. Thanks for your kind response.

Best Regards,
Saranya.

[john_andersen]

The MID Server is probably picking up the scheduled JDBC job. HOwever, if the database in your network drops the connection or doesn't respond, then the MID Server won't get a response back to the instance and the job could fail with this error.

Of course, I don't know your setup, haven't seen your logs, etc, but I would recommend troubleshooting your Database connections because I would believe that would be the most likely cause for the MID Server not responding on the query job it executed.

[SaranyaJothivel]

@John:Thanks for the reply.

As per the MID Server logs, it was identified that there was some network issue for sometime and it got resolved by itself.
The MID Server logs reads as follows: "Software caused connection abort: recv failed"..