Socket Closed issue when SQL linked server conencts to ODBC progress Driver

[preetha]

Hi,

Since 3 days only few jobs are failing with the below errors;

Executed as user: CORP\ftuser. hi [SQLSTATE 01000] (Message 0) two [SQLSTATE 01000] (Message 0) An error occurred while preparing the query " Select sct_site,sct_sim,sct_part,sct_cst_tot,sct_mtl_tl,sct_lbr_tl,sct_bdn_tl,sct_ovh_tl,sct_sub_tl, sct_mtl_ll,sct_lbr_ll,sct_bdn_ll,sct_ovh_ll,sct_sub_ll FROM PUB.sct_det WHERE sct_domain = 'qcater' and sct_sim = 'standard'" for execution against OLE DB provider "MSDASQL" for linked server "mfglive". [SQLSTATE 42000] (Error 7321) OLE DB provider "MSDASQL" for linked server "mfglive" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Server crash likely.". [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "mfglive" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Server crash likely.". [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "mfglive" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed.". [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "mfglive" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed.". [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "mfglive" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed.". [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "mfglive" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed.". [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "mfglive" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Unexpected Network Error. ErrNum = 10054". [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "mfglive" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed.". [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "mfglive" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed.". [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "mfglive" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed.". [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "mfglive" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed.". [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "mfglive" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed.". [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "mfglive" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed.". [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "mfglive" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Unexpected Network Error. ErrNum = 10054". [SQLSTATE 01000] (Error 7412). The step failed.

Here SQL linked server named mfglive tries to access a progress ODBC driver which connects to progress database and fails with this issue at 5AM,6AM,10PM,10.50PM. When I run this job during office hours it works without any issue. We are really not sure how this can happen suddenly. Also we found that, 2 jobs one pointing to teradata DB and other to progress have been running since 3 days, we identified them and killed those jobs. The one pointing to Teradata is getting rolledback since 1 day. I suspect this could have triggered this issue Kindly let me know if there could be any other which I need to look into.