I am using NotesSQL 3.02j and the Easysoft JDBC-ODBC Bridge to access Lotus Notes data from BIRT designed reports installed under Tomcat. I am trying to debug intermittent ODBC data connection problems.
I have been unable to get a NotesSQL trace of the problem (see other forum post for turning on the NotesSQL trace via regedit), but I have captured the ODBC trace. One of the errors in the trace is “DIAG [IM005] [Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_DBC failed (0)”. An occurrence of this error was supposedly resolved in NotesSQL 3.02j, but I may have encountered a different situation.
Also, one time when the connection problem occurred, a nsqle32.adr file was created in the IBM_TECHNICAL_SUPPORT directory and I’m not sure if the information from that file is relevant to this problem (see below).
This is an intermittent problem that we would like to resolve before we put our BIRT reports server into a production environment. Below is the segment of the ODBC trace that indicates the problems with the data connection.
Does anyone know what the cause of this intermittent connection problem might be?
ODBC Trace:
esjobserver c8c-cbc ENTER SQLAllocHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 00000000
SQLHANDLE * 0012F5AC
esjobserver c8c-cbc EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 00000000
SQLHANDLE * 0x0012F5AC ( 0x006c1788)
esjobserver c8c-cbc ENTER SQLFreeHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 006C1788
esjobserver c8c-cbc EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 006C1788
esjobserver c8c-cbc ENTER SQLAllocHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 00000000
SQLHANDLE * 00C38E48
esjobserver c8c-cbc EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 00000000
SQLHANDLE * 0x00C38E48 ( 0x006c1788)
esjobserver c8c-cbc ENTER SQLSetEnvAttr
SQLHENV 006C1788
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 0x00000002
SQLINTEGER 0
esjobserver c8c-cbc EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 006C1788
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 0x00000002 (BADMEM)
SQLINTEGER 0
esjobserver c8c-cbc ENTER SQLAllocHandle
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 006C1788
SQLHANDLE * 0012EA94
esjobserver c8c-cbc EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 006C1788
SQLHANDLE * 0x0012EA94 ( 0x006c1890)
esjobserver c8c-cbc ENTER SQLDriverConnectW
HDBC 006C1890
HWND 00000000
WCHAR * 0x48897CF4 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x48897CF4
SWORD 2
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
esjobserver c8c-cbc EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 006C1890
HWND 00000000
WCHAR * 0x48897CF4 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x48897CF4
SWORD 2
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [IM005] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed (0)
esjobserver c8c-cbc ENTER SQLGetDiagRecW
SQLSMALLINT 2
SQLHANDLE 006C1890
SQLSMALLINT 1
SQLWCHAR * 0x0012E7E8 (NYI)
SQLINTEGER * 0x0012E830
SQLWCHAR * 0x006C1998 (NYI)
SQLSMALLINT 528
SQLSMALLINT * 0x0012E836
esjobserver c8c-cbc EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2
SQLHANDLE 006C1890
SQLSMALLINT 1
SQLWCHAR * 0x0012E7E8 (NYI)
SQLINTEGER * 0x0012E830 (0)
SQLWCHAR * 0x006C1998 (NYI)
SQLSMALLINT 528
SQLSMALLINT * 0x0012E836 (81)
esjobserver c8c-cbc ENTER SQLGetDiagRecW
SQLSMALLINT 2
SQLHANDLE 006C1890
SQLSMALLINT 2
SQLWCHAR * 0x0012E7E8 (NYI)
SQLINTEGER * 0x0012E830
SQLWCHAR * 0x006C1998 (NYI)
SQLSMALLINT 528
SQLSMALLINT * 0x0012E836
esjobserver c8c-cbc EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
SQLSMALLINT 2
SQLHANDLE 006C1890
SQLSMALLINT 2
SQLWCHAR * 0x0012E7E8 (NYI)
SQLINTEGER * 0x0012E830
SQLWCHAR * 0x006C1998 (NYI)
SQLSMALLINT 528
SQLSMALLINT * 0x0012E836
esjobserver c8c-cbc ENTER SQLDisconnect
HDBC 006C1890
esjobserver c8c-cbc EXIT SQLDisconnect with return code -1 (SQL_ERROR)
HDBC 006C1890
DIAG [08003] [Microsoft][ODBC Driver Manager] Connection not open (0)
esjobserver c8c-cbc ENTER SQLGetDiagRecW
SQLSMALLINT 2
SQLHANDLE 006C1890
SQLSMALLINT 1
SQLWCHAR * 0x0012F26C (NYI)
SQLINTEGER * 0x0012F2B4
SQLWCHAR * 0x006C1998 (NYI)
SQLSMALLINT 528
SQLSMALLINT * 0x0012F2BA
esjobserver c8c-cbc EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2
SQLHANDLE 006C1890
SQLSMALLINT 1
SQLWCHAR * 0x0012F26C (NYI)
SQLINTEGER * 0x0012F2B4 (0)
SQLWCHAR * 0x006C1998 (NYI)
SQLSMALLINT 528
SQLSMALLINT * 0x0012F2BA (52)
esjobserver c8c-cbc ENTER SQLGetDiagRecW
SQLSMALLINT 2
SQLHANDLE 006C1890
SQLSMALLINT 2
SQLWCHAR * 0x0012F26C (NYI)
SQLINTEGER * 0x0012F2B4
SQLWCHAR * 0x006C1998 (NYI)
SQLSMALLINT 528
SQLSMALLINT * 0x0012F2BA
esjobserver c8c-cbc EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
SQLSMALLINT 2
SQLHANDLE 006C1890
SQLSMALLINT 2
SQLWCHAR * 0x0012F26C (NYI)
SQLINTEGER * 0x0012F2B4
SQLWCHAR * 0x006C1998 (NYI)
SQLSMALLINT 528
SQLSMALLINT * 0x0012F2BA
esjobserver c8c-cbc ENTER SQLFreeHandle
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 006C1890
esjobserver c8c-cbc EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 006C1890
esjobserver c8c-cbc ENTER SQLFreeHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 006C1788
nsqle32.adr:
Process ID 752/2F0
Module Load Addresses:
C:\NotesSQL\nsqle32.exe 0x400000 - 0x418000
C:\WINDOWS\system32\ntdll.dll 0x7C800000 - 0x7C8C0000
C:\WINDOWS\system32\kernel32.dll 0x77E40000 - 0x77F42000
C:\WINDOWS\system32\USER32.dll 0x77380000 - 0x77411000
C:\WINDOWS\system32\GDI32.dll 0x77C00000 - 0x77C48000
C:\WINDOWS\system32\ADVAPI32.dll 0x77F50000 - 0x77FEB000
C:\WINDOWS\system32\RPCRT4.dll 0x77C50000 - 0x77CEF000
C:\WINDOWS\system32\Secur32.dll 0x76F50000 - 0x76F63000
C:\WINDOWS\system32\IMM32.DLL 0x76290000 - 0x762AD000
C:\NotesSQL\NSQLV32.DLL 0x10000000 - 0x1008E000
C:\Lotus\Domino\nNOTES.dll 0x60000000 - 0x60EEC000
C:\Lotus\Domino\nxmlproc.dll 0x6F0000 - 0xA04000
C:\WINDOWS\system32\MSVCP71.dll 0x7C3A0000 - 0x7C41B000
C:\WINDOWS\system32\MSVCR71.dll 0x7C340000 - 0x7C396000
C:\Lotus\Domino\js32.dll 0x62B50000 - 0x62BA9000
C:\Lotus\Domino\NLSCCSTR.DLL 0x62C50000 - 0x62D48000
C:\WINDOWS\system32\SHFOLDER.dll 0x766D0000 - 0x766D9000
C:\WINDOWS\system32\msvcrt.dll 0x77BA0000 - 0x77BFA000
C:\WINDOWS\system32\OLEAUT32.dll 0x77D00000 - 0x77D8B000
C:\WINDOWS\system32\ole32.dll 0x77670000 - 0x777A9000
C:\WINDOWS\system32\comdlg32.dll 0x762B0000 - 0x762F9000
C:\WINDOWS\system32\SHLWAPI.dll 0x77DA0000 - 0x77DF2000
C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_5.82.3790.3959_x-ww_78FCF8D0\COMCTL32.dll 0x77530000 - 0x775C7000
C:\WINDOWS\system32\SHELL32.dll 0x7C8D0000 - 0x7D0CF000
C:\WINDOWS\system32\WS2_32.dll 0x71C00000 - 0x71C17000
C:\WINDOWS\system32\WS2HELP.dll 0x71BF0000 - 0x71BF8000
C:\Lotus\Domino\ndgts.dll 0x63460000 - 0x63466000
C:\WINDOWS\system32\odbccp32.dll 0x4D7A0000 - 0x4D7BA000
C:\WINDOWS\system32\VERSION.dll 0x77B90000 - 0x77B98000
C:\WINDOWS\system32\MPR.dll 0x71BD0000 - 0x71BE1000
C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.3790.3959_x-ww_D8713E55\comctl32.dll 0x77420000 - 0x77523000
C:\WINDOWS\system32\odbcint.dll 0xCA0000 - 0xCB7000
C:\Lotus\Domino\NSTRINGS.DLL 0x62DD0000 - 0x62ECB000
C:\WINDOWS\system32\PSAPI.DLL 0x76B70000 - 0x76B7B000