cancel
Showing results for 
Search instead for 
Did you mean: 

Timeout on DataServices server

former_member202087
Active Participant
0 Kudos

We have been seeing the following issue occasionally and need some advice on where we can check for the issue.  The logs around the time of the failure do not seem to show any issues.  When we rerun the jobs they seem to complete without issue.

SQL submitted to ODBC data source <US5023SQL> resulted in error <[Microsoft][SQL Server Native Client 10.0]Communication link failure>. The SQL submitted is <select OBJECT_KEY, MACHINE, SERVER, TYPE, SERVICE, CONTAINER, INST_MACHINE, INST_SERVER, INST_SERVER_PORT, INST_REPO, INST_EXEC, INST_EXEC_KEY, RUN_SEQ, START_TIME, END_TIME, EXECUTION_TIME, STATUS, HAS_ERROR, IGNORE_ERROR,  NORM_MACHINE, NORM_SERVER, NORM_TYPE, NORM_SERVICE, NORM_CONTAINER, NORM_INST_MACHINE,  NORM_INST_SERVER, NORM_INST_REPO, NORM_INST_EXEC, SERVICE_ID  from AL_HISTORY where OBJECT_KEY = 101238>.

Thanks,

Ken

Accepted Solutions (0)

Answers (1)

Answers (1)

vnovozhilov
Employee
Employee
0 Kudos

Does that happen for a long running jobs?

Thank you,

Viacheslav.

former_member202087
Active Participant
0 Kudos

I think we figured it out in the case.  They had to restart the server and we were not made aware of it.