BookmarkSubscribeRSS Feed
japsas100
Pyrite | Level 9

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

4 REPLIES 4
gwootton
SAS Super FREQ
This looks like the ODBC driver is having trouble communicating with the SQL server rather than an issue with the SAS software.
--
Greg Wootton | Principal Systems Technical Support Engineer
japsas100
Pyrite | Level 9

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.

RamsesSalinas
Fluorite | Level 6
This is not a SAS problem, please check the following note: @http://knowledgebase.progress.com/articles/Article/000038104
gwootton
SAS Super FREQ
I would engage your network admin to review communication between the SQL server and ODBC client hosts.
--
Greg Wootton | Principal Systems Technical Support Engineer

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 789 views
  • 3 likes
  • 3 in conversation