Intermittent ODBC SQL Server Wire Protocol driver error
Posted: Mon Mar 19, 2018 3:27 pm
We are getting some strange behavior while running our jobs. They seem to fail intermittently. Sometimes they complete. When they do fail and we rerun them, then it ends up running through. Here is a sample of an error that I'm getting:
tblTable: ODBC function "SQLEndTran(SQL_ROLLBACK)" reported: SQLSTATE = 08S01: Native Error Code = 0: Msg = [IBM (Datadirect OEM)][ODBC SQL Server Wire Protocol driver]Unexpected Network Error. ErrNum = 10054 (CC_OdbcConnection::rollback, file CC_OdbcConnection.cpp, line 1,265) ODBC function "SQLEndTran(SQL_ROLLBACK)" reported: SQLSTATE = 08S01: Native Error Code = 0: Msg = [IBM (Datadirect OEM)][ODBC SQL Server Wire Protocol driver]Unexpected Network Error. ErrNum = 10054 (CC_OdbcConnection::rollback, file CC_OdbcConnection.cpp, line 1,265)
Any ideas?
tblTable: ODBC function "SQLEndTran(SQL_ROLLBACK)" reported: SQLSTATE = 08S01: Native Error Code = 0: Msg = [IBM (Datadirect OEM)][ODBC SQL Server Wire Protocol driver]Unexpected Network Error. ErrNum = 10054 (CC_OdbcConnection::rollback, file CC_OdbcConnection.cpp, line 1,265) ODBC function "SQLEndTran(SQL_ROLLBACK)" reported: SQLSTATE = 08S01: Native Error Code = 0: Msg = [IBM (Datadirect OEM)][ODBC SQL Server Wire Protocol driver]Unexpected Network Error. ErrNum = 10054 (CC_OdbcConnection::rollback, file CC_OdbcConnection.cpp, line 1,265)
Any ideas?