topic Re: Network Error in Administration and Deployment

Network Error

japsas100 — Wed, 22 Sep 2021 18:49:25 GMT

Hello,

We are getting the below error while running the SAS DI jobs. Please advise?

ERROR: CLI cursor fetch error: [SAS][ODBC SQL Server Wire Protocol driver]Unexpected Network Error. ErrNum = 10060
ERROR: CLI close cursor error: [SAS][ODBC SQL Server Wire Protocol driver]Invalid transaction state.

Database: SQL server

SAS 9.4

Re: Network Error

gwootton — Wed, 22 Sep 2021 19:22:42 GMT

This looks like the ODBC driver is having trouble communicating with the SQL server rather than an issue with the SAS software.

Re: Network Error

japsas100 — Wed, 22 Sep 2021 19:25:20 GMT

Thanks @gwootton

What we need to check related to ODBC? Most of time job executed without any issue. However some time we are getting this kind of error.

Re: Network Error

RamsesSalinas — Wed, 22 Sep 2021 19:30:53 GMT

This is not a SAS problem, please check the following note: @http://knowledgebase.progress.com/articles/Article/000038104

Re: Network Error

gwootton — Wed, 22 Sep 2021 19:49:08 GMT

I would engage your network admin to review communication between the SQL server and ODBC client hosts.