Progress OpenEdge 10.2 driver output logfile

Posted by Roy77 on 07-Nov-2014 09:39

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

OpenEdge RDBMS - Forum

All Replies

Posted by Chandra Sekhar on 10-Nov-2014 03:13

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

[collapse]

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:

and the driver log says:

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.

[/collapse]

This thread is closed