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 = 10060ERROR: CLI close cursor error: [SAS][ODBC SQL Server Wire Protocol driver]Invalid transaction state.
Database: SQL server
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.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
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.