C
Chandra Sekhar
Guest
Hi Roy, Your ODBC application is invoking ODBC SQLBrowseConnectW API to connect the server. This API returned with error 99 (SQL_NEED_DATA). After that, application invoking ODBC SQLGetDiagRecW API to know the error description. This API returned with error 100 (SQL_NO_DATA_FOUND). As per log file, same sequence of calls happened twice and both times SQLGetDiagRecW returned error 100 . As per ODBC specification, if SQLBrowseConnectW API return any errors/warnings, SQLGetDiagRecW API should return SUCCESS with complete error description. However here SQLGetDiagRecW API is returning SQL_NO_DATA_FOUND, which seems to me not correct. Looks like SQLSRV is crashed. Are there any protrace files generated? Are there any changes in application? Is customer noticed this error earlier or is it first time? Thanks and Regards, Chandu From: Roy77 [mailto:bounce-Roy77@community.progress.com] Sent: 07 November 2014 PM 09:10 To: TU.OE.RDBMS@community.progress.com Subject: [Technical Users - OE RDBMS] Progress OpenEdge 10.2 driver output logfile Progress OpenEdge 10.2 driver output logfile Thread created by Roy77 Ls, Does anyone can help me out interpreting a Progress OpenEdge 10.2 driver output logfile. Our business layer code generates the following exception: System.Data.Odbc.OdbcException (0x80131937): ERROR [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Unexpected Network Error. ErrNum = 10054 ERROR [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed. ERROR [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed. ERROR [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed. ERROR [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed. ERROR [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed. ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Server crash likely. and the driver log says: Ssms bbc-1644 ENTER SQLAllocHandle SQLSMALLINT 1 SQL_HANDLE_ENV SQLHANDLE 0x00000000 SQLHANDLE * 0x0019E558 Ssms bbc-1644 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 SQL_HANDLE_ENV SQLHANDLE 0x00000000 SQLHANDLE * 0x0019E558 ( 0x05433358) Ssms bbc-1644 ENTER SQLSetEnvAttr SQLHENV 0x05433358 SQLINTEGER 200 SQL_ATTR_ODBC_VERSION SQLPOINTER 3 SQL_OV_ODBC3 SQLINTEGER -5 Ssms bbc-1644 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 0x05433358 SQLINTEGER 200 SQL_ATTR_ODBC_VERSION SQLPOINTER 3 SQL_OV_ODBC3 SQLINTEGER -5 Ssms bbc-1644 ENTER SQLAllocHandle SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x05433358 SQLHANDLE * 0x0019E55C Ssms bbc-1644 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x05433358 SQLHANDLE * 0x0019E55C ( 0x05393F20) Ssms bbc-cec ENTER SQLAllocHandle SQLSMALLINT 1 SQL_HANDLE_ENV SQLHANDLE 0x00000000 SQLHANDLE * 0x055EF2BC Ssms bbc-cec EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 SQL_HANDLE_ENV SQLHANDLE 0x00000000 SQLHANDLE * 0x055EF2BC ( 0x054333D8) Ssms bbc-cec ENTER SQLSetEnvAttr SQLHENV 0x054333D8 SQLINTEGER 200 SQL_ATTR_ODBC_VERSION SQLPOINTER 3 SQL_OV_ODBC3 SQLINTEGER -5 Ssms bbc-cec EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 0x054333D8 SQLINTEGER 200 SQL_ATTR_ODBC_VERSION SQLPOINTER 3 SQL_OV_ODBC3 SQLINTEGER -5 Ssms bbc-cec ENTER SQLAllocHandle SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x054333D8 SQLHANDLE * 0x055EF2C0 Ssms bbc-cec EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x054333D8 SQLHANDLE * 0x055EF2C0 ( 0x05394260) Ssms bbc-cec ENTER SQLSetConnectAttrW SQLHDBC 0x05394260 SQLINTEGER 1241 unknown SQLPOINTER [Unknown attribute 1241] SQLINTEGER -6 Ssms bbc-cec EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 0x05394260 SQLINTEGER 1241 unknown SQLPOINTER [Unknown attribute 1241] SQLINTEGER -6 Ssms bbc-cec ENTER SQLSetConnectAttrW SQLHDBC 0x05394260 SQLINTEGER 1242 unknown SQLPOINTER [Unknown attribute 1242] SQLINTEGER -3 Ssms bbc-cec EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 0x05394260 SQLINTEGER 1242 unknown SQLPOINTER [Unknown attribute 1242] SQLINTEGER -3 Ssms bbc-cec ENTER SQLBrowseConnectW HDBC 0x05394260 WCHAR * 0x6C06B45C [ -3] "******\ 0" SWORD -3 WCHAR * 0x6C06B45C SWORD -3 SWORD * 0x00000000 Ssms bbc-cec EXIT SQLBrowseConnectW with return code 99 (SQL_NEED_DATA) HDBC 0x05394260 WCHAR * 0x6C06B45C [ -3] "******\ 0" SWORD -3 WCHAR * 0x6C06B45C SWORD -3 SWORD * 0x00000000 Ssms bbc-cec ENTER SQLGetDiagRecW SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x05394260 SQLSMALLINT 1 SQLWCHAR * 0x055EF274 SQLINTEGER * 0x00000000 SQLWCHAR * 0x05434BE0 SQLSMALLINT 256 SQLSMALLINT * 0x055EF2B8 Ssms bbc-cec EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND) SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x05394260 SQLSMALLINT 1 SQLWCHAR * 0x055EF274 SQLINTEGER * 0x00000000 SQLWCHAR * 0x05434BE0 SQLSMALLINT 256 SQLSMALLINT * 0x055EF2B8 Ssms bbc-cec ENTER SQLDisconnect HDBC 0x05394260 Ssms bbc-cec EXIT SQLDisconnect with return code 0 (SQL_SUCCESS) HDBC 0x05394260 Ssms bbc-cec ENTER SQLFreeHandle SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x05394260 Ssms bbc-cec EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x05394260 Ssms bbc-cec ENTER SQLFreeHandle SQLSMALLINT 1 SQL_HANDLE_ENV SQLHANDLE 0x054333D8 Ssms bbc-cec EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 SQL_HANDLE_ENV SQLHANDLE 0x054333D8 Ssms bbc-cec ENTER SQLAllocHandle SQLSMALLINT 1 SQL_HANDLE_ENV SQLHANDLE 0x00000000 SQLHANDLE * 0x055EF2BC Ssms bbc-cec EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 SQL_HANDLE_ENV SQLHANDLE 0x00000000 SQLHANDLE * 0x055EF2BC ( 0x054333D8) Ssms bbc-cec ENTER SQLSetEnvAttr SQLHENV 0x054333D8 SQLINTEGER 200 SQL_ATTR_ODBC_VERSION SQLPOINTER 3 SQL_OV_ODBC3 SQLINTEGER -5 Ssms bbc-cec EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 0x054333D8 SQLINTEGER 200 SQL_ATTR_ODBC_VERSION SQLPOINTER 3 SQL_OV_ODBC3 SQLINTEGER -5 Ssms bbc-cec ENTER SQLAllocHandle SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x054333D8 SQLHANDLE * 0x055EF2C0 Ssms bbc-cec EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x054333D8 SQLHANDLE * 0x055EF2C0 ( 0x05434C98) Ssms bbc-cec ENTER SQLSetConnectAttrW SQLHDBC 0x05434C98 SQLINTEGER 1241 unknown SQLPOINTER [Unknown attribute 1241] SQLINTEGER -6 Ssms bbc-cec EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 0x05434C98 SQLINTEGER 1241 unknown SQLPOINTER [Unknown attribute 1241] SQLINTEGER -6 Ssms bbc-cec ENTER SQLSetConnectAttrW SQLHDBC 0x05434C98 SQLINTEGER 1242 unknown SQLPOINTER [Unknown attribute 1242] SQLINTEGER -3 Ssms bbc-cec EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 0x05434C98 SQLINTEGER 1242 unknown SQLPOINTER [Unknown attribute 1242] SQLINTEGER -3 Ssms bbc-cec ENTER SQLBrowseConnectW HDBC 0x05434C98 WCHAR * 0x6C06B45C [ -3] "******\ 0" SWORD -3 WCHAR * 0x6C06B45C SWORD -3 SWORD * 0x00000000 Ssms bbc-cec EXIT SQLBrowseConnectW with return code 99 (SQL_NEED_DATA) HDBC 0x05434C98 WCHAR * 0x6C06B45C [ -3] "******\ 0" SWORD -3 WCHAR * 0x6C06B45C SWORD -3 SWORD * 0x00000000 Ssms bbc-cec ENTER SQLGetDiagRecW SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x05434C98 SQLSMALLINT 1 SQLWCHAR * 0x055EF274 SQLINTEGER * 0x00000000 SQLWCHAR * 0x05394260 SQLSMALLINT 256 SQLSMALLINT * 0x055EF2B8 Ssms bbc-cec EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND) SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x05434C98 SQLSMALLINT 1 SQLWCHAR * 0x055EF274 SQLINTEGER * 0x00000000 SQLWCHAR * 0x05394260 SQLSMALLINT 256 SQLSMALLINT * 0x055EF2B8 Ssms bbc-cec ENTER SQLDisconnect HDBC 0x05434C98 Ssms bbc-cec EXIT SQLDisconnect with return code 0 (SQL_SUCCESS) HDBC 0x05434C98 Ssms bbc-cec ENTER SQLFreeHandle SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x05434C98 Ssms bbc-cec EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x05434C98 Ssms bbc-cec ENTER SQLFreeHandle SQLSMALLINT 1 SQL_HANDLE_ENV SQLHANDLE 0x054333D8 Ssms bbc-cec EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 SQL_HANDLE_ENV SQLHANDLE 0x054333D8 Is there someone who can tell something about the possible cause? Kind regards Roy Molenaar Stop receiving emails on this subject. Flag this post as spam/abuse.
Continue reading...
Continue reading...